update the tables in to two server using a single ssis package

Tags:
SQL Server 2005
SSIS Package 2005
i have 2 servers server A and Server B.i have written a package in server A.i want to update the tables in both server A and B.when i execute the package from BIDS it is working fine when i schedule the package in agent job i am getting the below error.

 Executed as user: RICRDWDEVSYSTEM. ...ckage Utility Version 9.00.4035.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 9:25:07 AM Error: 2012-04-03 09:25:23.00 Code: 0xC0202009 Source: SAPNew Connection manager "RICRDW.crdw.dbo" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E4D Description: "Login failed for user 'GTKRICRDWDEV$'.". End Error Error: 2012-04-03 09:25:23.00 Code: 0xC00291EC Source: Truncate Import Tables (RICRDWcrdw) Execute SQL Task Description: Failed to acquire connection "RICRDW.crdw.dbo". Connection may not be configured correctly or you may not have the right permissions on this connection. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 9:25:07 AM Finished: 9:25:23 AM Elapsed: 15.656 seconds. The package execution failed. The step failed.



Software/Hardware used:
sql server 2005 and BIDS

Answer Wiki

Thanks. We'll let you know when a new response is added.

Your SSIS package should have both server/database combinations as 2 different connections
Make sure the profile used to execute the package has update/insert permissions to both server/database/table

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following