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