> 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)
>

"Allan Mitchell" wrote:

> 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)
> >
>
>