0
I Use This!
Activity Not Available

Project Summary

This project contains the code for an SSIS custom transformation. This asynchronous component takes a column with a delimited string and un-pivots the information, outputting a row for each delimited value that contains the original delimited string, one of the delimited values, and the position of the delimited value in the string. The value of the delimiter is included as the custom property DelimiterString and can be set at design time.

Note: The input data column which contains the delimited string must be sorted with a sort key position of 1. That is the only column that will be delimited.

For example, if you have the following input:
RowNum DelimitedStrColName
1 Anjan,Catherine,Donald,Kirk,Ritu
2 Andy,Allan,Erik,Jamie,Simon

You would see the following output:
UnPiv_No Unpivot_ColName RowNum DelimitedStrColName
1 Anjan 1 Anjan,Catherine,Donald,Kirk,Ritu
2 Catherine 1 Anjan,Catherine,Donald,Kirk,Ritu
3 Donald 1 Anjan,Catherine,Donald,Kirk,Ritu
4 Kirk 1 Anjan,Catherine,Donald,Kirk,Ritu
5 Ritu 1 Anjan,Catherine,Donald,Kirk,Ritu
1 Andy 2 Andy,Allan,Erik,Jamie,Simon
2 Allan 2 Andy,Allan,Erik,Jamie,Simon
3 Erik 2 Andy,Allan,Erik,Jamie,Simon
4 Jamie 2 Andy,Allan,Erik,Jamie,Simon
5 Simon 2 Andy,Allan,Erik,Jamie,Simon

Tags

No tags have been added

In a Nutshell, UnPivotDelimitedString Custom SSIS...

 No code available to analyze

Open Hub computes statistics on FOSS projects by examining source code and commit history in source code management systems. This project has no code locations, and so Open Hub cannot perform this analysis

Is this project's source code hosted in a publicly available repository? Do you know the URL? If you do, click the button below and tell us so that Open Hub can generate statistics! It's fast and easy - try it and see!

Add a code location

This Project has No vulnerabilities Reported Against it

Did You Know...

  • ...
    nearly 1 in 3 companies have no process for identifying, tracking, or remediating known open source vulnerabilities
  • ...
    check out hot projects on the Open Hub
  • ...
    65% of companies leverage OSS to speed application development in 2016
  • ...
    search using multiple tags to find exactly what you need

 No code available to analyze

Open Hub computes statistics on FOSS projects by examining source code and commit history in source code management systems. This project has no code locations, and so Open Hub cannot perform this analysis

Is this project's source code hosted in a publicly available repository? Do you know the URL? If you do, click the button below and tell us so that Open Hub can generate statistics! It's fast and easy - try it and see!

Add a code location

Community Rating

Be the first to rate this project
Click to add your rating
   Spinner
Review this Project!
Sample ohloh analysis