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?

Hello emailwaste (AT) gmail (DOT) com,

Yes but not in the same way. SSIS is very different as I am sure you can
imagine.

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.


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com