FTP Task Approach - Integration Services (SSIS) and DTS - LearnSqlServer.com's SQL Server Forums

Member of the LearnItFirst.com Video Training Network	\| LearnSqlServer.com \| SQL SSIS Training \| SQL Programming Tutorials \|

Welcome Guest

Search | New Posts | Members | Log In | Register

LearnSqlServer.com's SQL Server Forums » SQL Server Database Administration » Integration Services (SSIS) and DTS » FTP Task Approach

FTP Task Approach

Options

Previous Topic · Next Topic

xtreemnet

Posted: Sunday, October 07, 2007 4:10:26 PM

Rank: Fledgling

Joined: 6/26/2007
Posts: 10
Points: -170
Location: New Zealand

Hi,

Can someone please let me know what is the best way to create a package having an FTP task? I created a package first with "DonotSaveSensitive" as I would normally. But it failed on the server, because it did not find the fpt login password. I had to use the option "EncryptAllWithPassword" to succcessfully deploy it on the server. Everytime the package is opened it needs a password. The project needs to be added to source safe. So I was wondering if there is anyway I can do without the password.

Thanks,

wdismukes

Posted: Sunday, October 07, 2007 5:18:02 PM

Rank: PFY

Joined: 5/3/2007
Posts: 20
Points: -37
Location: Houston, Texas

The posts near the bottom of the following link might help:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=148&messageid=278800

I did not deploy my ftp package, though. I just run it interactively from BIDS.

xtreemnet

Posted: Monday, October 08, 2007 7:38:12 PM

Rank: Fledgling

Joined: 6/26/2007
Posts: 10
Points: -170
Location: New Zealand

Hi wdismukes,

That's exactly what I did. But I wanted to know if this is the best way.

Thanks

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.