Post reply

SSIS package parameter display within script task?

  • September 3, 2015 at 5:05 am

    #320282

    we can see variable's value using script task such as

    MessageBox.Show(Dts.Variables["User::dateFrom"].Value.ToString());,

    is there a way to see package parameter's value?

    the above method didn't work for this:

    MessageBox.Show(Dts.Variables["$Package::dateFrom"].Value.ToString());

    can anyone help?

    thanks

  • September 3, 2015 at 5:23 am

    #1824241

    Message boxes are fine when you're running the package interactively, but what if you forget to take them out and then wonder why the package fails when you schedule it? I strongly recommend that you write the variable value out to a text file or database table instead of displaying it on screen.

    John

Viewing 2 posts - 1 through 1 (of 1 total)

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