Post reply

Integration Services Packages and email error

  • November 1, 2012 at 4:06 am

    #269450

    i have SQL Server Integration Services Packages, which contains foreach loop that get data from stored procedure write it to file and then it as attachment to different emails.

    the problem is that sometimes the email can't be sent and the loop "crash" and the next report isn't created. can i over come the email problem, so that all files will be created?

  • November 1, 2012 at 4:10 am

    #1554924

    You could set the MaxErrorCount property on the For...Each Loop to be a large number, this would then carry on until it reached error limit.

    Though you also probably want to capture the errors and which report it was creating so that you can have a look at the issue.

    _________________________________________________________________________
    SSC Guide to Posting and Best Practices

  • November 1, 2012 at 4:41 am

    #1554932

    thanks

  • November 1, 2012 at 4:49 am

    #1554935

    You could also separate the two tasks - first have the stored proc to update the data feeding the reports, and then add a different tasks (or have a job on sql server) to email out the reports?

  • November 2, 2012 at 2:08 am

    #1555305

    i used the MaxErrorCount solution its good for now

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

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