Write Record to table as XML from RecordSet destination
Is it possible to write out each record from a recordset destination in SSIS as an XML field into SQL Server? How can this be done in either case?

Answer Question   |  October 27, 2010  3:19 PM
Recordset Destination, SQL Server, SQL Server Dataset, SSIS, XML

Loading an XML file’s dataset into an existing SQL Server 2005 table
I have a dataset in an XML file that needs to load into an existing SQL Server 2005 table. It also needs to check existing rows before loading. What will be a good way to do that?

Answer Question   |  April 20, 2009  2:52 PM
SQL Server 2005, SQL Server Dataset, SQL Server tables, XML