Rolling a script to perform the FTP functions will allow you more flexibility than the built-in task and more productivity. In my last post, I talked about setting up and using FTP in an SSIS package.

Every business intelligence solution needs data, which might come from a variety of sources and in different formats. Microsoft SQL Server Integration Services, or SSIS, allows you to extract data ...