May 4, 2012 at 10:06 am
I'm need to add a Derived Column to a Transformation and set the Modified_Date to the System::ContainerStartTime.
I'm not enterting the correct syntax.
What do I enter in the Expression and DataType Columns?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 4, 2012 at 10:55 am
I specified the column as a new column and used an expression by simply dragging and dropping.:blush:
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 8, 2012 at 7:11 am
Hi,
consider the @[System::ContainerStartTime] as a new column in derived column transformation and while mapping into the destination table , map the modified_date column with the derived column which was considered @[System::ContainerStartTime] . It will insert the modified date column with container start time.
May 8, 2012 at 2:21 pm
nhimabindhu (5/8/2012)
Hi,consider the @[System::ContainerStartTime] as a new column in derived column transformation and while mapping into the destination table , map the modified_date column with the derived column which was considered @[System::ContainerStartTime] . It will insert the modified date column with container start time.
I was not that clear but that is exactly what I did. Thanks.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply