Monthly Archives: December 2007

SSIS Slow Down Performance Script Component

I’ve been meaning to post this for a while, but real life keeps intruding. I did a presentation on SSIS performance for the Charlotte SQL Server User Group at the end of November. It went well, though I was trying … Continue reading

Posted in Uncategorized | Comments Off on SSIS Slow Down Performance Script Component

Null Date Bug Fixed in SSIS

A few months back I reported a minor but annoying bug in the way NULL dates are handled in SSIS. It’s documented here, but basically, if you use an Execute SQL Task to set a DateTime variable to NULL, the … Continue reading

Posted in Uncategorized | Comments Off on Null Date Bug Fixed in SSIS

Fun with SSIS Configurations

As part of my standard approach (and the one used by Mariner), I use configurations in SSIS quite heavily. My preference is to use the SQL Server configuration type, since it keeps all the configurations in one place. XML configurations … Continue reading

Posted in Uncategorized | Comments Off on Fun with SSIS Configurations