Using SSIS's graphical designer, the task is straightforward, if not entirely intuitive. Create an Integration Project with a Data Flow Task Create a new project.

I'm trying to take an XML document and dump the contents into a table. 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 ...

Using the FTP Task in an SSIS Package. Pulling data from different sources is easy. One of the easiest is via the FTP Task. By Eric Johnson; 05/17/2010; When designing SSIS packages, you will find ...