SSIS FTP Task

[TechAbhiVaray]

I have a table which i have stored as a csv in the Data Flow task. Now i am trying to upload this csv to a FTP Server. I was successful in storing the file in csv but the FTP Task is not working. I have the server name, the username and password and also the root folder. Can anyone help on this?

 

[mrdenny]

The native FTP task sucks. There's some third party components which do the job much better. You can also use a batch file to upload the file.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog