Excel and SSIS

Question

Excel and SSIS

louisville246

Newbie

Points: 3
More actions
February 15, 2015 at 12:44 pm

#294690

Hello.
I have an excel file and im trying to move the data to the headers...
Using SSIS i want one row per person with all surveys as header titles
original Excel file
Name Survey Numerator Denominator Rate
Jane Doe Records Returned (<50%) 258 259 99.60%
Jane Doe Record sent successful (<80%) 108 108 100%
Kelly Brown Records Returned (<50%) 428 445 96.20%
Kelly Brown Record sent successful (<80%) 50 100 50%
Finished file
Name Records Returned (<50%)Rec ords Returned, NumeratorRecords Returned- Denominator
Jane Doe 99.60% 258259
Kelly Brown96.2428445
Forum Etiquette: How to post Reporting Services problems

[/url]

Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]

How to Post Performance Problems - by Gail Shaw
[/url]

mister.magoo SSC-Forever Points: 47174 More actions · Answer 1

Your expected output appears to just be a straight selection from the input, but it's hard to tell with the post unformatted as it is.

Could you maybe provide your input and output data as SELECT statements, so we can tell which columns are which?

See the post by Jeff Moden in my signature if you are not sure what I mean.

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);