SSIS

Package configurations, logging, error handling in ssis

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

Read More