DTS Package issue

Hi,

I am trying to convert a .dbf file into text file, in which i have no issues. But the the dbf file changes every time i recieve the file, say for example currently i have the column name as cs_16,cs_17 etc for this month where as for the next month i would recieve the column names as cs_30,cs_31. Could any one please let me know how can i resolve this problem using the DTS Packages.

If any one could provide me with an example then it would be of great help.

Thanks & Regards
Mudasar

Quote:

Originally Posted by Mudasar

Hi,

I am trying to convert a .dbf file into text file, in which i have no issues. But the the dbf file changes every time i recieve the file, say for example currently i have the column name as cs_16,cs_17 etc for this month where as for the next month i would recieve the column names as cs_30,cs_31. Could any one please let me know how can i resolve this problem using the DTS Packages.

If any one could provide me with an example then it would be of great help.

Thanks & Regards
Mudasar

Hi there,

Unless you change column name manually according to the one specified in SQL database, it's going to take up a lot of time doing it. Good luck & Take care.

p.s/ Let see what others experts have to say on the above issue.