<div>
Thanks Dabas, a handy addition to my script library! I also tried concatenating two fileds in the source data stream ('cust name' and 'cust code') to create a unique identifier which also worked in this case. 
</div>


Thanks Dabas, a handy addition to my script library! I also tried concatenating two fileds in the source data stream ('cust name' and 'cust code') to create a unique identifier which also worked in this case.

<div>
<div class="content wysiwyg-content">
In Visual Studio with SQL Server 2005, I am extracting one field of data from one table with a small number of duplicates and inserting it into another table where the destination field is the primary key (i.e. unique - no duplicates allowed).<br />
I am using a source and a destination OLEDB connection object in each case.<br />
<br />
I need help with creating a query (or Data flow transformation) that detects duplicate data and adds a character to make the 2nd, 3rd or 4th instance of the duplicate data unique allowing the subsequent destination field act as a unique identifier.
</div>
</div>


In Visual Studio with SQL Server 2005, I am extracting one field of data from one table with a small number of duplicates and inserting it into another table where the destination field is the primary key (i.e. unique - no duplicates allowed).
I am using a source and a destination OLEDB connection object in each case.

I need help with creating a query (or Data flow transformation) that detects duplicate data and adds a character to make the 2nd, 3rd or 4th instance of the duplicate data unique allowing the subsequent destination field act as a unique identifier.

Sql Server 2005 Visual Studio Data Transformation - Locate duplicate data and make unique

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.