Thanks for all your help.

Each DTS I have defined creates one table. I then want to join this 6 tables side by side to create one huge table.

I have a...

Thanks.

Could you please tell me what limit are we talking about? I will try partitioning the text file to include 450 columns instead of 900 but are there any other...