Re: Local Packages and Meta Data Services Packages - differences?

From: The Margolins (margolin_no_spam__at_optonline.net)
Date: 01/05/05 

Date: Tue, 4 Jan 2005 22:24:00 -0500

Rob,

Take a look at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtssql/dts_pkgmng_6w6d.asp.
In short package saved in meta
data services allows for complete audit of data transformations at the
expense of speed. As for backing up packages neither of saving options does
it by itself. It is your responsibility to safeguard your packages. Usually
it is done by backing up databases/directories that contain packages.

Ilya

"Rob Meade" <robb.meade@NO-SPAM.kingswoodweb.net> wrote in message
news:mwDCd.3287$GG1.2243@text.news.blueyonder.co.uk...
> Hi all,
>
> At work when ever we have created any dts's we've always saved them in
meta
> data services packages - today the question arose as to why...
>
> I know nothing about either of these areas accept for "its somewhere I can
> save my dts's"...
>
> When I spoke to a colleague he suggested that SQL Server doesn't backup
the
> dts's if they are in local packages, and this is why we've always stored
> them in the meta data...
>
> I was hoping someone could give me some clarification of this, and also
any
> other reasons why one is better than the other, or why we might want to
use
> one rather than the other...
>
> The one thing that we have found is that moving existing dts's to a new
> server, using "Save As.." doesn't stick em in the meta data "area", and
thus
> this has caused us a few headaches...
>
> Any info (aimed at the beginner) would be appreciated :o)
>
> Regards
>
> Rob
>
>

Relevant Pages

  • Re: Image versus package savers?
    ... exporting then backing up your packages frequently, ... Things that I consider risky include: newly changed external interfacing; failure of an MVP triad to open correctly; note that you should never save an image if the dreaded prim g2 garbage collector walkback appears. ...
    (comp.lang.smalltalk.dolphin)
  • Re: CSTD=c99 breaks package creation
    ... > Backing out the recent changes to bsd.sys.mk fixed these problems. ... but pkg_create was creating packages that were ... > standards. ... If you can wait until after USENIX, ...
    (freebsd-current)
  • Re: Image versus package savers?
    ... exporting then backing up your packages frequently, ... The STS ... tools) is that I don't have a versioned history of external resources such as ...
    (comp.lang.smalltalk.dolphin)
  • Re: Image versus package savers?
    ... Once I'm beyond the "testing" phases of worksheets, etc, ... able to remake the image quickly from the packages has been very handy. ... exporting then backing up your packages frequently, ... images) and one for primarily text files (exported packages, ...
    (comp.lang.smalltalk.dolphin)
  • Re: a question about finding a couple of packages
    ... packages I need are they installed by default if not what are the ... Here's a nice way you can find perl packages based on the module name ... Everyone wants to live at the expense of the state. ... the state lives at the expense of everyone. ...
    (Fedora)