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

Getting Dynamic in SSIS Queries. When you start working with SQL Server and SSIS, it won't be long before you find yourself wishing you could change bits of SQL queries dynamically.

Execute SQL tasks run stored procedures or SQL queries from SSIS packages. ... as well as to prepare and truncate data and to return result sets. ... Switch to the Control Flow design window, ...

When building an SSIS package, you probably find that a lot of the time you don't want one bad row to blow up the whole ETL. Many of the data flow tasks include the option to redirect errors down ...

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