Help > Tasks > Logging Task >
SSIS Logging Task
PreviousNext

SSIS Logging Task is very handy task to log audit messages anywhere in ssis package control flow.

Download SSIS PowerPack

Content

Step-By-Step

In this tutorial we will learn how to get values from tasks or components using ZS Logging Task. This tool can display the variable values in the SSIS output (ExecutionLog) in a MessageBox a file or a variable. In this example, we will show the variable values in the SSIS output.
  1. Firstly, You need to Download and Install SSIS ZappySys PowerPack.
  2. Once you finished first step, Open Visual Studio and Create New SSIS Package Project.
  3. In visual studio just Drag and Drop ZS Logging Task in design panel.
    SSIS Logging Task - Drag and Drop
  4. Double click on ZS Logging Task to configure it.
  5. Set Log Mode to ExecutionLog and use the following text.
    Hello from {{System::PackageName}}. 
    I started on {{System::StartTime,yyy-MM-dd hh:mm:ss tt}}
    
    SSIS Logging Task - Execution log option
  6. Click on OK button to save Logging Task configure setting UI.
  7. Finally, run the packages and check the output (ExecutionLog). If you cannot see the output, go to View in the menu and Select Output.
    SSIS Logging Task - Execution log message with variable replacement at runtime

Properties

Property Name Description
Log Mode Determines how you want to log message. Can be ExecutionLog, MessageBox or File
Message Type Type of message. Informational, Warning or Error. Default is Informational. If you select MessageType=Error then package will return Failure status to parent.
Log File Path If you select LogMode=File then specify file path here
LogFile Append Append to log file
Prefix date/time Prefix date/time to log message in specified format for datetime (e.g. yyyyMMdd HH:mm:ss.fff tt)
Message Message you want to log. You may use variable placeholders anywhere in the message (e.g. {{System::PackageName}} )
LoggingMode LoggingMode determines how much information is logged during Package Execution. Set Logging mode to Debugging for maximum log.

Setting UI

SSIS Logging Task - Setting
SSIS Logging Task - Setting

See Also

Articles / Tutorials

Click here to see all articles for [SSIS Logging Task] category
How to read PayPal API data in SSIS

How to read PayPal API data in SSIS

Introduction In this article, we will see how to read PayPal API data in SSIS and load into SQL Server. This blog mainly focuses on SSIS approach but steps mentioned to call PayPal APIs can be useful for any developer regardless of which programming language or tool set you use. We will also see How to send […]


How to read Walmart API data in SSIS / ODBC

How to read Walmart API data in SSIS / ODBC

Introduction In this article, we will see how to read Walmart API data in SSIS and load into SQL Server. This blog mainly focuses on SSIS approach but steps mentioned to call Walmart APIs can be useful for any developer regardless of which programming language or toolset you use. Are you a Walmart.com Supplier or Marketplace […]


SSIS PGP Encryption / Decryption (Using FREE GPG Tool)

SSIS PGP Encryption / Decryption (Using FREE GPG Tool)

Introduction In this new article, we will show you how to perform PGP encryption using SSIS (encrypt / decrypt files using public / private key). Our previous article was about SFTP using our SFTP task for SSIS. Now we will show how to encrypt the information. Requirements First of all, you will need SSDT for Business Intelligence for […]


How to read and write data to HTML in SSIS

How to read and write data to HTML in SSIS

Introduction to read and write data to HTML in SSIS In this article, we will show how to send values from an SSIS Variable to an HTML file. We will use the SSIS Advanced File System Task to store the list of system files of a folder into a variable and then we will use […]


SSIS Base64 Encode Decode without Coding

SSIS Base64 Encode Decode without Coding

Introduction In this post you will learn how to use FREE SSIS Logging Task to perform ssis base64 encode decode and save to Variable or File  (i.e. convert Base64 Encoded value to plain text or encode plain text to base64) . You can also use many other format specifiers found here How to invoke Placeholder […]


5 Ways to Export JSON from SQL Server using SSIS

5 Ways to Export JSON from SQL Server using SSIS

Introduction SQL Server 2012 and all previous versions lacking native JSON support, same theory is true for their ETL Platform SSIS. If you are one of them who wants to export JSON from SQL Server or any other RDBMS like MySQL, Oracle then you can easily output complex JSON using any of the following components. Five ways of […]



Copyrights reserved. ZappySys LLC.