Using DENSE_RANK() in a DataFlow


  • In my SSIS 2010 package, I have a text file as a source, and an OLEDB connection to a SQL Server table as my destination. One of the fields at the destination table needs to receive an integer value that represents the DENSE_RANK of that row. The rank is based on parts of a persons name (from the data); PreName, FirstName, MiddleName, LastName, SuffixName. 

    The destination table is set up as a staging table. Is there a way in the DataFlow that I can calculate the DENSE_RANK before inserting into the destination stage table, or will have I have to first populate the table, and then somehow derive the DENSE_RANK?

    Thank you for your help.


    Friday, September 13, 2013 3:32 PM


All replies