lundi 29 décembre 2014

How do I set up a Derived Column Transformation to get row number in SSIS 2014?


I am trying to import a ragged right flat file. I am wanting to import the file as one column and used Derive Column Transform to add a row number to each row. I would like to end up with a column called RowNum and a column called EntireRow. How do I do this?





Aucun commentaire:

Enregistrer un commentaire