Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 regading sequence of task in DTS??

Author  Topic 

under2811
Constraint Violating Yak Guru

366 Posts

Posted - 2006-02-27 : 16:19:16
Hi..all
I created one DTS package there i have 6 task involved...i also scheduled it...but when i looked into Edit all package property..i saw all task but not in sequencial order..i.e task 1..task 2...task 4..task 6..task 3..task 5

is there effect of this on my package processing records...i.e is this order in which my package will run??? if not then why this arranged in this order????

T.I.A

Papillon

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-02-27 : 16:41:25
You need to use Workflow arrows to control the order of the tasks.

Tara Kizer
aka tduggan
Go to Top of Page

under2811
Constraint Violating Yak Guru

366 Posts

Posted - 2006-02-27 : 16:47:53
Thanx tara for ur quick responce..

i used work flow arrows...but why my task is not showing in sequence order in "Edit all package property"

i m bit confusing about this behavior of DTS...

T.I.A

Papillon
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-02-27 : 16:50:34
If you used workflow, then you don't have to worry about what it says in the Edit screen. Workflow will control the sequence.

Tara Kizer
aka tduggan
Go to Top of Page
   

- Advertisement -