Integration service entry (experiment 9) logging and email notification

By default, all SSIS tasks can trigger events and are captured by the execution results tab. You can also selectively capture some events and record them to SSIS logs. To check whether the task is successfully executed

By default, all SSIS tasks can trigger events and are captured by the execution results tab. You can also selectively capture some events and record them to SSIS logs. To check whether the task is successfully executed

By default, all SSIS tasks can trigger events and are captured by the execution results tab. You can also selectively capture some events and record them to SSIS logs.

To know whether the task is successfully executed, you can add a "send mail task" to send a notification email to the specified recipient.

I. Use Logging

1. Enable Logging

Select "SSIS" from the main menu, and select "logging" from the drop-down menu ".

2. Add a log provider

3. Select events

In the left-side container pane, select all containers. Check the logs used by the container. You can configure multiple logs for different containers.

Select the events recorded for the container.

4. Enable debugging

5. view log records

6. Stop Logging

Because the logging function is bound to the corresponding container, you only need to remove the check box before the corresponding container to stop logging.

Ii. Email Notification

1. Add "send mail task"

Drag the send mail task icon from the SSIS toolbox to the control flow pane.

2. Configure the SMTP Connection Manager

Right-click the send mail task icon and choose Edit from the context menu ". Alternatively, double-click "send mail task ".

Create an SMTP connection.

3. Establish a connection

Connect the output of "delete file" and "copy file" to "send mail task ".

Select the connection arrow from "Delete Connection to" send mail task ", Press Ctrl, and select the connection arrow from" copy file "to" send mail task, right-click one of the arrows and select "properties" (or press F4 or Alter + Enter ). Change the Value to "Failure ". In this way, only when any of the "delete file" and "copy file" tasks fails, the "send mail task" will be executed again ".

4. Modify priority constraints

Select any one of the arrows connecting to the send mail task, right-click and select Edit (or double-click ). Change the priority constraint to "logical or ".

5. Add comments

Right-click the "send mail task" and select "add annotation ".

6. Enable debugging

Before debugging, delete the Export folder under C: \ LabFiles. Enable debugging.

In the progress pane, you can see that an error is reported during debugging. The error message is "invalid directory name ".

7. Stop debugging

Stop debugging.

In the C: \ LabFiles folder, create a folder named Export.

This article is from the "MSSQL we have Chased Together" blog and is not reposted!