I have a Script Transformation task in my SSIS package that nicely
transforms some IBM date format into SQL 2005's date format. Works like
a charm.

I can't figure out how to make it return a NULL value, though. I know
VB has its new handy nullable datatypes, but the script editor chooses
the datatypes based on the properties for the output columns in the
"Script Transformation Editor" dialog. I choose "database date
[DT_DBDATE]" and go on my merry way. There's no obvious way to make it
nullable and I'm not learning anything from the help page nor google.

Am I barking up the right tree? Right now I'm setting what should be
null values to '1900-01-01' and then setting them to NULL with a SQL
script action at the end of my SSIS package, but I'm not looking
forward to clobbering someone else's boneheaded use of special dates.

The column wrapper should have two properties

..ColumName = "fred"

or

..ColumnName_IsNull = true

--
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com


"judgmentalist" wrote: