SSIS

Useful links related to SSIS

Here are some random topics related to SSIS, but might be useful sometimes. The below link explains how to implement batch processing in ssis http://www.mssqltips.com/sqlservertip/1504/how-to-implement-batch-processing-in-sql-server-integration-services-ssis/ Scheduling the SSIS Package as a Job http://decipherinfosys.wordpress.com/2008/09/17/scheduling-ssis-packages-with-sql-server-agent/ OLE DB Connection in SSIS Package does not remember password It might happen sometimes during password change.  Logging off or  Shutting down […]

Read More

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

How to call wcf service from ssis 2005

The following link explains how to call wcf service using a web service task. http://www.technade.com/2009/08/how-to-call-wcf-service-using-web.html A point to note is that the scripting in ssis 2005 has .Net 2.0 framework. XmlSerializer is quite an old technology which is used in web services. Windows Communication Foundation supports it for backwards compatibility. The DataContractSerializer does not support […]

Read More

Script Component in SSIS

In the following link, the script component is described with some examples. http://www.codeproject.com/KB/miscctrl/SSIS_Script_Component.aspx The above link notes the two types of transformation in the script component: Synchronous Transformation The output is synchronized with the input and the input data will be processed on a row by row basis. Asynchronous Transformation The output is not synchronized […]

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

Data Integration Services

Data, Data, every where, And all the boards did shrink; Data, Data, every where, Nor any drop to drink.[1] Of what use is the ocean of data, if it can not quench our thirst for decision-making- information. Introduction [2] Data can help us to understand the past better and get direction for the future. So […]

Read More