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
SSISDB queries
Raw
ssisdb.sql
--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%'
--get all event messages based on execution ID
select *
from [SSISDB].[catalog].event_messages
where operation_id = '224189'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment