Re: Creating a Connection to Database that Does Not Yet Exist

From: ERR (anonymous_at_discussions.microsoft.com)
Date: 02/13/04 

Date: Fri, 13 Feb 2004 04:40:56 -0800

I forgot to mention that I do have an initial connection,
the one to the original database. However, I need my DTS
package to create a connection to the NewDatabase
database once the task of restoring with a new name is
complete.

Thanks in advance!

>-----Original Message-----
>You should be able to connect to the master database to
do what you need to
>do initially.
>
>--
>Ray Higdon MCSE, MCDBA, CCNA
>---
>"ERR" <anonymous@discussions.microsoft.com> wrote in
message
>news:ef7b01c3f1b0$3f8eff20$a301280a@phx.gbl...
>> Hello All!
>>
>> I am in the process of developing a DTS package. My
>> package will behave as follows:
>> 1. Backup my live database.
>> 2. Using the backup from Step 1., the backup will be
>> restored using a DIFFERENT name (NewDatabase).
>> 3. Manipulate NewDatabase database.
>>
>> How can I create a connection in my DTS Package when,
at
>> the time I am creating the package, the NewDatabase
>> database does not exist? Do I have to use Disconnected
>> Edits? If so, how? Or, do I use Microsoft Data Link?
>> If so, how? Or, do I use something else. (As you can
>> tell from my questions, I am not an expert at this :-)
>>
>> Any suggestions are greatly appreciated!!
>
>
>.
>

Relevant Pages
Quantcast