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.<BR><BR>The simple method would appear to be using SQL Server's SSIS ...

The templates are stored in XML files. To configure logging using the Configure SSIS Logs dialog box Enable the package and its tasks for logging. Logging can occur at the package, the container, and ...

Step 2: Use the SSIS Data Feed Publishing Wizard to Publish SSIS Package as a SQL View In this step, you will use the SQL Server Integration Services (SSIS) Data Feed Publishing Wizard to publish the ...

Today’s guest blogger is CRM MVP Darren Liu who is a CRM specialist at Sonoma Partners in Chicago. I wrote a blog article last year on how to integrate Microsoft Dynamics CRM using SQL Integration ...

Here's a quick trick to keep things running. By Eric Johnson 04/12/2010 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.