Post reply

SSIS Error handling using Script task

  • May 17, 2016 at 4:40 am

    #316561

    Hi,

    Am new to SSIS. Am using Data flow task to move data from source table to destination table.

    I need to capture the error description, task name and Package name and store it in error log table in the database.

    currently am achieving it through Execute SQL task.But i want to use Script Task and store the error in the error log table.

    Am using OLEDB connection manager to connect to database.

    Can some one help me to get this?

    Thanks in advance.

  • May 17, 2016 at 6:25 am

    #1879462

    The ExecuteSQL task is easiest. Why do you want to change?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • May 17, 2016 at 9:17 pm

    #1879733

    The error description needs to be altered and customized as per the requirement for which i cant use Execute sql task. the requirement is to use Script task. am using execute sql task currently and i have been told to use script task instead of execute sql task. so could you please help me?

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

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