In a DTS I use a Dynamic Task Property to set the source
and destination files of my Data Pump Task to the new
table names as defined in my global variable.

My problem is that by doing this the mapping of columns
becomes "invalid / corrupt". Since each time I run this
DTS I can update the sourc and destination table names I
need to dynamically (using dynamic pump task, hopefully)
redo the auto mapping in the Data Pump Task.

Any insight into how this would be done would be greatly
appreciated.

Thanks,
Matthew Simmons
Peace Out!

If the Source And/Or destination definition changes then your
transformations go out the window.
You can rebuild them dynamically but it will involve you getting down with
the object model.



--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Matthew Simmons" <mjsimmons (AT) no-spam (DOT) hotmail.com> wrote

Not a problem. I just havent been able to find the right
info in the jungle of Microsofts website. Any links would
be great.
Thanks,
Matt

No links but

Save your package to VB and you will see how it does it.

I wrote a package that took a simple text query and built a Datapump and
also created the destination named range in XL that you can have if you ping
me privately.



--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Matthew Simmons" <mjsimmons (AT) no-span (DOT) hotmail.com> wrote