dbTalk Databases Forums  

Running dtsx package on sql server 2005 - FTP Task

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Running dtsx package on sql server 2005 - FTP Task in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Anthony
 
Posts: n/a

Default Running dtsx package on sql server 2005 - FTP Task - 07-06-2006 , 03:56 AM






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)

--
Anthony
..NET Developper

Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: Running dtsx package on sql server 2005 - FTP Task - 07-06-2006 , 12:39 PM






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

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




Reply With Quote
  #3  
Old   
Anthony
 
Posts: n/a

Default Re: Running dtsx package on sql server 2005 - FTP Task - 07-07-2006 , 01:45 AM



Thxs, i will try this solution.

Have a good day

--
Anthony
Développeur .NET


"Allan Mitchell" wrote:

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





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.