Category Archives: SQL

Extracting large XML documents from a database

I had a scenario where I had to extract a large XML document  from a stored procedure. The business requirement was to extract the data from several tables as xml that conforms to a XSD document, write it to a … Continue reading

Posted in SQL, SSIS | Tagged | Leave a comment

Referencing a custom component inside a SSIS Script Task

If you need to access a custom component from a Script Task, the component must first be signed and gac’ed. After it has been gac’ed, the assembly must also be copied to  the .net2.0 framework under the windows directory. The … Continue reading

Posted in SQL | Leave a comment

SQL2008 MARS & Parallel Framework in .Net4

I had a scenario where I wanted to query several database tables at once and process the data as fast as possible using a single database connection. After some though I decided to look at MARS ( multiple active result … Continue reading

Posted in SQL | Leave a comment