Monday, July 23, 2007 - Posts

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