Post reply

Default Value Getdate()

  • April 26, 2007 at 12:35 pm

    #118433

    My SSIS package imports a few flat files into one table.

    In the table i've got a column LoadDate with default getdate().

    When I run the package everything imports properly. But LoadDate is null.

    Is there a setting in SSIS that i have overlooked?

    I'm using OleDb Destination.

     

    Thank you

    Alex S

  • April 26, 2007 at 12:41 pm

    #702748

    Make sure your package is not referencing the "loaddate" column in it's update/insert statement.  Exclude that column and it should work as expected.

  • April 26, 2007 at 12:54 pm

    #702753

    JLK thanks for the response.

    Actually it was the Data Access Mode in OLE DB Destination

    Mine was set to "Fast Load" method (Bulk Load) which ignores Defaults.

    When i changed it to Table Or View. the LoadDate column is now populated.

    Thanks

     

    Alex S

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

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