SQL 2000 - Using DTS to import TXT file to table

[ghh3rd]

I am new to SQL 2000, took a college course, and went through a book, but now it's time to do a simple import and I'm sort of stuck.

I have a text file that I want to import to a table. I have tried doing this with the Data Transformation Services tools, but am not getting it.

I'm not sure what Connection(s) and Task(s) I should be using. Can someone point out the steps that I should follow to do this. I just need a 'springboard' to get going.

Thanks!

 

[jby1]

Pop up the DTS Import wizard (I presume you have managed to get this far?)

Click Next on the first screen, taking you to the Choose a Data Source screen.

In the Data Source list, select 'Text File'

You can then browse for your file.

Hopefully this will get you started!