Post reply

Error log creating in ssis package

  • September 13, 2011 at 8:14 am

    #247637

    Hi

    I am trying to execute five stored procedures at a time with the use of single execute sql task in ssis package.

    In that query is,

    Exec sample1

    Exec sample2

    Exec sample3

    Exec sample4

    Exec sample5

    but my requirement is in that any of the stored procedure will happening an error means, I need show that perticular sp name and what is the error.

    I was created one event handler with the type is onerror and also created logging for that pkg, in that showing all the sp names that is what i am writing in the previous queries list .

    but i need perticular sp name.

    how can i acheive this requirement any body send me the quick response.

    Thanks in advance

    Radh

  • September 14, 2011 at 6:36 am

    #1381231

    I would do this in TSQL with the TRY ... CATCH construct, as it is impossible for SSIS to know which stored procedure failed. For SSIS, it is just the Execute SQL Task that succeeds or fails.

    http://msdn.microsoft.com/en-us/library/ms175976.aspx

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 2 posts - 1 through 1 (of 1 total)

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