troubleshooting Question

Derived Column that is Count of each value

Avatar of Brickwall
BrickwallFlag for United States of America asked on
Microsoft SQL Server
5 Comments1 Solution1147 ViewsLast Modified:
I have a Data Source that i am working with in SSIS.  The data source has an id Column that contains duplicates,  but the way the data is it's actually not a duplicate value.  I know confusing right.

So the data looks like this:
ID         |       Data
20197  |....... more data
20197  |........more data
20197  |........more data
20198  |........more data
20198  |........more data
20199  |........more data

The way the Data is I am needing to  to add a count and grouping. to each values.

The end Result should look like
ID      |Port|    Data
20197  |1|....... more data
20197  |2|........more data
20197  |3|........more data
20198  |1|........more data
20198  |2|........more data
20199  |1|........more data

The data source is CSV so I am needing to do All of this in SSIS some how
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros