Register
What is logging in SSIS? How many types of logging available in SSIS? Which one have you used?
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.0k points
Ask a Question
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.

9.4m questions

12.1m answers

Other Questions

A piston-cylinder device fitted with stops in the cylinder walls contains 2.1 kg of water initially at 150 kPa and 30 °C. Heat is transferred to the system until the final temperature reaches 250 °C. The
4. Which of the following is the first thing you should do when attempting to park? A. Securing the parking spot by standing in it B. Turning on your hazard lights C. Confirming the space can fit your
A water towers lowest point is 405 ft and the main line is 6 feet below the ground. The ground elevation is at 276 ft. The main line travels 2.9 miles. The pipe will travel through the following flanged
An activated sludge plant is being designed to handle a feed rate of 0.438 m3 /sec. The influent BOD concentration is 150 mg/L and the cell concentration (MLVSS) is 2,200 mg/L. If you wish to operate the
The bulk modulus of a fluid if it undergoes a 1% change in volume when subjected to a pressure change of 10,000 psi is (a) 0.01 psi (b) 0.001 psi (c) 0.00001 psi (d) 0.000001 psi (e) none of these
Link Copied!