date in ssis
when i am transferring the flat file data to database. i need to load the current date into the database. I have field load which takes current date whenever the file runs. Is there any way to do this. Thanks
May 19th, 2011 10:52am

Are you talking about adding an additional field that will have a package start date in it? If yes, the first step is to create a package variable and assign it System::ContainerStartTime system variable as an expression. Next use this Package Variable to add into the output columns of the flow from the file to DB and finally map it to the database table (destination). A derived column transformation with ADD (not replace) is another option. Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
May 19th, 2011 11:00am

Thank you .. can you please provide me few more details on how to this as I am entirely new to ssis
May 19th, 2011 11:06am

There are a couple of options listed over here: http://microsoft-ssis.blogspot.com/2011/02/create-guid-column-in-ssis.html Instead of GUID just use the value of System::ContainerStartTime.Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
May 19th, 2011 11:14am

Use a Derived Column Transformation to add new date/datetime columns: Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com
May 19th, 2011 1:20pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics