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

Many of the data flow tasks include the option to redirect errors down a different path. These bad rows can then be logged and reviewed later to see what the issue was. Let's look at an example.

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

Designed and integrated into SSIS, Attunity SQL Server -CDC for SSIS integrates SQL Server data efficiently and in real-time. Dramatically simplifying the creation of CDC solutions, accelerating ...

Microsoft SQL Server's relational engine has offered new instrumentation that improves by light years with each new release. The introduction of Dynamic Management Views (DMVs) in SQL Server 2005 ...