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 |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2009-10-19 : 04:42:15
|
| Hi All,I need to include the extra column i.e timestamp on final execution of SSIS package.In the package i am using sequence container within that i am doing 2 parallel process..at last i am dropping all the temp tables.Here i need to insert the one more column called timestamp(getdate())Please suggest how can we achieve this.Thanks in advance,Gangadhar |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-10-19 : 10:31:23
|
| Select the Derived Column from the Data Flow Transformations section, in the Data Flow.In the Derived Column Transformation Editor:Derived Column Name: NewColDerived Column: <add as new column>Expression: GETDATE()Hope this helps |
 |
|
|
|
|
|
Time stamp in SSIS