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

SSIS – SQL task and Script Component

This below link explains in detail about creating a SSIS package in VS 2008, project folder structure and designer.  Good for a beginner. http://www.techbubbles.com/sql-server/creating-a-ssis-package-in-vs-2008/ Tasks in the Control flow toolbox: The Execute SQL Task: This task is widely used in the packages. http://www.sqlis.com/post/The-Execute-SQL-Task.aspx http://blogs.msdn.com/b/mattm/archive/2006/11/08/stored-procedures-with-output-parameters.aspx A word of caution is below: “MSDN recognize as a SSIS […]

Read More