Re: Versioning DTS Packages

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

anonymous_at_discussions.microsoft.com
Date: 08/18/04 

Date: Wed, 18 Aug 2004 13:33:11 -0700

Jyotsna,
That will change the association in the job. What I do is
go to the new package that I just saved and right click
and go to schedule job. Once it created the job I open it
up and go to the steps tab. I then double click on the
step there and it shows me something like this :

DTSRun /~Z0x0F1FF9AE6DF2AA57D9D24EF439FCF737D4A65671C74D96F
D0CD18E4C2757E45788FB89F76CE751E50E985CD3A9EC5E223D48BF24C6
FCDC631CE3733FCB8C3E8F71F83B0746B7D76E05DCE030E5FC01E21818A
B93F18D6023F9036B47BFFA430B824AF205ED6233395EC71E4AE6B92EEB
CE8E5CB2DCEB6FD2FB1F1364F1FF6CD69FC057603D4E9BCE7C4CFFB8EAC
2A12667D3F2

I will copy all this and then go to my original job and
past it into that job's command area. I know it's a
hassle. I hope this helps.

>-----Original Message-----
>Thank you Jerry, for the response.
>
>You're exactly right, I do have the package saved under
the same name on the
>production server. This is because it was the previously
saved version. I
>had considered the idea of deleting it from production
and then saving the
>new version, but wouldn't that impact the job associated
with the package?
>That is, the job would need to be re-created too,
correct, since it is
>referencing the old package? I was wondering if there
was an
>alternative/seamless solution, for a Dev/QA/Prod
transition...
>
>Thanks,
>-Jyotsna
>
>
>"jerry" wrote:
>
>> Jyotsna,
>> You more then likely already have it saved using that
>> name. It doesn't let you overwrite it. What I do it
>> delete the old version out of Enterprise Manager and
then
>> save it in SQL Server.
>>
>> >-----Original Message-----
>> >I have a related question - I am trying to save DTS
>> packages to VSS as .dts
>> >files from our QA environment. Following that I would
>> like to deploy the
>> >latest version of that file to the production
>> environment. How can I do so?
>> >I tried opening the .dts file on the production
server,
>> but when I try to
>> >save it to the server it errors out saying that there
is
>> an existing package
>> >with the same name but different ID, and therefore I
>> cannot save to that
>> >package. I do need to replace that package though, as
>> otherwise the related
>> >job will not execute the new version...
>> >
>> >Thanks!
>> >-Jyotsna
>> >
>> >"Allan Mitchell" wrote:
>> >
>> >> You can save the same package to the same .dts
file.
>> When you come to open
>> >> it through EM you will be asked what version you
want
>> with a Date of
>> >> modification
>> >>
>> >> Also
>> >> You can retrieve information about the contents of a
>> DTS package storage
>> >> file, which can contain multiple packages, each with
>> multiple versions.
>> >> Create a Package2 object and then use the
>> GetSavedPackageInfos method to
>> >> return a reference to a SavedPackageInfos collection
>> with information about
>> >> all the package versions contained in the file.
>> >>
>> >>
>> >> --
>> >> --
>> >>
>> >> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
>> >> www.SQLDTS.com - The site for all your DTS needs.
>> >> www.konesans.com - Consultancy from the people who
know
>> >>
>> >>
>> >> "Jerry" <anonymous@discussions.microsoft.com> wrote
in
>> message
>> >> news:717701c483a0$121b46c0$a601280a@phx.gbl...
>> >> > Allan,
>> >> > We do save them off into a structured storage file
and
>> >> > that is what we take when we go out to the client
>> site to
>> >> > do a release. The problem with that is there is no
>> >> > version tied to that DTS file. We want a way to
make
>> sure
>> >> > that this is the correct version going out and be
>> able to
>> >> > double check it while we are out at the clients
>> site. I
>> >> > can't have the version in a GUID, I need it in a
>> regular
>> >> > format do you know if this is possible?
>> >> >
>> >> > Thank You
>> >> > Jerry
>> >> > >-----Original Message-----
>> >> > >Packages in sysdtspackages will have a new row
for
>> every
>> >> > time you save it
>> >> > >back
>> >> > >
>> >> > >Name and ID will be the same
>> >> > >VersionID will be different as will CreateDate
>> >> > >When saving out to a VB module you will be saving
>> out the
>> >> > latest version.
>> >> > >
>> >> > >You could also save to structured Storage file
and
>> book
>> >> > that into Source
>> >> > >Control.
>> >> > >
>> >> > >--
>> >> > >--
>> >> > >
>> >> > >Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server
MVP)
>> >> > >www.SQLDTS.com - The site for all your DTS needs.
>> >> > >www.konesans.com - Consultancy from the people
who
>> know
>> >> > >
>> >> > >
>> >> > ><anonymous@discussions.microsoft.com> wrote in
>> message
>> >> > >news:5bda01c4815e$c8002c60$a501280a@phx.gbl...
>> >> > >> Vyas,
>> >> > >> How can I read that version guid in
sysdtspackages
>> into
>> >> > a
>> >> > >> normal version number that I can use in my
tracking
>> >> > system?
>> >> > >>
>> >> > >> How can you get the version by saving off into a
>> >> > VBScript
>> >> > >> file?
>> >> > >>
>> >> > >> Thank you for all your help
>> >> > >>
>> >> > >> Jerry
>> >> > >>
>> >> > >> >-----Original Message-----
>> >> > >> >DTS Packages are versioned by default in SQL
>> Server.
>> >> > >> Everytime you save the
>> >> > >> >DTS package, a new version is saved in the
>> >> > >> msdb..sysdtspackages. You can see
>> >> > >> >these versions in the Enterprise Manager, by
right
>> >> > >> clicking on the DTS
>> >> > >> >packages.
>> >> > >> >
>> >> > >> >Another way would be to script the DTS package
as
>> a
>> >> > >> VBScript file, and check
>> >> > >> >that VB script file into VSS.
>> >> > >> >--
>> >> > >> >Vyas, MVP (SQL Server)
>> >> > >> >http://vyaskn.tripod.com/
>> >> > >> >
>> >> > >> >
>> >> > >> >"Jerry" <anonymous@discussions.microsoft.com>
>> wrote in
>> >> > >> message
>> >> > >> >news:582b01c48153$cfbaefe0$a301280a@phx.gbl...
>> >> > >> >> Does anyone know how I can version my DTS
>> packages so
>> >> > >> when
>> >> > >> >> I track them I can just track the versions?
I
>> will
>> >> > use
>> >> > >> >> this version number to label my directory in
>> source
>> >> > >> safe.
>> >> > >> >>
>> >> > >> >> Thank You
>> >> > >> >> Jerry
>
>.
>

Relevant Pages

  • TSLSA-2007-0007 - multi
    ... Affected versions: Trustix Secure Linux 2.2 ... The mod_php module enables the Apache web server to ... The postgresql package includes the client programs and libraries ... SECURITY Fix: Fetchmail does not properly enforce TLS and may ...
    (Bugtraq)
  • Re: remotely call a DTS
    ... Allan Mitchell wrote: ... Denied on something inside the package. ... This worked when I was logged into the server and ran it from my ... but the DTS blows up. ...
    (microsoft.public.sqlserver.dts)
  • Re: sunmanagers Digest, Vol 34, Issue 14
    ... Christopher sent me a link to ftp.cs.tu-berlin.de that has all patches sun ... Subject: SUMMARY: Setting up mail on a Solaris Server ... however I seem to be having issues finding a binary package. ... Problems while installing 108528-29 for Sol8 machine ...
    (SunManagers)
  • Re: DTS Environment Control
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... When run from the production environment, the production server is accessed and when run from the test environment, the test server is accessed. ... For simple packages it's not too big of deal - but for more complete ones - you can spend an hour carefully changing all your connections. ... I had one solution where we would add an ActiveX script task as the very first step, that would determine what SERVER the package was executing from - and based on that would dynamically change all the connections by looking up the package name and server from a DB. ...
    (microsoft.public.sqlserver.dts)
  • is yum working? unable to update a system
    ... # yum update ... Server: Dag RPM Repository for Fedora Core ... .Package mplayer-mencoder needs libxvidcore.so.2, this is not ...
    (Fedora)