Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Assign variable in derived column Expand / Collapse
Author
Message
Posted Thursday, January 17, 2013 2:55 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 15, 2013 11:49 AM
Points: 48, Visits: 269
Is it possible or any other way to assign the Derived column expression value in a column.
for eg:
@[User::newcol]= FILE_PATH + "/" + FILE_NAME.

Please see the attachment for the same requirement. If this way is not possible then suggest me any other way to hold the expression value in a variable.


  Post Attachments 
derivedcol.jpg (6 views, 47.23 KB)
Post #1408252
Posted Thursday, January 17, 2013 7:55 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, July 18, 2014 10:54 AM
Points: 1,163, Visits: 1,184
sumit.joshij (1/17/2013)
Is it possible or any other way to assign the Derived column expression value in a column.
for eg:
@[User::newcol]= FILE_PATH + "/" + FILE_NAME.

Please see the attachment for the same requirement. If this way is not possible then suggest me any other way to hold the expression value in a variable.

You can do this in a script task. Create your new derived column and then next in a script task assign that new column to the variable. See: http://www.bidn.com/blogs/PatrickLeBlanc/ssis/1098/ssis-assign-a-value-to-variable-using-dataflow-script-task

HTH,
Rob
Post #1408431
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse