July 26, 2013 at 9:58 am
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
July 26, 2013 at 10:02 am
vasu1.vi (7/26/2013)
HiI 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.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy