Have you taken a look at DTS (Data Transformation Services) in SQL Server 2000?

>Hi,
>
>Anyone know of any solid flexible importing program that can map
>from text file of huge legacy data into MS SQL Server 2000.
>
>Or have anyone done any flexible importing program to import
>data.
>
>I hope that with it's flexiblity, we only had to change
>the configuration to import the data without having to
>change/code for each data file.
>
>Any advise or comment is appreciated.
>Thank u