Flat File Normalization

Hi Can Any one help,

Well i got a flat file (in{CR}{LF} format) and needs to be imported into a sql server 2000.

now i need to know how can i create a package using DTS or some thing which kindoff breaks the data down and insert it into appropriate tables from the flat file. I need to find a way to carry it out in one process as the data is imported through the pipe. SO i have multiple tables which would eventaully contain the data from flat file.So ill Be getting the Data after every two weeks which will need to be imported into SQL server 2000. So is there any way i can automate the process.

regards

First, you have to know the column delimiter, next step is to run Import or Export wizard in Enterprise Manager with source that flat file and destination a table in your database ; don't forget to save the package and create a schedule for importing periodically during wizard!.

After that view the package saved with Enterprise for develop other things , which will be, getting a flat file as a global parameter.