Hi Can you please suggest me how to create user variable by using Derived column transformation. I want to generate a new column with values of 1,2,3,4... Is there any another transformation to do that?madhu ml

You can't generate variables on runtime. But are you trying to accomplish? You want to fill a new column with values. How are you determining those values?Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

As SSISJoost said, you cannot create user variables in Derived Column Transform , but you can create new columns there with expressions to generate values and add columns into the data flow's data streamhttp://www.rad.pasfu.com

Sounds like you want to do this.

Hi Can you please suggest me how to create user variable by using Derived column transformation. I want to generate a new column with values of 1,2,3,4... Is there any another transformation to do that? madhu ml If you want to add a rownumber, there are multiple alternatives (a derived column isn't one of them): * install the 3rd party rownumber transformation, as mentioned by D.Pendleton * add a ROWNUMBER() OVER (...) function in your source query, if your source is SQL Server * use a script component to generate the row number for you. http://weblogs.sqlteam.com/jamesn/archive/2008/02/13/60509.aspxMCTS, MCITP - Please mark posts as answered where appropriate.