dbTalk Databases Forums  

Attn: Allan Mitchell

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Attn: Allan Mitchell in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Cismail via SQLMonster.com
 
Posts: n/a

Default Attn: Allan Mitchell - 05-11-2006 , 08:42 AM






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
http://www.sqlmonster.com/Uwe/Forums...r-dts/200605/1

Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: Attn: Allan Mitchell - 05-15-2006 , 05:31 AM






Hello Cismail via SQLMonster.com,

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



Quote:
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.




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.