Post reply

Showing messages while executing packages

  • October 30, 2007 at 7:43 am

    #179672

    Hi,

    I am executing a package using command line (dtexec). I want to display messages on the console while the package execute. Which component do I use?

    thanks.

  • October 30, 2007 at 9:23 am

    #746694

    You can use a script task - i.e.

    Imports System

    Imports System.Data

    Imports System.Math

    Imports Microsoft.SqlServer.Dts.Runtime

    Public Class ScriptMain

    System.Windows.Forms.MessageBox.Show("SOME MESSAGE HERE")

    System.Windows.Forms.MessageBox.Show(Dts.Variables("YourVariableHere").Value.ToString)

    Dts.TaskResult = Dts.Results.Success

    End Sub

    End Class

    Tommy

    Follow @sqlscribe

  • October 30, 2007 at 11:00 am

    #746764

    Message Box and command line ?

    Anyways i found an answer in a different forum : "sqlcmd"

  • October 30, 2007 at 11:21 am

    #746778

    message box = assuming of course your using it for debugging purposes. Not really sure why else you would need it 🙂

    Tommy

    Follow @sqlscribe

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply