Post reply

SSIS Package wont fail

  • April 14, 2016 at 3:33 am

    #318108

    Hi

    I am running an ssis package through an agent job and it wont fail.

    if it gets to a point where it fails it just report success without any error message.

    I have put code in that I know will fail but it just stops at that point and reports success.

    I need an error message to find out what I need to fix.

    any ideas?

    Thanks

  • April 14, 2016 at 6:06 am

    #1871943

    What script or package you are running? What it is supposed to do?

  • April 14, 2016 at 7:05 am

    #1871964

    it is getting data from text files and putting it back in other text files

    the text files were on the file server and I moved them to the sql server which fixed the issue

    the package still doesn't error tho, it just reports successful no matter what

  • April 14, 2016 at 6:27 pm

    #1872203

    are you executing the package on the file system or on Sql Server? and if on Sql Server are you setting it to run asynchronously or synchronously?

    if running asynchronously it will return success to Agent as this does not wait for package to finish.

Viewing 4 posts - 1 through 3 (of 3 total)

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