sql server dts: Hello Mr Mitchell,

Based on several threads I've read from users having a similar problem, I
believe you have a solution for
dynamic transformation mapping?
I need to export data from SQL tables to AS400 files(the SQL table has the
same structure and column names as the file on the AS400) . I created a DTS
that has 2 global variables for the source file and the destination table.
I need to re-create mapping for every file I want to load as I don't know
ahead of time the column names .
Your help would be greatly appreciated.

PS: In case this thread doesn't reach Mr Mitchell, I would be most grateful
if someone can provide
me with an email address where I can reach him.

Thanks so much.

--
Message posted via SQLMonster.com

Hello Cismail via SQLMonster.com,

If you take out the no-spam from my eMail here you can reach me.



[quoted text, click to view]