235k views
5 votes
What is logging in SSIS? How many types of logging available in SSIS? Which one have you used?

User Icky
by
8.2k points

1 Answer

3 votes

Final answer:

Logging in SSIS refers to capturing and recording execution information. There are three types of logging available: Text File, SQL Server, and Windows Event Log. SQL Server logging is useful for querying and analysis.

Step-by-step explanation:

In SSIS, logging refers to the process of capturing and recording information about the execution of a package or task. It helps in troubleshooting and performance tuning of SSIS packages.

There are three types of logging available in SSIS:

  1. Text File: Logs the information in a text file.
  2. SQL Server: Logs the information in a SQL Server database.
  3. Windows Event Log: Logs the information in the Windows Event Log.

I have personally used the SQL Server logging option, as it allows for easy querying and analysis of the logged information.

User Htbasaran
by
8.1k points

Related questions

asked Feb 14, 2024 177k views
Rishit asked Feb 14, 2024
by Rishit
7.9k points
1 answer
3 votes
177k views