Post reply

DTS Package Neither Succeeds Nor Fails

  • 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?

  • March 20, 2005 at 2:51 pm

    #547937

    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

  • March 21, 2005 at 10:02 am

    #548043

    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

  • March 21, 2005 at 1:18 pm

    #548066

    "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

  • March 22, 2005 at 5:32 am

    #548149

    Does email work from other DTS packages?

  • March 22, 2005 at 5:50 am

    #548153

    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! 

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

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