CODEWITHSUNDEEP
sql-server-2005ssis
red
red

Reputation:

Upload a file using FTP with SSIS

I need to upload a file using an FTP task in SQL Server 2005 SSIS. While uploading I am unable to get the folders created on the FTP server.

Is there any other solution in SSIS for uploading a file to the FTP server?

Upvotes: 0

Views: 1677

Answers (1)

Chris Shaffer
Chris Shaffer

Reputation: 32575

Quite often when I need to use FTP in a DTS or SSIS package, I make a text file with the commands I want executed and then use an "Execute Process" task to run "ftp.exe /s:mycommands.txt". This can give you a little more control over what happens during the ftp connection.

Upvotes: 1

Related Questions