Post reply

MaxErrorCount property SSIS

  • April 4, 2012 at 8:13 pm

    #253561

    Which msdb table has this property stored for packages? I have several packages stored in msdb and need to see what the MaxErrorCount Property for each of the packages is.

  • April 5, 2012 at 1:58 pm

    #1469803

    You won't find it in a separate column. The property pertains to any Task within the SSIS package so you would need to look for it in the XML that makes up the SSIS package itself on each of the relevant tasks.

    SELECT CAST(CAST([packagedata] AS VARBINARY(MAX)) AS XML)

    FROM msdb.dbo.sysssispackages;

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

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

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