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 |
|
rochak_agrawal
Starting Member
4 Posts |
 Posted - 2005-10-10 : 04:49:56
|
Hi guys, I have got a dts package and am facing strange results.  I have doing an import from a text file to a sql database table. I have also added an axscript send email task at the end of the transformation which gets triggered(supposed to trigger) if there is a failure in the import process. The import process works fine. To try to see error task, I changed removed the source text file from the folder. As expected, when I executed the package, there was an error on the task - but even then the axscript email task was not triggered. I have no clue why! I have set "Fail package on first error" and it seems everything else is ok. Any help would be appreciated. Thanks  |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-10-10 : 05:42:30
|
did you use workflow objects to redirect the flow to the "email" object?you can try to setup a job first to see the errors, it also handles failures beautifully  I setup all jobs with email to myself upon failure  --------------------keeping it simple... |
 |
|
|
rochak_agrawal
Starting Member
4 Posts |
Posted - 2005-10-10 : 09:03:27
|
| Jen, Thanks for your quick response. Yes I am using workflow object (success, failure, completion) to redirect the flow - I don't know of any other method. And yes, I have set the email to myself. I know the task is not running since the end of package execution shows that the "Email Task" is not run even though there was an error in the transformation. Any other idea would help a lot. Thanks |
|
|
|
rochak_agrawal
Starting Member
4 Posts |
Posted - 2005-10-10 : 09:12:49
|
| Jen, Thanks for your quick response. Yes I am using workflow object (success, failure, completion) to redirect the flow - I don't know of any other method. And yes, I have set the email to myself. I know the task is not running since the end of package execution shows that the "Email Task" is not run even though there was an error in the transformation. Any other idea would help a lot. Thanks |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-10-11 : 05:35:58
|
| when you say there's an error on the first task, the dts package failed altogether noh?the error that you know may not be interpreted as an error by sql.what exactly is the error message?--------------------keeping it simple... |
|
|
|
rochak_agrawal
Starting Member
4 Posts |
Posted - 2005-10-11 : 08:33:01
|
| Jen, I think that now you are hitting the nail on its head :) The error message is source file not found (obviously since I have removed the file from the folder). I guess the whole package is faling since I have set "Fail package on first error" to checked in package properties. Thanks |
|
|
|
|
|
|
|
|
DTS Error Fail