For the majority of enterprise integration scenarios, it is very desirable to have a package restart where it left off in the case of a failure. Being able to start where a particular failure happened, as opposed to from the beginning of package, could save hours of unnecessary rework.
SSIS provides this support through the implementation of checkpoints. When an SSIS task fails, the new checkpoint functionality allows you to restart the package, beginning from the point of failure.
To enable checkpoints for an SSIS package, follow these steps:
The checkpoint file will be used to save all completed tasks, package configurations, containers, system variables, and user-defined variable information. When the SSIS package runs successfully, it deletes the checkpoint file it originally created. If you select the Always option, the SSIS package will not execute unless the checkpoint file exists. If you select the IfExists option, the package will use the checkpoint file if a previous execution failed, but if the previous execution succeeded, it will execute as normal.
SQL Server 2008 Related Interview Questions
|SQL Server 2000 Interview Questions||MSBI Interview Questions|
|SQL Server 2008 Interview Questions||SQL Server 2005 Interview Questions|
|SSIS(SQL Server Integration Services) Interview Questions||SSRS(SQL Server Reporting Services) Interview Questions|
|Microsoft Entity Framework Interview Questions||LINQ Interview Questions|
|SQL Server Analysis Services (SSAS) Interview Questions||Sql Server Dba Interview Questions|
SQL Server 2008 Related Practice Tests
|SQL Server 2000 Practice Tests||MSBI Practice Tests|
|SQL Server 2008 Practice Tests||SQL Server 2005 Practice Tests|
|SSIS(SQL Server Integration Services) Practice Tests||SSRS(SQL Server Reporting Services) Practice Tests|
|Microsoft Entity Framework Practice Tests||LINQ Practice Tests|
Sql Server 2008 Tutorial
Sql Server 2008 Overview
Sql Server Installation And Configuration
Sql Server Encryption
Automation And Monitoring
Integrated Full-text Search
New Datatypes In Sql Server 2008
T-sql Enhancements For Developers
T-sql Enhancements For Dbas
Sql Server And Xml
Sql Server Xml And Xquery Support
Linq To Sql
All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.