InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 04:08:31 GMT20http://www.sqlservercentral.com/Forums/Topic1408252-147-1.aspx[quote][b]sumit.joshij (1/17/2013)[/b][hr]Is it possible or any other way to assign the Derived column expression value in a column.for eg:[b]@[User::newcol]= FILE_PATH + "/" + FILE_NAME[/b].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.[/quote]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: [url]http://www.bidn.com/blogs/PatrickLeBlanc/ssis/1098/ssis-assign-a-value-to-variable-using-dataflow-script-task[/url]HTH,RobThu, 17 Jan 2013 07:55:26 GMTrobert.gerald.taylorhttp://www.sqlservercentral.com/Forums/Topic1408252-147-1.aspxIs it possible or any other way to assign the Derived column expression value in a column.for eg:[b]@[User::newcol]= FILE_PATH + "/" + FILE_NAME[/b].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.Thu, 17 Jan 2013 02:55:14 GMTsumit.joshij