I'm trying to use the FTP task to send files to a vendor. The vendor has a
testing and production environment setup. I cannot figure out how to create
the FTP connection that will send the file to the vendor's testing server
when the SSIS package is executed in my testing environment. The same
package should be able to send files to the vendor's production server,
without any modification to the package, when the package is run in my
production environment. Does anyone know if that's possible?

Thanks.

How about using configurations? You would have different configuration
settings for each environment. Make the FTP Connection server property one
of the items you export/set through the configuration.

Have a look at Configurations in Books Online if you are not familiar with
them.

--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"Alex Fung" <AlexFung (AT) discussions (DOT) microsoft.com> wrote