Showing posts with label packages. Show all posts
Showing posts with label packages. Show all posts

Thursday, March 22, 2012

Backup DTS packages

We have a development environment where there are 4 development servers and a single production server.

some of our processes rely of some complex DTS packages.

what is the perferred method to create copies of these DTS packages so that they can be put onto all the development systems ?Check out this article:

http://www.codeproject.com/useritems/DTS_Export.asp|||thanks - thats what i was looking for.

it even has the added bonus of some code to reset all the connections to a different server.sql

Thursday, February 16, 2012

Backup

How do you back up the Agent Jobs and the Local Packages under Data
Transformation services? Does this get backed up when you back up the Master
database?
Thanks
RickThey get backed up when you backup the msdb database.
-Sue
On Wed, 13 Aug 2003 15:14:27 -0700, "Rick V"
<rick@.di-wave.com> wrote:
>How do you back up the Agent Jobs and the Local Packages under Data
>Transformation services? Does this get backed up when you back up the Master
>database?
> Thanks
> Rick
>|||Thanks very much!!!
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:9ngljvsocne65i7n5lsftphqpddsqs579u@.4ax.com...
> They get backed up when you backup the msdb database.
> -Sue
> On Wed, 13 Aug 2003 15:14:27 -0700, "Rick V"
> <rick@.di-wave.com> wrote:
> >How do you back up the Agent Jobs and the Local Packages under Data
> >Transformation services? Does this get backed up when you back up the
Master
> >database?
> >
> > Thanks
> > Rick
> >
>