x

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!

more ▼

asked Feb 08 at 06:32 PM in Default

avatar image

gauravsinghkr
11 1

Is that the entire message or is there more to it?

Feb 09 at 08:30 PM JohnM
(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first
report.docx (35.1 kB)
more ▼

answered Feb 16 at 11:06 AM

avatar image

gauravsinghkr
11 1

(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered Feb 16 at 11:10 AM

avatar image

gauravsinghkr
11 1

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1212
x18
x8
x4

asked: Feb 08 at 06:32 PM

Seen: 83 times

Last Updated: Feb 16 at 11:10 AM

Copyright 2017 Redgate Software. Privacy Policy