Friday, January 05, 2007 - Posts

Loading a SSIS package in C#

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Loading a SSIS package in C#
The new RSS feed is here

This is a classic gotcha that caught me out and thankfully others on the newgroups.

The object model for SSIS has an object called Package which represents a package.

One would assume that to load a package from a file you should use the LoadFromXML method on this Package object.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Loading a SSIS package in C#

ComponentClassId for Integration Services

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/ComponentClassId for Integration Services
The new RSS feed is here

Are you wanting to develop Integration services using code. If so then you will need to now the identifiers to use for each component.

You have three ways to set the componentClassId

Directly if you can remember them i.e. myuComp.ComponentClassID = "DTSTransform.Merge.1";

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/ComponentClassId for Integration Services

SQL Server 2005 Samples - Where is the samplekey.snk

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SQL Server 2005 Samples - Where is the samplekey.snk
The new RSS feed is here

Did you know that whilst the samples are included on the install of SQL Server as with books online the most upto date versions can be found online.

Download details: SQL Server 2005 Samples and Sample Databases

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SQL Server 2005 Samples - Where is the samplekey.snk