I have serveral dts packages saved on the server.
they contain a very large amount of tables(hundreds)

i have made a ini file to determine the source database and the
destination(db and server) that works fine.

however dts package stored from a wizzard contain full DestinationObjectName
= [wbrap].[dbo].[carte]

would llike to change that via VB to [carte]

thanks in advanced

--
@ddy

Unfortunately you will need to using code.

You will need to loop through the packages

Enumerating DTS Packages using VB.Net
(http://www.sqldts.com/default.aspx?250)

Open
Seek each DestinationObjectName property
Set to the right value

Changing the DataPump Source and Destination Tables
(http://www.sqldts.com/default.aspx?213)

Save back




"eddy van beek" <eddyvanbeek (AT) discussions (DOT) microsoft.com> wrote

thanks Allan need to do some coding but well get thre

"Allan Mitchell" wrote: