Q:

How do I make SSIS FTP task execute a FTP script rather than just upload a file?

I am working on a SSIS package that extracts some data from DB to a file then uploads it to a FTP server. I need to execute several FTP commands but seems like the SSIS FTP task only allows me to specify source & destination locations.
Does any one know how to make SSIS execute a FTP script without having to create a Script Task and write VB.NET code?

A:

Unfortunately no, I think you might need to use a script task. You should be able to find a .Net FTP library to re-use (adding it as a reference), and you can store user / pass / connection information in variables and access it within the script for maximum portability / maintainability.

