Transpose CSV File using SSIS

[klewis10367]

I want to transpose the following data that is in a csv file where I create 2 columns; 1 being the Visits row, and the other being the Visitors row. Any ideas?

Visits	687
Average per Day	687
Average Visit Duration	0:22:22
Median Visit Duration	0:03:37
International Visits	0
Visits of Unknown Origin	1
Visits from Your Country: United States (US)	0
	
	
Visitors	558
Visitors Who Visited Once	477
Visitors Who Visited More Than Once	81
Average Visits per Visitor	1.23

 

[RiverGuy]

Can you give an example of what you want the output to look like?

 

[klewis10367]

Visits Visitors
687    558

 

[RiverGuy]

So you don't want any of the others lines like Average Per Day or Visitors Who Visited Once in the output? And are there multiple sets of these in the CSV, or is what you posted in the first post the entire file?

 

[klewis10367]

Just those two rows and yes that is all of the data.

 

[RiverGuy]

The best solution which comes to mind is to use a Script Task in SSIS, which allows you to write VB.Net code. You can loop through the file and assign a string variable to the lines in your file, parsing them for their values in memory and writing the values to a different file should the string comparison meet your criteria.

 

[klewis10367]

Thanks for the reply, actually I ended up just using a case statement.