Hi,

I have a big issue.
I have created a DTS package whit some global variable as:
DestinationCatalog
DestinationDataSource

I will call this DTS using c#.net and I will give the global variable as
needed.

the problem I have is I have 300 import tables to import to the destination
(MS SQL). What I've done it's I have created a dynamic properties to set the
destionnationCatalog and destionantionDataSource to my Destination connection.

The thing is on the tranformation itself, even if i change the destination
catalog connection name, the transformation is failling because it is trying
to import to
[myOldcatalogname].[dbo][mytable] insteed of
[myNewcatalogname].[dbo][mytable] . (In here: Transform Data Task ->
Destionation -> Table name).

Is there any way that if I change the destination catalog name, it will
reflect in my data transformation as well so it will try to export to the
good catalog name (not my old one that I have initially created the dts)

thanks al og.

Hello abuck,

I think you may want to look at this article

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

By default the DestinationObjectName is made up of the DatabaseName.Owner.TableName


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com