Ricky,
I have this same scenario where work (AS400-SQLEE 2000).
Maybe you can help me.
I would like to know what components you used in DTS?
I have some problems, for example, how do I convert the data (Zonned) to compare with the current date (getdate ()) in SQLServer.
Do you have documentation?