What SSIS Task can I use in an event handler that will log to a text file - How To RRS feed

  • Question

  • Hi

    I am creating a SSIS package that will run every 3 minutes, my log files are created daily using date as its filename. Now, I would like to use event handlers such as OnError to log a message when it failed to this text file created. 

    The thing, I am not sure if I should be using Script Task ( open connection to the log file..), or Execute SQL Task, write a output command to the text file or is there a specific task that I can use in SSIS that I am missing out.

    Execute SQL task makes more sense if I am logging to a table inside SQL. Script task would definitely do the work , but is this the right approach. Is there some other task that I can use.

    A beginner seeking help. 

    Friday, June 5, 2020 7:21 AM

All replies