Post reply

SSIS how I can locate a task item in the package

  • March 28, 2012 at 4:27 pm

    #255695

    I have a ssis package that is pretty complicated.

    In the package, the first step is to start a customized log, then insert records into a table.

    Then later after the job is done, update a column like runEnddate to the table.

    I can find the start log SQl task in the package, but I just cannot find the End Log task.

    I searched in the code view of the pacakge : I can find something like below:

    How can I find it in design view? I know it exists somewhere in the package because I see the data is updated in the log table, but just cannot find it ?

    DTS:DataType="8"></DTS:Property></DTS:LoggingOptions>

    <DTS:Property DTS:Name="ObjectName">SQL OnError</DTS:Property>

    <DTS:Property DTS:Name="DTSID">{735B1C9C-D4D9-4C8D-A2B3-3441ACD4C0C1}</DTS:Property>

    <DTS:Property DTS:Name="Description">Execute SQL Task</DTS:Property>

    <DTS:Property DTS:Name="CreationName">Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91</DTS:Property>

    <DTS:Property DTS:Name="DisableEventHandlers">0</DTS:Property><DTS:ObjectData><SQLTask:SqlTaskData SQLTask:Connection="{62620965-AC25-4AA6-BE25-5992F2A36DBD}" SQLTask:TimeOut="0" SQLTask:IsStoredProc="False" SQLTask:BypassPrepare="True" SQLTask:SqlStmtSourceType="DirectInput" SQLTask:SqlStatementSource="DECLARE @RunId int DECLARE @MasterPackageName varchar(100) DECLARE @TaskName varchar(100) DECLARE @errorcode int DECLARE @ErrorDesc varchar(100) SET @RunId = ? SET @MasterPackageName = ? SET @TaskName = ? SET @errorcode = ? SET @ErrorDesc = ? DECLARE @ErrorMessage varchar(250) SET @ErrorMessage = 'FAILED - (' + CAST(@ErrorCode AS varchar(10))+ ') - ' + @ErrorDesc IF @MasterPackageName = @TaskName BEGIN UPDATE Staging.Run SET RunEndTime = GETDATE(), Result = @ErrorMessage WHERE RunId = @RunId END ELSE BEGIN SET @ErrorMessage = 'Task ' + @ErrorMessage EXEC CORE_STAGING.STAGING.AddEvent @RunId, @TaskName, @ErrorMessage END" SQLTask:CodePage="1252"

  • March 28, 2012 at 4:50 pm

    #1466087

    I figure it out, it is in event handler.

    thanks

  • March 28, 2012 at 4:51 pm

    #1466088

    Good - glad you posted back that you found the answer.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

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

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