How to auto-map the transformations for variable field width files

[znet]

Hello group,
I want DTS import several CSV files automatically, but the source files maybe mistakenly added some additional fields by customer. I don't know how to auto-maping transformations when importing the whole file (known normal fields+unknown additional fields) to a table(predefined or create new one). I have to set transformation every time by source files. Who give me directions. Thanks in advance

 

[TheJFM]

You can get the transformations to reset themselves in line with source and target.

Take a look here and it might give you some helpful tips to progress this

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtsprog/dtspcoll_7g6m.asp

** Don't reach for the moon when you have the stars. ;-) TheJFM **

 

[znet]

Thanks TheJFM,
It seem have to code transformation procee, I am not good at this. Can you give me some example(link).