Re: Need help with DTS Package Maintenance
From: Tom Spitzer (tkspitzer_nojunk_at__yahoo.com)
Date: 08/03/04
- Next message: Sue Hoegemeier: "Re: permissions to run DTS"
- Previous message: Paul Tran: "raise error"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 2 Aug 2004 19:16:41 -0700
You can create DTS packages in VB, which is a text format. Therefore, you
can write a VB/DTS code generator which walks through systables and
syscolumns to build the transform objects in VB. We actually wrote our DTS
code generator in C#.
"Joseph Geretz" <jgeretz@nospam.com> wrote in message
news:%23kRcL4adEHA.3512@TK2MSFTNGP12.phx.gbl...
> I'm using a DTS package to perform database upsizing migrations from
> Interbase to SQL Server. The gist of it is I use ODBC to connect to the
> source Interbase Database and I make a SQL Server connection to the target
> SQL Server database. I then use a set of Transform Data tasks to pump the
> data on a table by table basis from the Interbase source database to the
SQL
> Server target database. Pretty straightforward.
>
> But this is presenting a maintenance problem for me.
>
> We have 77 tables in our database. We don't add table that often so it
would
> be an acceptable burden for me to track any added tables and add a
> corresponding Transform Data task for the new table. What's more
burdensome
> is the addition, deletion / redefinition of columns. As I've found out,
the
> Transform Data task doesn't do a SELECT * (which would accommodate table
> structure changes transparently) rather it does an explicit column by
column
> mapping. This means that for every structural change we'll need to perform
> maintenance on our DTS upsizing package.
>
> This could be a fairly significan burden. I'm searching for advice on how
to
> reduce this burden. Thanks for any suggestions which you can offer!
>
> - Joe Geretz -
>
>
- Next message: Sue Hoegemeier: "Re: permissions to run DTS"
- Previous message: Paul Tran: "raise error"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
