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!
[link text][1] [1]: /storage/temp/3973-report.docx
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.
21 People are following this question.
