question

gauravsinghkr avatar image
gauravsinghkr asked

SSIS Job failed on different environment while running on Local

Hi, Need you help. I deployed the SSIS project which downloads csv file from server and save into local drive, and then upload into a table at Server. I created two environments - (1) For Local system, (2) Server system package is running successfully at both environments using execute option. Now, created and scheduled a job which is working fine at local, however failed if I use server environment. The error is - "Executed as user: NT Service\SQLSERVERAGENT. Microsoft (R) SQL Server Execute Package Utility Version and so on..." When I goto path Integration Services Project -> Reports -> Standard Reports -> All Executions, it shows detailed message - "Data Flow Task:Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "LocalHost.DBLEARN" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. Data Flow Task:Error: OLE DB Destination failed validation and returned error code 0xC020801C." In both environment Caller is NT Service\SQLSERVERAGENT, and job failed on Server. Please suggest. Thanks!
ssissql-server-agentjob failureenvironment
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Is that the entire message or is there more to it?
0 Likes 0 ·
gauravsinghkr avatar image
gauravsinghkr answered
[link text][1] [1]: /storage/temp/3973-report.docx

report.docx (34.2 KiB)
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

gauravsinghkr avatar image
gauravsinghkr answered
Please review attached word document which shows complete process of execution. It works fine when I execute it through right click on package, but the job failed. However, the job works fine on my Local environment. I think user - NT SERVICE\SQLSERVERAGENT doesn't have permissions to work on server.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.