Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
somenoob
Posting Yak Master
112 Posts |
 Posted - 2011-09-14 : 00:05:20
|
| HI everyone, i am very new to SSIS so i need help in this problem.i am required to store the execution date when i run my ssis package.the package is doing a data dump.my data dump is taking the data and storing it in a table i have created.so i need to store the executed date whenever the table i created is updated with new data. ( as in whenever the package is run )Please help me. If possible a step by step teaching is provided. Thanks alot |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-14 : 03:46:08
|
| Add a new column to table to hold executed dateThen add a derived column in data flow task where you do the data dump. then in derived column add a column as ExecutionDate and then set value to system variable @[System::PackageStartTime] (this is available from variable collection inside expression builder). then in final destination component map this column to executeddate column of your table.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
somenoob
Posting Yak Master
112 Posts |
Posted - 2011-09-14 : 04:32:58
|
| hi, thanks for the reply.i do not want to store it in my table. is there anywhere else i can store it?my table has fields that are needed to be generated to a report. i want to store the executed date for checking the latest version. i do not want it to be displayed when generating a report. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-14 : 09:02:34
|
| thats ok. you can store in your table and dont include it in select when you're retriving from table in report. without putting in a table you cant store it permanently------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
HELP store execution date