SSIS package failed on Server - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

SSIS package failed on Server

Author

Topic

whizsql
Starting Member

17 Posts

Posted - 2008-12-19 : 17:19:33

Hi, The ssis import export package I created worked fine on local machine using XML config file..used sa account for OLEDB connection.

But, when I deployed it to Server box, it failed during manual execution showing connectivity errors such as

SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "SourceConnectionOLEDB" failed with error code 0xC0202009

Also, shows source: act_log validation failed with error code 0xC020801C

SSIS Error Code DTS_E_OLEDBERROR. An OLE Database error has
occurred. Error code: 0x80040E4D.
An OLE Database record is available. Source: "Microsoft OLEDB Provider for SQL Server"
Hresult: 0x80040E4D Description: "Login failed for user 'sa'.".

What is causing these issues? Any idea on these?

Thanks !

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-12-19 : 18:15:48

Just as the error message says!
You have not provided the correct password for the sa account.

E 12°55'05.63"
N 56°04'39.26"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources