![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
I have set a dtsx package with integration services. But when you want to create a job which execute package on sql server 2005, you lost all passwords for connection manager. You can set password for database connection writing the connection string in the connection manager tab. But for FTP Task ??? I can't set a password for this task. It's really boring. Thanks, PS: sorry for my english but i'm french. (Allez la France ^^, championne du monde) |
#3
| |||
| |||
|
|
Hello Anthony, For the ServerPassword property of the FTP ConnectionManager you should be using Configurations. As to why sensitive information is not stored with your package you need to take a look at the ProtectionLevel of the package itself. Allan Mitchell www.SQLDTS.com www.SQLIS.com www.Konesans.com I have set a dtsx package with integration services. But when you want to create a job which execute package on sql server 2005, you lost all passwords for connection manager. You can set password for database connection writing the connection string in the connection manager tab. But for FTP Task ??? I can't set a password for this task. It's really boring. Thanks, PS: sorry for my english but i'm french. (Allez la France ^^, championne du monde) |
![]() |
| Thread Tools | |
| Display Modes | |
| |