I am creating a "GENERIC package" in dts 2000 that will use a dynamic
connection string from user input.

Since the source table can be different every time, I need to delete
existing transformations, which I did using an AciveX script task, now
I would like to create dynamic column mapping in DTS. How can this be
done??? Please help!!!

Hello Monica,

You will need to recreate the datapump from scratch every time. This is
possible but is no small undertaking. I can send you some code to do this
in a package I used if you send me a mail.


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Hi Allan,

I am very interested in your solution to create the datapump from scratch.
I tried sending you an email to ask for "the package" but your the mail
could not be relayed.
Could you send it to me?
Thanks!
Hans

"Allan Mitchell" wrote: