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.
| Author |
Topic |
|
farkie
Starting Member
1 Post |
 Posted - 2009-08-11 : 13:05:08
|
| I am new to SSIS packages and hope someone can help, there has to be an easy way to do this. I am trying to perform a data flow task between two servers that both use windows authentication and where my ids are different on each. So I am creating on server one using windows authentication so since I am logged in it works. Now I am trying to create a connection to my second server where my id and password are totally different. Unfortunately I have no control what so ever over the servers, and to try to change it is like an act of God. So any help you all can provide will be greatly appreciated.Jim |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-08-12 : 12:52:06
|
| Create a linked server on the server that you can authenticate. And set your remote user and password.And change you SSIS package connection to use the linked server. |
 |
|
|
|
|
|
Windows Authentication in Connection Mgr