One of the easiest is via the FTP Task. By Eric Johnson 05/17/2010 When designing SSIS packages, you will find that you often have to pull data from many different sources.

Not as XML using the SQL Server 2005 XML datatype, but as the parsed data values into a table with a column for each element.<BR><BR>The simple method would appear to be using SQL Server's SSIS ...

Launch the SSIS Designer application from the Windows Start menu, and then open the existing package containing the Execute SQL task that you wish to change. Switch to the Control Flow design ...

BlueFinity's new mv.SSIS product provides a tightly integrated extension to the native SSIS environment, allowing developers to incorporate MultiValue data sources into their existing or new SSIS ...