Woohoo! I have been selected to present my SSIS Tips & Tricks presentation at this year's 24 Hours of Pass. I am very excited and honored to have been selected to be one of 24 presenters. I have decided to include new material in this presentation; Named Pipes. If that piqued your interest, then please register for my presentation and any of the other fine presentations available. As a matter of fact, take the day off and register for all 24! Just click on the link to the left under Contributions or right here to register.
I've been asked on several occassions to provide an example of the custom sources I use in my "SSIS Tips&Tricks" presentations. I had to build one moments ago and realized I am tired of looking back through my presentations to build them. Here is a sample script that you can use to build your own custom Script Component Source. It shows how to use:
- stored procedure
- stored procedure with parameters
- select statement
You can find the script here.
I'll be giving a presentation tomorrow, Tuesday 2/21/2012 at 12PM EST on my Enhanced Threading Framework design. Here is the abstract:
If you are looking to improve the performance of your SSIS packages by taking advantage of SSIS inherent parallelism using advanced techiniques please join us, link.
The other day I was building a simple data import package when I ran into a common situation; invalid conversions in a Derived Column. The conversion was taking an ISBN13 which is usually defined as char(13) and converting it into a bigint. All valid ISBN13s are valid bigint. The flat file source I was importing had invalid ISBNs in it, the first set of which where simply blank. I was about to modify my derived column to shunt all blank ISBNs to 0 when it turns out there is a second set of bad data; invalid ISBNs. These are either ISBN10s, which contain a letter in the 10th position, or plain character garbage. This changes the whole plan of attack.