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

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

I'm importing a flat file into SSIS which needs to be split into two tables. In my input file I have a few columns (just an example.. I'm not really working with boxes): Box contents, box weight, box ...

Businesses often have to move data around the way construction companies move dirt. A tool like SSIS, designed to transfer and transform large amounts of data, helps take care of the heavy lifting.