Archive: SSIS
-
Jun 29, 2010
1 CommentSSIS FAQ – Part 2
Event handlers in SSIS? Events of various types occur one after another from the time you start to execute a package till the time it completes successfully or otherwise. The OnError event, which is raised when an error occurs, is the default event in SSIS. In addition to the package, various components such as for loop,...
-
Jun 08, 2010
1 CommentSSIS FAQ – Part 1
What is SSIS? SSIS stands for SQL Server Integration Services. This is an ETL (Extract, Transform, Load) tool. This is a new Data transformation standard for SQL Server 2005 and has replaced the old SQL Server data transformation services. This has many features compared to DTS. This is well designed for BI (Business Intelligence) purpose. What is...