Archive

Posts Tagged ‘event handlers’

Package configurations, logging, error handling in ssis

October 12, 2011 Leave a comment

The following links explains the different package configurations methods provided in SSIS.
http://biresort.net/cfs-file.ashx/__key/CommunityServer.Components.PostAttachments/00.00.00.00.20/SSIS_5F00_EX_5F00_01_5F00_PCKCFG.zip

http://www.techbubbles.com/sql-server/ssis-package-configuration-in-sql-server-2008/?utm_source=BlogGlue_network&utm_medium=BlogGlue_Plugin

Logging, error handling

Logging and error handling helps a lot for general audit and during debugging, when a problem comes from no where.

http://consultingblogs.emc.com/jamiethomson/archive/2005/06/11/SSIS_3A00_-Custom-Logging-Using-Event-Handlers.aspx

http://pragmaticworks.com/Products/Business-Intelligence/BIxPress/ssis-logging-auditing-monitoring.aspx

Advertisements