Re: Dynamic Column Mapping in DTS

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Allan Mitchell <allan@xxxxxxxxxxxxxxxxxx>
Date: Mon, 24 Jul 2006 10:42:15 -0700

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

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!!!

References:
- Dynamic Column Mapping in DTS
  - From: Monica

Prev by Date: Re: Data Driven Query Task - More than one UPDATE
Next by Date: Re: SQL 2000: Problem running DTS as sa
Previous by thread: Dynamic Column Mapping in DTS
Next by thread: Re: Data Driven Query Task - More than one UPDATE
Index(es):
- Date
- Thread

Relevant Pages

Re: Changing form
... > recreate the form from scratch or is there a general guideline as to ... > when/what type changes to underling tables will require you to ... There is NEVER a reason to rebuild a form from scratch other than if it gets ...
(microsoft.public.access.forms)
Re: Changing form
... >underling tables will require you to recreate forms. ... and rebuild from scratch. ... and pull fields from the field list onto the form or use the ...
(microsoft.public.access.forms)
Re: Modify text in "Graphic converter"
... images and can recreate the page from scratch. ... But for future projects, ...
(comp.sys.mac.system)
Re: Rules Problem
... RFJ wrote: ... > Some of my rules work and others don't seem to (particularly Outbox). ... > If I recreate (from scratch) the rules that don't work, ...
(microsoft.public.outlook.general)