i need to develop a DTS package that uses Oracle8i datanase tables as source
and SQL Server 2k tables as target. The mapping is one-one, meaning the
source columns are mapped to the target columns (no transformation at this
moment).
I need to do this for approx. 180 tables. Is there a way to automate these
transformations (to avoid that for table that needs to be transformed i need
to create a DTS package).
Do i have to do this with scripting, C#, ...?
Any help wellcome.
Guy

http://www.sqldts.com/default.aspx?299

will help you on your way.

--
Jacco Schalkwijk
SQL Server MVP


"Guy Dillen" <guy_dillen (AT) nospam (DOT) hotmail.com> wrote

Hi,

Not sure for what is THE best way, however, I have done once one VB app that
would set the properties for the DTS on the fly, with that and a bit of work
(a week maybe) a created a app that could read any table on the source and
load it into a one-one table on the destination. (you'll have to create more
connections just to read wich are the fields and its format wich you'll have
tranform to the correspondent in the DTS)

A bit hard, but worked very well for me.




"Guy Dillen" wrote:

In article <415168f0$0$11670$ba620e4c (AT) news (DOT) skynet.be>, Guy Dillen wrote:
I presume you want to dynamically pick up new tables on he source and create
new tales on the destination also?

This can be done but you will need to do things through code.

What happens if the definitions of the tbles changes as well?

Doable but a bit of work.


--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know

First of all thanks to all for the answers.

The ultimate goal is the end-user can select the tables that he/she wants to
move from source db to target db. To leave things simple i start with a one
to one mapping from source table to target table.
To store what tables should be moved i was thinking of using an xml file for
this or storing it in the SQL Server database?

Guy



"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote