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.
| Author |
Topic |
|
cheechwan
Starting Member
11 Posts |
 Posted - 2006-07-19 : 01:59:09
|
| Dear Experts,Im have created a DTS Package in MS. SQL Server 2000, I do encounter a problem where after execution of the failure task, the success precedence could not continue to the next SQL task.For example:ExecuteSQLTask1-->Success-->ExecuteSQLTask2-->Success-->ExecuteTask3ExecuteSQLTask1-->Failure-->ExecuteSQLTask4-->Success-->ExecuteTask2When i execute the package as refer to the step illustrate above, only ExecuteSQLTask1 is running, and all of the other task could not be run.Could anyone know what are the issue?Thanks.RegardsChee Chwan |
|
|
humanpuck
Yak Posting Veteran
94 Posts |
Posted - 2006-07-19 : 11:12:12
|
| Can you attach a screenshot of your DTS package? |
 |
|
|
cheechwan
Starting Member
11 Posts |
Posted - 2006-07-21 : 04:21:51
|
| Hi HumanpuckDo u have email? so that i can directly post the screen shot for you to have a look for me?ThanksSteven Leong |
|
|
|
cheechwan
Starting Member
11 Posts |
Posted - 2006-07-25 : 09:30:55
|
Hi Humanpuck,Do you have any email? so that i can direct email you the screenshot.Anyway, u can direct email me cheechwan@yahoo.com, if you not convenient to post your email address.Thanksquote:
Originally posted by humanpuck
Can you attach a screenshot of your DTS package?
|
|
|
|
humanpuck
Yak Posting Veteran
94 Posts |
Posted - 2006-07-25 : 09:50:11
|
| I can post my personal email... human.puck@gmail.com, but I can't check it out until I get home. Send me the SS's and I'll see if I can help. |
|
|
|
|
|
|
Execute next SQLQuery Task after failure step(DTS)