Assigining dynamic date value for insertdate

• vasu1.vi

  Newbie

  Points: 1

  More actions

  July 26, 2013 at 9:58 am

  #280575

  Hi

  I am working on a package that needs to populate currentdate when we insert new row on the table. For this i am using getdate() in the vaiable. when i run the package its not taking dynamic value, it is only taking initial value from that variable. In this case package is running fine and the only issue is no dynamic date value for insert date field. So i did change evaluate exression property is set to TRUE to get dnamic value. This time when it comes to the table load that has the insertdate column, its keep on validating the package. No progress even after 10 minutes.

  Could someone help me to run my package with dynamic date value for insertdate column?

  Thank you for your time and help!!!

  Thanks, Vasu

• Phil Parkin

  SSC Guru

  Points: 247159

  More actions

  July 26, 2013 at 10:02 am

  #1636223

  vasu1.vi (7/26/2013)

  ---

  Hi

  I am working on a package that needs to populate currentdate when we insert new row on the table. For this i am using getdate() in the vaiable. when i run the package its not taking dynamic value, it is only taking initial value from that variable. In this case package is running fine and the only issue is no dynamic date value for insert date field. So i did change evaluate exression property is set to TRUE to get dnamic value. This time when it comes to the table load that has the insertdate column, its keep on validating the package. No progress even after 10 minutes.

  Could someone help me to run my package with dynamic date value for insertdate column?

  Thank you for your time and help!!!

  Thanks, Vasu

  Can you do this a little differently and modify the design of the target table to have a default value for that column? Then let SQL Server populate it for you.

  ---