"Derek Ruesch" <DerekRuesch@discussions.microsoft.com> wrote in message
news:FFB34EAE-6616-47AF-B7E4-26F0DEE74E80@microsoft.com...
>I have several DTS packages scheduled to run twice a day. How many minutes
> apart to you need to schedule these packages? I.E. Should I have Package1
> run
> a minute before Package2 and have Package2 scheduled to run a minute
> before
> Package3, etc? What happens if Package1 isn't done running by the time
> Package3 is scheduled to execute?
>
> Thanks for the help. Derek

"Derek Ruesch" <DerekRuesch@discussions.microsoft.com> wrote in message
news:20E6C4EF-8011-4854-90B3-A8A25C7279DC@microsoft.com...
> Actually they don't rely on one another. I just labeled them as such
> because
> I couldn't come up with any generic names.
>
>
> Derek
>
> "Allan Mitchell" wrote:
>
>> What?
>>
>> Why not put them in 1 package and use the Execute Package task. It
>> sounds
>> like they logically rely on each other so it would seem prudent to do
>> this.
>>
>> --
>> --
>>
>> 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
>>
>>
>> "Derek Ruesch" <DerekRuesch@discussions.microsoft.com> wrote in message
>> news:FFB34EAE-6616-47AF-B7E4-26F0DEE74E80@microsoft.com...
>> >I have several DTS packages scheduled to run twice a day. How many
>> >minutes
>> > apart to you need to schedule these packages? I.E. Should I have
>> > Package1
>> > run
>> > a minute before Package2 and have Package2 scheduled to run a minute
>> > before
>> > Package3, etc? What happens if Package1 isn't done running by the time
>> > Package3 is scheduled to execute?
>> >
>> > Thanks for the help. Derek
>>
>>
>>