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

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.