Setting default values in ssis transform - 07-05-2006 , 08:34 AM
In good old DTS I could set a transformation with no inputs to feed a
destination some dafualt values in Activex script using the syntax:
DTSDESTINATION("ColumnName") = text
Is there a way to do this in ssis?
Re: Setting default values in ssis transform - 07-05-2006 , 02:11 PM
Hello emailwaste (AT) gmail (DOT) com,
Yes but not in the same way. SSIS is very different as I am sure you can
If you want to assign an arbitrary value to a column that does not exist
in the source then perhaps a Derived Column Transform will fit the bill?
The Derived Column value would be driven from a Variable.
There are other ways but IMHO this is probably the easiest.