Skip to content

Instantly share code, notes, and snippets.

@ClassyCircuit

ClassyCircuit/ssisdb.sql

Last active May 11, 2018 11:17
Show Gist options
  • Save ClassyCircuit/2c5b0970af87e8541cc405756af28168 to your computer and use it in GitHub Desktop.
Save ClassyCircuit/2c5b0970af87e8541cc405756af28168 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. ClassyCircuit revised this gist May 11, 2018. 1 changed file with 6 additions and 2 deletions.
    8 changes: 6 additions & 2 deletions ssisdb.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -1,6 +1,10 @@
    --get detailed operation info, such as: DFT Load IDW_Claims from archived file:Information: The total number of data rows processed for file "\\swr10775\AISFIDA\ATEST\ETLdata\Input\IDW\Archive\20160603\IDW_Claims_24_119673_19720919000000_20160309000000.txt" is 119674.

    select *
    from SSISDB.catalog.operation_messages
    where operation_id = '1932692'
    and message like '%Claims%'
    and message like '%Claims%'

    --get all event messages based on execution ID
    select *
    from [SSISDB].[catalog].event_messages
    where operation_id = '224189'
  2. ClassyCircuit renamed this gist May 10, 2018. 1 changed file with 0 additions and 0 deletions.
    0 gistfile1.txt → ssisdb.sql
    View file
    File renamed without changes.
  3. ClassyCircuit created this gist May 10, 2018.
    6 changes: 6 additions & 0 deletions gistfile1.txt
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,6 @@
    --get detailed operation info, such as: DFT Load IDW_Claims from archived file:Information: The total number of data rows processed for file "\\swr10775\AISFIDA\ATEST\ETLdata\Input\IDW\Archive\20160603\IDW_Claims_24_119673_19720919000000_20160309000000.txt" is 119674.

    select *
    from SSISDB.catalog.operation_messages
    where operation_id = '1932692'
    and message like '%Claims%'