Post reply

SSIS update table with date variable

  • January 20, 2011 at 4:31 pm

    #144810

    SSIS is new to me, and version is 2005. Have a flat file dumped into a sql table. After this record is inserted , i need the date stamp a field in this table. I have created a user variable with the date. Also have the data flow to dump the record into the table. Now how do i update this column in the table with the variable. pls help

    thanks

  • January 21, 2011 at 12:41 am

    #1276402

    After your data source in the data flow, insert a Derived Column transformation.

    Create a new Derived Column and assign your date variable to it.

    You will now be able to create a mapping from this new column to your target table's datestamp column.

  • January 21, 2011 at 12:01 pm

    #1276725

    thanks it worked !!

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply