Recently I was creating an SSIS script task that needed to read and write to variables. After doing some research, I found some code at this site which simplifies the task.
The code includes a function called ReadVariable which reads in the value of a variable, as well as subroutine called WriteVariable, which writes a value to a variable. I personally prefer using these routines, as you avoid having to configure the ReadOnlyVariables and ReadWriteVariables attributes of the script task, leaving everything in the code of the script.
Tweet This Post 
Digg This Post 
Facebook
mike SSIS
I was working with SSIS the other day, and was trying to get to use a Derived Column Transformation to return a NULL value. It should be pretty straightforward, however it seems you have to cast the NULL expression as a NULL value for it to work properly. Rather than using simply:
TRIM(column_name) == “NULL” ? NULL(DT_STR,27,1252) : TRIM(column_name)
I instead had to use:
TRIM(column_name) == “NULL” ? (DT_STR,27,1252)NULL(DT_STR,27,1252) : TRIM(column_name)
Thanks to this blog entry for pointing me in the right direction.
Tweet This Post Digg This Post Facebook
mike SSIS
Welcome to my new blog. I plan on using this forum to share my research and technical experiences, specifically relating to Identity Management.
This replaces my old website, trachta.org, which I didn’t spend enough time updating.
Tweet This Post Digg This Post Facebook
mike Uncategorized