Upload a file using FTP with SSIS

0
votes

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?

1
sql-server-2005ssis
Please clarify what you mean when you say you can't get the folders. – John Saunders

1 Answers

1
votes

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.