Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 DTS Transformation mapping

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-12-02 : 08:21:10
kris writes "I am running a datawarehousing environment in SQL Server.
We have a lot of DTS Repository packages for data extraction,
transformation and loading.
I am wondering! Whether there is a way for capturing (copy)transformation mappings (source & destination column mappings) to a text document. Are there any tools available in the market to do this? I want to document it and keep it as a reference document for modifications of the packages. Remapping columns is such a difficult process.
It shall be higly appreciable if someone can give me a good suggestion.
Thanks
Kris."
   

- Advertisement -