Here is the next in my series of posts explaining how common tasks in DTS can now be implemented in SSIS.
Add a timestamp to the data in the data pump
This is a common requirement for auditing purposes. people need to know when a row was processed.
There are a number of options for achieving this in SSIS. Namely:
- A derived column component which enters the value of the GETDATE() function or the @[System::StartTime] variable into the pipeline
- Use the Audit transformation and put the value of "Execution Start Time" into the pipeline
- Use a script component
All very easy to do I can assure you. I would use the Audit transformation option as it is the easiest and guarantees a common approach across all your packages.