Well it was a great SQL Saturday in Tampa and we all learned and networked alot. In my session with Aaron Nelson "SQL Smackdown" we compared powershell and SSIS. You can download a copy of the packages here . These packages are SQL 2008 In Iron Chef Devin Knight went head to head with Adam Jorgensen building BI solutions. Brian Knight and I were the MC's for Iron Chef. The speed pass worked out great, there was no backup at all. Great job Pam.
Read More
The pivot transform in SSIS is already a pain to use. When you have bad data it makes it even worse. In this blog I am going to show how to handle bad data when using the pivot transform. You should understand how to use the pivot transform already and Devin Knight has a great blog on how to do that here . Here is the input table: The output table should look like so: This is a situation where the users have entered data and they have left off the types on the input table and therefore we do not...
Sometimes we get data in some bad forms. For example look at the below table: The names and the amounts are comma separated in two different columns. Let’s imagine we need to get this data into a table like the one below: Notice the column names are the names that were in the data. This can be accomplished with derived columns and conditional splits in an SSIS data flow. Here is an example of a data flow that accomplishes this: After the source the first component is the conditional split. The c...
Here is a script to create a Dim Date and Dim Time table in a data warehouse. I did not write this script but it is a popular request and seems to be hard for people to find on other sites. So I thought I would post it here to make it easier for people to download. You will need to alter the start date and end date to your desired time period. I have improved the script and added fiscal dates also. I published this on a new blog here.