SSIS - Integration Services (RSS)

SQL Server Integration Services posts. Custom components, performant packages etc.
Books Available from Amazon

SSIS change to pipeline for custom components

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SSIS change to pipeline for custom components
The new RSS feed is here

If you've written your own custom components then you should read this post on the SSIS forum about a possible change to the pipeline that may affect your component.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2190281&SiteID=1&mode=1

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SSIS change to pipeline for custom components

posted Tuesday, September 25, 2007 10:01 PM by SimonSabin with 0 Comments

SSIS Dates aren't very precise

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SSIS Dates aren't very precise
The new RSS feed is here

I'm implementing some SSIS packages at the moment and started looking at logging with the event handlers. I simply wanted task start and end times etc and so used the start time system variables.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SSIS Dates aren't very precise

posted Tuesday, September 25, 2007 9:33 PM by SimonSabin with 0 Comments

SSIS - Viewing packages in Management Studio

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SSIS - Viewing packages in Management Studio
The new RSS feed is here

Its odd how you often find things out by accident.

Yesterday I was copying a dts package into a folder on my server and for some reason the drop didn't drop. When I then switched to management studio and XP finally decided to drop the file it did it in the management studio work space.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SSIS - Viewing packages in Management Studio

posted Friday, May 11, 2007 8:32 AM by SimonSabin with 0 Comments

SSIS - What is wrong with it

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SSIS - What is wrong with it
The new RSS feed is here

I recently visited a client that was achieving wonders with DTS, I was there to give them pointers on SSIS. I spent a day gogin over SSIS from the control flow to configrations.

A couple of things really got me was that SSIS is a new world that youhave to learn and boy there is a lot to learn, SSIS has many ways of achieving the same thing and many ways of doing it badly.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SSIS - What is wrong with it

posted Friday, July 27, 2007 11:08 PM by SimonSabin with 0 Comments

SSIS - Enhanced Error Component

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SSIS - Enhanced Error Component
The new RSS feed is here

For those that downloaded the enhanced error component I forgot to make it clear that the new version requires you to have service pack 1 installed. The reason being is that we are using an interface that allows us to look at the whol package in the component UI.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SSIS - Enhanced Error Component

posted Thursday, July 26, 2007 11:17 PM by SimonSabin with 0 Comments

SSIS - Error outputs should you configure them

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SSIS - Error outputs should you configure them
The new RSS feed is here

Should you connect configure error outputs for your components in a data flow? I'm putting a SSIS crib sheet together I asked Jamie Thomson to have a look over it and one point he question was my statement on error outputs.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SSIS - Error outputs should you configure them

posted Tuesday, July 24, 2007 8:25 AM by SimonSabin with 0 Comments

SSIS - Variable lists for the script task are case sensitive

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SSIS - Variable lists for the script task are case sensitive
The new RSS feed is here

I've just been tearing my hair out trying to get variables and locking working. It was only after one of those eureka moments that I realised that the variable names are case sensitive.

So the lesson learnt is make sure that you have a naming convention for your variables so you don't have to remember if your variables are all lower case (unreadable) , title case (my preference) or camel case.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SSIS - Variable lists for the script task are case sensitive

posted Monday, July 23, 2007 10:03 PM by SimonSabin with 0 Comments

SSIS - 64 Bit woes

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SSIS - 64 Bit woes
The new RSS feed is here

I am starting to regret installing 64 bit vista on my laptop, my woes are continuing as I found out today I can't debug script tasks.

I do hope this is fixed in Katmai :)

The full limitations, and there are a few, can be found here

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SSIS - 64 Bit woes

posted Monday, July 23, 2007 9:10 PM by SimonSabin with 0 Comments

SSIS : Web Service task doesn't cut it but who cares

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SSIS : Web Service task doesn't cut it but who cares
The new RSS feed is here

18 months ago I was trying to use the SSIS web service task for a number of purposes. The first was to integrate with SalesForce, the second was to manage reporting services. Unfortunately the Integration Services (SSIS) web service task doesn't work for these web services. On further investigation I'm not sure what web services it does support.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SSIS : Web Service task doesn't cut it but who cares

posted Monday, July 02, 2007 9:36 PM by SimonSabin with 0 Comments

SSIS : Enhanced Error Component - Update

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SSIS : Enhanced Error Component - Update
The new RSS feed is here

I have finally got round to looking into the error reports and found a few bugs in this component.

I have uploaded a new install for this component including the fixes. The component now validates correctly that the correct inputs are attached to the component.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SSIS : Enhanced Error Component - Update

posted Thursday, June 28, 2007 12:55 AM by SimonSabin with 0 Comments

Time dimension - What should the key be?

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Time dimension - What should the key be?
The new RSS feed is here

We are currently implementing a data warehouse and the design of the time dimension was recently being done.

Firstly it was agreed that day and time should be split out. Combining the two into one dimension is nuts your dimension would be huge and unworkable.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Time dimension - What should the key be?

posted Tuesday, June 26, 2007 9:04 AM by