SSIS - how to prepare log

nononame2021 261 Reputation points
2021-11-26T03:50:37.163+00:00

i found that the SSIS componenet has a property "Logging Mode", if i want to log all the execution process including start and end process, how do i set for SSIS?
what is the using of "UseParentSetting" in logging mode?

how to log SSIS execution task and log the error message when there is failture.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Yitzhak Khabinsky 26,586 Reputation points
    2021-11-26T04:20:37.673+00:00

    Hi @nononame2021 ,

    You can ignore what you found. It is a backward compatibility setting.
    Current SSIS logging is a run-time configuration settings for the SSIS Catalog on a server, not during development.
    All logging events are automatically saved to the SSISDB database.

    Available logging levels:

    • None Logging is turned off. Only the package execution status is logged.
    • Basic All events are logged, except custom and diagnostic events. This is the default value.
    • RuntimeLineage Collects the data required to track lineage information in the data flow. You can parse this lineage information to map the lineage relationship between tasks. ISVs and developers can build custom lineage mapping tools with this information.
    • Performance Only performance statistics, and OnError and OnWarning events, are logged.
    • Verbose All events are logged, including custom and diagnostic events.

    Check it out here:

    0 comments No comments

  2. ZoeHui-MSFT 41,496 Reputation points
    2021-11-26T06:25:36.777+00:00

    Hi @nononame2021 ,

    SQL Server Integration Services includes log providers that you can use to implement logging in packages, containers, and tasks. With logging, you can capture run-time information about a package, helping you audit and troubleshoot a package every time it is run. For example, a log can capture the name of the operator who ran the package and the time the package began and finished.

    Frequently, the logging options of tasks and For Loop, Foreach Loop, and Sequence containers match those of the package or a parent container. In that case, you can configure them to inherit their logging options from their parent container. For example, in a For Loop container that includes an Execute SQL task, the Execute SQL task can use the logging options that are set on the For Loop container. To use the parent logging options, you set the LoggingMode property of the container to UseParentSetting.

    Details you may refer:
    integration-services-ssis-logging
    overview-of-ssis-package-logging

    Note: Microsoft Q&A enables the author of a question to accept one of the answers provided by other users. The accepted answer acknowledgement gives confidence to other community users that the person who had the problem confirmed the answer solved their problem, so it helps them to quickly identify the answer to their problem.

    Regards,

    Zoe


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.