>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

yahoo 510297

kijiji 376608

facebook login 350253

gmail 313800

windows live 292609

img wlxrs 286278

hotmail.com 272570

you tube 263347

http://www.facebook.com 252276

google.ca 237275

yahoo mail 214191

microsoft messenger 190257

nbcsports msnbc 186310

msn 184693

image xboxlive 181117

ebay 175051

yahoo.ca 146628

plenty of fish 134887

google maps 134701

canada 411 134323

craigslist 129121

yahoo.com 128963

google.com 128295

face book 126520

youtube.com 117249

mapquest 116769

plentyoffish 111863

img2 wlxrs 96811

porn 93996

westjet 91128

air canada 88518

mls.ca 88008

As you can...