Category: Business Intelligence

0

SSIS Variable and Expressions Followup

Over the last week I have done several sessions either for the Pragmatic Works Free Training online or at SQL Saturday.  It has been a lot of fun, so thank you to everyone who has come out and hopefully learned...

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 need to in order to make...

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 and Variables.  I got a lot...

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 follows is a little bit of...

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 will show up states that “The...