For the record for JOBS - you do utilize the GENERATE SQL SCRIPT - then run
the SQL on the New DB server/database.
Thanks!
Brad
-----Original Message-----
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Saturday, July 31, 2004 9:57 PM
To: SQL
Subject: Re: Moving DTS and JOBS from one SQL server to another...
yes.
as long as you can see it.
you can do so.
open the dts up, on the menu, hit package, save as, should be self
explanatory from there.
hth
tony
On Thu, 29 Jul 2004 10:54:07 -0600, Bradford T Comer
<[EMAIL PROTECTED]> wrote:
> is there a easy way to do this? Any help is appreciated!
>
> Thanks
> Brad
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
