Hi, is there a way to extract the table/column mapping specifed in the
data pump (transform)? I want to document the mapping from source to
destination and currently DTS package is all we have in terms of any
mapping. So without manually going through each transform data task, I
like to be able to extract the mapping information specified in them
programmatically or through some menu wizardry.

Thanks!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

OK.

You have a SourceColumns and a DestinationColumns property which is made up
of a collection of columns. These belong to a Transformation Object which
in turn belongs to a Transformations Collection. These belong to the
DataPump task or the DDQ task.

If you then want to say what the mappings actually are then you will need to
look a the type of transnsformation

Set oTransform = oCustTask.Transformations. _
New("DTSPump.DataPumpTransformCopy")


and in the case of an Active X transformation then DataPumpTransformScript
Object (TEXT property)

The easiest way to look how all this hangs together is to create a package
and then save it out as VB. Look at how DTS brings it all together.

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Ken Shue" <kshue (AT) dvxgroup (DOT) net> wrote

Thank you, Alan!! It's much better to be looking in the VB code than in
the designer.


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!