Logging or Log file creation

      Using SSIS Log file, we can see the package execution details (Success or failure). Using this package execution details we can find the failure point and reason for failure (if any failure is occurred during package execution).

Creating Log file:
      In the below example i am going to create loge file, the file format is text file.

• Open the required SSIS Package.
• Right click on the work pain and select "Logging" option.

• "Configure SSIS Logs:" window will open.
• Right side top corner of the window, we can find  a check box with the package name.Select that check box.

 

•  "Provider type:": From the "Provider type" drop down list select "SSIS log provider for text file" option.

• After that click on "Add" Button. This information will add into the container with a check box. Select the check box.

•  Click on "Configuration" then the drop down list will open. Select "New Connection" option.

•  "File Connection Manager Editor" window will open. Select "Usage type" as "Create file" from the drop down list. Use "Browse" button and give file path and name of the file.

•  Click on "OK" Button.

• After that we need to switch from "Providers and Log" tab to "Details" tab. So click on "Details" tab, highlighted on the above screen.

• In the above screen we can see the list of events with check box's. We need to select required events. Most frequently used events are "OnError, OnPreExecute and OnPostExecute".

•  Click on "OK" Button.
• Run the package. We can find the log file in the given path.