SSIS Logging in Denali

Report Authoring on the SSIS Catalog [link]

SSIS Junkie — Tue, 02 Aug 2011 18:47:55 GMT

Just a short post here to let you know that the SQL Server Integration Services (SSIS) product team recently

London SQL Server User Group - 18th August 2011

SSIS Junkie — Fri, 19 Aug 2011 10:19:07 GMT

Yesterday evening I had the pleasure of presenting at the London SQL Server User Group meeting. It was

re: SSIS Logging in Denali

Julie Smith — Thu, 01 Sep 2011 03:46:34 GMT

Wow Jamie. Extremely informative and helpful post. Thanks! Logging for components--yay!

SSIS Reporting Pack v0.2 now available

SSIS Junkie — Sun, 04 Sep 2011 13:57:57 GMT

In December 2010 I announced in a blog post Introducing SSIS Reporting Pack for SQL Server code-named

What's new in SSIS in Denali?

SSIS Junkie — Wed, 07 Sep 2011 14:43:19 GMT

SQL Server codename Denali was presented to the world yesterday and with it a promise that there's a

re: SSIS Logging in Denali

Samuel Vanga — Fri, 08 Jun 2012 16:52:36 GMT

Hi Jamie,

Will it be bad practice to create new tables in the SSISDB database? I'm doing some metadata driven execution (For Loop container executes SPs retrieved from a table).

Wondering if this table can be created in SSISDB maybe under a new schema. Please let me know your opinion.

Thanks,

Samuel.

re: SSIS Logging in Denali

jamiet — Mon, 11 Jun 2012 08:03:26 GMT

Hi Samuel,

Your question of "*can* I do do this" is easy to answer - yes you can. The question of "*should* I do this" is a little harder. I mean, SSISDB is a user database so you can treat it like any other user database - I don't have any good guidance on whether its a good idea or not though I'm afraid.

re: SSIS Logging in Denali

SimS — Wed, 01 Aug 2012 09:52:22 GMT

Hi Jamie,

This is really useful, and my client is keen on seeing if we can use the Reporting Pack (customised).

Thanks a lot

Sim

re: SSIS Logging in Denali

Moham Mawla — Mon, 03 Sep 2012 18:49:33 GMT

Nice article

I think there's a type at the end of section [catalog].[execution_component_phases]

[catalog].[event_message_context] is logged to when LOGGING_LEVEL is set to Verbose and Performance.

The table name just should be [execution_component_phases]

Cheers

re: SSIS Logging in Denali

jamiet — Mon, 03 Sep 2012 21:52:19 GMT

Thank you Moham, fantastic spot. I have now corrected it.