In my last post, I talked about setting up and using FTP in an SSIS package. I talked specifically about using the FTP Task in the control flow and how it is slightly limited in its functionality.

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 ...