Category: Business Intelligence

1

SSIS Configurations: When and How

Configurations in SSIS are a lovely tool that when implemented correctly can greatly reduce package maintenance.  It is very possible to over configure a package, so be sure that you only do what you...

SSIS Webinar Recording Is Up 6

SSIS Webinar Recording Is Up

I want to say a huge thank you to everyone who attended the webinar from Pragmatic Works (website) that I did on Tuesday.  If you missed it the topic was Dynamic SSIS: Configurations, Expressions...

5

A Caution About Checkpoints

Checkpoints in SSIS are a great tool and they definitely have their place.  The downside to them is that they are not so good when you start talking about parallel processes or containers.  What...

Pre-Compiled Script Task Error in SSIS 2005 0

Pre-Compiled Script Task Error in SSIS 2005

There is an issue with script tasks in SSIS 2005 that could come up occasionally.  It is generally an issue that shows up in a 64-bit environment where the script can’t be pre-compiled.  The error that...