Monthly Archives: February 2013

SSIS Location of currently running package

I have been wanting figure this out for a while.  Here is the problem.  You run your package in a package that is deployed using the SQL 2012 Project deployment model.  You want to get the folder and project that … Continue reading

Posted in Uncategorized | Tagged , , | Leave a comment

Shredding multiline column using xml

I had an ETL project to copydata from one SQL Server to another. The conversion rules, the data constraints and other metadata were in an Excel spreadsheet. Many of the cells consisted of multiple rows of data. But how to … Continue reading

Posted in Uncategorized | Tagged , , | Leave a comment