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...
> >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
> >
> >
>|||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...
>> 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...
>> >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
>> >
>> >
>>
>|||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...
> > 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...
> >> >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
> >> >
> >> >
> >>
> >>
> >
> >
>|||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...
>> 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...
>> >> 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...
>> >> >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
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>>
>