| Author |
Topic |
|
fmardani
Constraint Violating Yak Guru
433 Posts |
 Posted - 2004-06-11 : 11:34:11
|
| Hi,I have been working on finding out why my on failure does not work and no luck as yet.I have tried the fail package on step failure options ,etc... but still the failure does not work.Any thoughts?Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-11 : 13:00:33
|
| Well is the previous step failing? How are you setting the previous step to failure?Tara |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-06-11 : 15:30:42
|
| Yeah...it's not failing?Brett8-) |
|
|
|
fmardani
Constraint Violating Yak Guru
433 Posts |
Posted - 2004-06-11 : 16:38:02
|
| The previous is indeed failing. And really the on failure should work then but it does not. This is very strange. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-11 : 16:39:31
|
| So what is the previous step doing? What kind of task is it? And you have an on failure connector between the two steps, right?Tara |
|
|
|
fmardani
Constraint Violating Yak Guru
433 Posts |
Posted - 2004-06-11 : 18:21:32
|
| Yes, there is an on failure as well as on success between the two. The on success works when there is no error.If for example in the first one I have a query such as select * from badtable then it fails and dts gives an error on the screen but on failure does not get fired. |
|
|
|
fmardani
Constraint Violating Yak Guru
433 Posts |
Posted - 2004-06-11 : 18:41:20
|
| This must be to do with the package itself because I created a simple dts package with on failure and it worked. I just can't figure out what the problem is with the package itself if any.Thanks |
|
|
|
fmardani
Constraint Violating Yak Guru
433 Posts |
Posted - 2004-06-11 : 19:51:19
|
| Any ideas please? |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-06-11 : 23:32:15
|
quote:
Originally posted by fmardani
Any ideas please?
You've given us so much to go on - where should I start?My suggestion is for you to fill us in on exactly what your DTS package should be doing/is doing/is not doing so we can help you with this.Be very specific. What data sources are you using (Oracle, flat file, SQL Server, Sybase, etc.), are you using ODBC or OLEDB or ?, what kind of transformations are you performing? etc.The more information you give us the better we can help you out.-ec |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-12 : 00:37:38
|
| I would recommend recreating the DTS package.Tara |
|
|
|
fmardani
Constraint Violating Yak Guru
433 Posts |
Posted - 2004-06-12 : 09:10:33
|
| The DTS package is quite large and re-creating it will take a long time.The dts starts by having a sql server connection. A source of a txt file which will then transform data into a table. On success and on failure are connnected. This is the first part of the dts package if the on failure for this part works then I will probably be able to fix the rest accordingly. Thanks |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-06-12 : 09:55:20
|
| You are not giving us anything to help you with. I suggest you open a ticket with Microsoft.-ec |
|
|
|
fmardani
Constraint Violating Yak Guru
433 Posts |
Posted - 2004-06-12 : 13:20:49
|
| Hi, I apologize for the lack of information but what else can I give you as information?Thanks |
|
|
|
ansase
Starting Member
1 Post |
Posted - 2004-06-16 : 07:38:27
|
| I had the same problem when more than one task was connected to the same task on failure. To solve the problem I had to create a unique task for every "on failure"./Sandgren |
|
|
|
fmardani
Constraint Violating Yak Guru
433 Posts |
Posted - 2004-06-16 : 18:53:33
|
| I managed to fix it by unchecking the fail package in DTS properties. Thanks guys |
|
|
|
|
dts on failure