SQL Server connection problem with SSIS

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

SQL Server connection problem with SSIS

Author

Topic

sanjnep
Posting Yak Master

191 Posts

Posted - 2008-12-21 : 20:10:09

we have 2 SQL Servers SQLIRVN2000A and SQLIRVN2000B. I have written one SSIS package which has connection string to connect server SQLIRVN2000A. It works fine when I ran it from my desktop and connects to server SQLIRVN2000A correctly.When I put the SSIS package on server SQLIRVN2000A itself and ran it from job it always connect to SQLIRVN2000B and pulls the data from SQLIRVN2000B.Please help me why the connection points to SQLIRVN2000B instead of SQLIRVN2000A?
Thanks
ss

Sanjeev Shrestha
12/17/1971

hey001us
Posting Yak Master

185 Posts

Posted - 2008-12-21 : 22:36:59

did you deleted old one and installed new? and check the connection manager property of dtsx at SQLIRVN2000A.

hey

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources