Hi,

Yes, I had look at DTS, but it require knowledge in it and
some sort of programming stuff to get it working.


>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