>Scott

Hey Thanks for the Suggestion, but I've got 'Ultra Edit' now..... works like a charm:)

>Vikas

Thank you Mate:)

>gilamonster

>chiragns

Thanks to both of you.:-) I will try it and post the outcome.

Thank you.

Hi,

I did as Dave suggested and got the results:) and there are more than 30 million rows in the resultant table.However in the mad dash to execute the query and...

>vyas

Thank you very much mate:-)

>Dave

you just saved a person frm hanging himself man..;)

......jokes apart, thanks a million man.That's Exactly what I needed.Thanks:-)

Hi folks,

>braindodnor: Thank you Braindonor:-)

I have finally got around the problem of importing the data into SQL db from the text file.Here's what I did,I split the 800 MB...

>RayK

Hi,

Thank you very Much for your suggestions:)

>Braindonor

Hi,

Firstly,Thank you very much for your interest and patience.One couldn't have approached my problem in a better way,I suppose,and I appreciate it.

Secondly, I've read...

@ray K

you mean change the column data types for the 'Data Source'??? coz I can't.... the defaults are as follows:

Column 0 - string [DT_STR]

Column 1 - single-byte signed...

ok. I will provide a sample.Actually I cannot open the original file because its about 830 MB in size and my notepad can barely handle it.I have tried opening it...

The data in the text file is something like this:

COLUMN0 COLUMN1

yahoo510297

kijiji376608

facebook login350253

gmail313800

windows live292609

img wlxrs286278

hotmail.com272570

you tube263347

http://www.facebook.com252276

google.ca237275

yahoo mail214191

microsoft messenger190257

nbcsports msnbc186310

msn184693

image xboxlive181117

ebay175051

yahoo.ca146628

plenty of fish134887

google maps134701

canada 411134323

craigslist129121

yahoo.com128963

google.com128295

face book126520

youtube.com117249

mapquest116769

plentyoffish111863

img2 wlxrs96811

porn93996

westjet91128

air canada88518

mls.ca88008

As you can...