Wednesday, March 7, 2012

schedule new verion of DTS Package

I have several DTS Packages that are scheduled to run every night. If I
change the Packages, which version will be run the following night? If its
the old one, how to I update the schedule to recognize the new version?
SQL2K SP3
TIA, ChrisRIf you do not specify the version # then it is always the latest
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know
"ChrisR" <bla@.noemail.com> wrote in message
news:Oypg1xKBFHA.2792@.TK2MSFTNGP15.phx.gbl...
>I have several DTS Packages that are scheduled to run every night. If I
> change the Packages, which version will be run the following night? If its
> the old one, how to I update the schedule to recognize the new version?
> --
> SQL2K SP3
> TIA, ChrisR
>|||Thanks Allen. Im still a bit in the dark though?
Is the version cotained in this type of deal?
DTSRun /~Z0x9F8F7D0B93BlaBlaBla
Is it updated when a new version is added?
"Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message
news:eZh24$KBFHA.2788@.TK2MSFTNGP15.phx.gbl...
> If you do not specify the version # then it is always the latest
> --
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
> www.konesans.com - Consultancy from the people who know
>
> "ChrisR" <bla@.noemail.com> wrote in message
> news:Oypg1xKBFHA.2792@.TK2MSFTNGP15.phx.gbl...
its[vbcol=seagreen]
>|||yuck.
This will wrap version up for you and you cannoot change it unless you
regenerate the string (DTSRUNUI). Personally I prefer to use the DTSRUN and
the non-encrypted versions.
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know
"ChrisR" <bla@.noemail.com> wrote in message
news:%23QnYYxLBFHA.2112@.TK2MSFTNGP14.phx.gbl...
> Thanks Allen. Im still a bit in the dark though?
> Is the version cotained in this type of deal?
> DTSRun /~Z0x9F8F7D0B93BlaBlaBla
> Is it updated when a new version is added?
>
> "Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message
> news:eZh24$KBFHA.2788@.TK2MSFTNGP15.phx.gbl...
> its
>|||Sorry to be such a pain Allan, but now Im really lost. Do you know if the
version gets updated when stored this way?
"Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message
news:ukprc3LBFHA.1564@.TK2MSFTNGP09.phx.gbl...
> yuck.
> This will wrap version up for you and you cannoot change it unless you
> regenerate the string (DTSRUNUI). Personally I prefer to use the DTSRUN
and
> the non-encrypted versions.
>
> --
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
> www.konesans.com - Consultancy from the people who know
>
> "ChrisR" <bla@.noemail.com> wrote in message
> news:%23QnYYxLBFHA.2112@.TK2MSFTNGP14.phx.gbl...
I[vbcol=seagreen]
If[vbcol=seagreen]
version?[vbcol=seagreen]
>|||No it does not.
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know
"ChrisR" <bla@.noemail.com> wrote in message
news:ewbUGKMBFHA.1292@.TK2MSFTNGP10.phx.gbl...
> Sorry to be such a pain Allan, but now Im really lost. Do you know if the
> version gets updated when stored this way?
>
> "Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message
> news:ukprc3LBFHA.1564@.TK2MSFTNGP09.phx.gbl...
> and
> I
> If
> version?
>

No comments:

Post a Comment