Sticky destination database name
From: JRStern (jxstern_at_bogus.com)
Date: 02/09/05
- Next message: Steffany: "Re: Sticky destination database name"
- Previous message: Steffany: "Global Variable in Sub-Select Query"
- Next in thread: Steffany: "Re: Sticky destination database name"
- Reply: Steffany: "Re: Sticky destination database name"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 08 Feb 2005 16:44:50 -0800
I build a fancy DTS package to migrate data from a source database S
to a destination database D. But, I can't touch D right now, so I
actually build the package to use destination X. Everything works.
Now, I try to use a dynamic connection to set the destination initial
catalog (aka database) to D. But, all my transform steps have the
full [X].[dbo].[tablename] path, the [X] is sticking instead of
sliding to the [D] where it belongs.
Is this a known behavior? Is it a feature? Is there a way around
this "feature"?
Thanx.
Josh
- Next message: Steffany: "Re: Sticky destination database name"
- Previous message: Steffany: "Global Variable in Sub-Select Query"
- Next in thread: Steffany: "Re: Sticky destination database name"
- Reply: Steffany: "Re: Sticky destination database name"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
