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 |
|
yatty.sid
Starting Member
2 Posts |
 Posted - 2010-11-11 : 09:00:16
|
| Am in India and my server is in US. I have few DTSX packages for my data migration. Source and destination server is the same IP 192.168.xxx.xx(US) . Now if I run it from my local machine, its running perfectly. But when i try to run it through remote desktop on my server 192.168.xxx.xx (which is windows server 2008 R2 64bit OS), it fails and gives me this error:"ssis error code dts_e_cannotacquireconnectionfromconnectionmanager" error code is 0xc0202009.My local machine is XP SP3.Am new to this DTS packages so please help me accordingly. |
|
|
yatty.sid
Starting Member
2 Posts |
Posted - 2010-11-12 : 00:06:39
|
| got it. Encryption with user key problem. For those who get the same above error, try using the option in Protection Level, "ENCRYPT WITH USER KEY". And then while deploying either provide the password in the Command Line as a parameter /DECRYPT qwerty where qwerty is the password. If you do not enter password, and just leave the option decrypt, then it will ask for password while executing the package.Thanks |
 |
|
|
|
|
|
SSIS package execution on remote server