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

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

Thank you .. can you please provide me few more details on how to this as I am entirely new to ssis

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

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