Print Statements

• water490

  Ten Centuries

  Points: 1076

  More actions

  February 12, 2022 at 5:30 am

  #3982683

  Hi

  I am creating SSIS pacakges to automate data collection.  I want to print out statements to the console.  I tried below but they are not working.  Nothing shows up in the output window in Visual Studio 2019.   How exactly do I get them to work?

  System.Diagnostics.Debug.WriteLine("debug");
  Console.WriteLine("console");

  Thank you

• Jeffrey Williams

  SSC Guru

  Points: 90348

  More actions

  February 12, 2022 at 4:02 pm

  #3982813

  https://docs.microsoft.com/en-us/sql/integration-services/extending-packages-scripting/task/raising-events-in-the-script-task?view=sql-server-ver15

   

  Jeffrey Williams
  “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

  ― Charles R. Swindoll

  How to post questions to get better answers faster
  Managing Transaction Logs

• Phil Parkin

  SSC Guru

  Points: 247158

  More actions

  February 12, 2022 at 6:38 pm

  #3982838

  As SSIS is a server-based technology, outputting messages to a console is largely pointless, as there will usually be no one there to see them. Write your messages to a database table, a file or use one of the methods suggested in the link provided by Jeffrey Williams.

  ---