I've been reading post for about two days now, however I have not
been able to find the solution.

Issue:
Dynamically create source and destination columns for DTS
Transformations.

I have a package that creates an Excel Workbook, and pushes data to
each sheet. This issue is that when the sheets are created, the
columns change based upon our techs in each location. So therefore
when techs shift locattions, quits or new ones get added, the
transformations will not push the data.

e.g.
Each time the package is created, the source table is used to create
the destination sheet. So all columns match, however the data pump
will only push the columns that match. Any new columns will not work,
also we get an error if a column has been deleted (if a tech quits).
This DTS is done daily.


Thanks,

Eli Lawson
eli.lawson (AT) adsdish (DOT) com

I have something which will get a whole load of the way there is you
ping me offline

Allan

"Eli Lawson" <elilawson (AT) sbcglobal (DOT) net> wrote

Allan,
I tried to contact you before I posted to this group. The address I
wast trying to hit was
allan (AT) no-spam (DOT) sqldts.com

You can hit me @ elilawson (AT) sbcglobal (DOT) net

Thanks a million !

*** Sent via Developersdex http://www.developersdex.com ***

Allan,
I tried to conact you @ no-spam.sqldts.com after reading some of your
post.

Kept getting bounce backs.

You can hit me @ elilawson (AT) sbcglobal (DOT) net

*** Sent via Developersdex http://www.developersdex.com ***

Eli.

Remove the no-spam decoy.


Thanks

Allan

"Eli Lawson" <elilawson (AT) sbcglobal (DOT) net> wrote