Can I add derived column with IDENTITY(1,1)?

• JMI

  SSChampion

  Points: 11831

  More actions

  October 14, 2008 at 7:11 am

  #127964

  I'd like to load source text file into a pipeline

  with IDENTITY(1,1) extra column then

  rotate the data. I need to convert rows into columns.

  Can I add derived column with IDENTITY(1,1)?

• Chris Campbell-415954

  SSCrazy

  Points: 2248

  More actions

  October 14, 2008 at 7:42 am

  #884622

  If you want to do this in the package you'll have to do it with a script task.