how to sort a text file?

spierson99 · February 9th, 2006, 09:35 PM

Hi...

I have a DTS package that extracts five different tables from a database into flat files. A VBScript combines the files into one, and places a sort key in front of each record, so that the final output file can be sorted.

How can I sort a text file? VBScript doesn't have a sort function (that I know of -- I'm a VBScript novice). Thanks for any suggestions.

jbenson001 · February 12th, 2006, 06:45 PM

I would select all rows that I want into a table(or temp table) and the sort that. Then send to your text file.

Jim

ihossain · July 25th, 2007, 03:20 AM

Hi,
I've faced a similar problem. In my case 20 different tables are dumped into one flat file. Can anyone tell me how do I separate the tables using SSIS or any other programming suit? Eventually I've to use SSIS to load them into database tables.

Thanks

jemacc · November 28th, 2007, 06:20 PM

Use the scripting guys at Microsoft

http://www.microsoft.com/technet/scr...5/hey0225.mspx

Jaime E. Maccou