Checkpoint configuration helps us to resume the last task in the package. i.e., if the multiple tasks are there in a package. If there is any failure in any task it stores the fail task point in the checkpoint file once we restart the package the checkpoint helps to start from the last point specified in the checkpoint file. Once the package is succeeded it deletes the checkpoints.
If you would like to Enrich your career with a certified professional, then visit Mindmajix - A Global online training platform: “Checkpoint Certification Training” Course. This course will help you to achieve excellence in this domain.
It uses various log providers to take the log information at a particular “event”. The SSIS log providers are:
SSIS log provider for windows event log
SSIS log provider for text files
SSIS log provider for XML files
SSIS log provider for SQL server
SSIS log provider for SQL server profiler
In real-time, this log information is used to perform the below task.
This log information is different from progress tab information because
SSIS menu → logging → select package (or) task in the left-hand side panel →Right-hand side
Provider type: SQL server provider for text filesà
Implementing action at a particular event is called event handling.
Eg of events:
Event handling Eg:
1) Sending an email after successful execution of the package.
Go to the event handler tab
Select Executable ⁄ Package Eventhandler ⁄ on post executes
Drag and drop send mail task, do the configuration.
Run the package and observe the result
2) Delete the before loading the data into the GRP LOAD table
Package Configuration is helpful while migrating or moving the package from one environment to another environment.
Development to testing
Testing to production….etc.
There are many ways we create configuration:
Note: In real-time, the frequently used configuration is “XML and SQL server database”. As XML is an industrial standard with platform-independent, most organizations are perfecting it.
List of Related Microsoft Certification Courses:
|SCCM||SQL Server DBA|
|Team Foundation Server||BizTalk Server Administrator|
Ravindra Savaram is a Content Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.