I'm speaking at SSWUG Summer Camp! Thankfully, I can be at home, in my pool AND be at summer camp (oh, how I love modern technology!). If you have the time, come listen to me blather on about SSIS. http://www.sswug.org/vc
I am honored to say that have been selected to present this year. I'll be giving a talk on my threading framework for SSIS. Unseen Minions : Improving parallel processing in SSIS. I am very excited and hope to see you there!
Today I had to write a little function that takes the long had version of a fraction, say 8 3/4 and convert it a proper number (float) and then convert that number from inches to centimeters. While that is handy, I thought it would be best to include a few more variations on that theme. It handles the following input scenarios:
- Whole numbers -- '8'
- Fractions alone -- '1/4'
- Mixed Numbers -- '8 1/4','8-1/4','8.25','0.75','.75'
- An invalid fraction -- 'Special',' eight and 1/4'
I'd list the code, but I haven't found a good way to embed formatted code into this website so instead I am linking the source code.
Working with Excel in SSIS is not fun and something I whole-heartedly discourage. With that said, I had a not so uncommon issue that I thought I would blog, once I found the answer. The issue is with writing columns of data to Excel with a width>255 characters, more specifically varchar(max).
Whenever I need to export data to Excel within SSIS I like the approach of having a blank template that I copy to a work location, fill with data, change the name and ship it off. The issue I ran into was where I had to change a column name in one of my templates. Upon saving the template and re-running the DataFlow Task I got the error codes above. The complete message was as follows:
There are countless ways to mix and match components in SSIS to simulate what SQL Server does in a query. Here I am going to show you how to replicate an existence check using SSIS components. The only time I use this type of configuration is when I have cross-server joins. I find it more efficient for SSIS to hop to different servers in discrete components than to rely on SQL Server to do linked server calls. Here is an example of a simple select statement that does a cross-server join to validate the data.