DTS Package Neither Succeeds Nor Fails

Question

DTS Package Neither Succeeds Nor Fails

Matthew Boorstin

SSC Enthusiast

Points: 143
More actions
March 19, 2005 at 7:24 am

#60710

Greetings all,
I have a package that is not even reaching the stage where it can say to itself "Package Failed" or "Package Succeeded", meaning I don't even get the email that is sent "On Failure".
Any thoughts on what can cause this? I thought anytime a package didn't complete, it was considered a failure and would at least go to the "On Failure" step. Is there a timeout on DTS scripts the way there is on ASP scripts? Even then, shouldn't it return an error?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

philcart SSC-Forever Points: 47794 More actions · Answer 1

Mathew

In order to provide a useful answer instead of a stab in the dark, can you give use more information about your problem?

How are you calling the package? What does the package do? Have you turned on Package Logging?

--------------------
Colt 45 - the original point and click interface

Phillip Grant Grasshopper Points: 13 More actions · Answer 2

Hi Matthew,

Yes, I agree with Phil Carter, we really need more info, but here are a couple of things that might help you narrow it down.

1. Setup package logging, and give it a file name.

2. Comment out any ON ERROR RESUME NEXT in any VB Script. If you have any of these lines in your script code, the step will think it succeeded, irregardless of an error happening.

3. Add some logging (or MessageBox calls) of your own (IF you have any script code running in the package) in your code.

Hope this Helps,

Phillip Grant

Calvin Lawson SSChampion Points: 11030 More actions · Answer 3

"3. Add some logging (or MessageBox calls) of your own"

Actually, mxgbox calls could cause the problem described. a msgbox call that has an "OK" button is going to stall your vb script, until the button is clicked (which you can't do when running it under SQLAgent or windows scheduler).

Signature is NULL

SueM SSC Veteran Points: 273 More actions · Answer 4

SueM

SSC Veteran

Points: 273

March 22, 2005 at 5:32 am

#548149

Does email work from other DTS packages?

Matthew Boorstin SSC Enthusiast Points: 143 More actions · Answer 5

Sorry It took so long to reply. Basically I've got a package that makes a complicated SQL query to determine which of the people in our network have gotten a referral from us, seen that client, and neglected to pay our referral fee. It then sends an email to those people.

The query works, because if I limit the number of emails the package sends to 20, I get those emails. But if I let it run through the entire batch (usually 70-80) I never get anything, no email, no success message, no failure message.

If there was a problem with the query when it reached, say, vendor 67, wouldn't it's fail the package and send the "On Failure" response? Or do SQL queries not fail the package?

The only other thing I can think of is a timeout, because the query is complicated. Is there a 90 second limit for DTS packages like there is for ASP scripts? Even then, wouldn't it fail the package if it ran out of time?

Thanks!