That worked fine, Dohsan. Thanks much!

ColdCoffee,

When I add more Comp99 fields to the existing code, the pivot results are shown in a sorted sequence.

Comp1

Comp10

Comp2

Comp3

...

Is there a way to eliminate the sorting part of this...

ColdCoffee,

You ARE a genius!! The results of the second change was exactly what I was looking for. I cannot thank you enough for your generous assistance to my problem.

Have a...

The "WHY" is a business requirement that is really none of your concern. I've asked about a solution for a problem and all I'm getting is why do I want...

Very simple. I want to iterate through a directory of flat files and create SQL tables from them. Clear enough?

Yes the flat files and SQL tables all have the same format. I've been able to create a package which reads and loads the flat files to a single SQL...

Hello Saji,

Did you ever find a solution to this problem? I have the exact same situation which I'm having trouble with. If you have figured it out, I would appreciate...