The Business Intelligence Blog

January 21, 2010

Troubleshooting Integration Srevices Package Execution

Troubleshooting: SSIS Package Execution Using SQL Server Agent (SQL Server Video)


1 Comment »

  1. Hi there, i still get this error, i’ve already deployed JOB under the same user used to save the package but no results. Any help? Thanks.

    “Microsoft SQL Native Client” Hresult: 0x80040E4D Description: “Login failed for user ‘sa3’.”. End Error Error: 2010-05-26 15:10:39.33 Code: 0xC020801C Source: Data Flow Task Source – Query [1] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager “SourceConnectionOLEDB” failed with error code 0xC0202009.

    Comment by A.Foxy — May 26, 2010 @ 9:21 am

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

Create a free website or blog at

%d bloggers like this: