Tuesday, May 08, 2007 - Posts

Using SMO from TSQL

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Using SMO from TSQL
The new RSS feed is here

If you are desperate to get your hands on the code I used in the SMO in TSQL demo I did at the usergroup meeting you can download it now from codeplex.

http://www.codeplex.com/SMOinTSQL

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Using SMO from TSQL

posted Tuesday, May 08, 2007 12:51 PM by SimonSabin with 0 Comments

SSIS : Lookup component doesn't handle data type changes

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 : Lookup component doesn't handle data type changes
The new RSS feed is here

I am always trying to optimise the storage I use this often results in changing between tinyint, smallint and int data types as the amount of data I need to capture increases.

Unfortunately the SSIS lookup component doesn't handle such changes very well. Well it doesn't.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SSIS : Lookup component doesn't handle data type changes

posted Tuesday, May 08, 2007 12:44 PM by SimonSabin with 0 Comments