|
developed SSIS package in sql2008 with saved connection and running from there ok, now using vs2012 to call the package(saved file .dtsx) on the same machine, result error, any idea? "SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D.\ r\nAn OLE DB record is available. Source: \"Microsoft SQL Server Native Client 10.0\" Hresult: 0x80040E4D Description: \"Login failed for user 'sa'.\".\r\nFailed to acquire connection \"dso-www-pri.REX_BASE.sa\". Connection may not be configured correctly or you may not have the right permissions on this connection.\r\nSSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D.\r\nAn OLE DB record is available. Source: \"Microsoft SQL Server Native Client 10.0\" Hresult: 0x80040E4D Description: \"Login failed for user 'sa'.\".\r\nFailed to acquire connection \"dso-www-pri.REX_BASE.sa\". Connection may not be configured correctly or you may not have the right permissions on this connection.\r\n" |
