Is there a way to do dynamic transformation mapping? Is there a way to have
SQL Server Automatically map Dbase files columns to table
columns? I'm trying to automate an import and have DTS programatically
change the source data file and corresponding destination table. I am having
a hard time finding how to have
SQL Server auto map the transformations. Any ideas??.

Thanks,
Subbu.

In article <Orllh8lcDHA.856 (AT) tk2msftngp13 (DOT) phx.gbl>, Subbaiahd
<subbaiahd (AT) hotmail (DOT) com> writes
No. The dynamic generation of transformations is only available in the
UI (Designer or Wizard). You could write some code that did this
yourself through, assuming there is a object model or system table
equivalent fro DBase that would allow you to get the meta data easily
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

Send me a mail privately and I will send you an example. I don't have it
with me here at work.

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Subbaiahd" <subbaiahd (AT) hotmail (DOT) com> wrote