Post reply

Using variables set at C# code to be used at SSIS package end.

  • October 14, 2009 at 12:50 pm

    #216359

    Hi All

    My SSIS package is executed from C# code.

    I have a variable that I want passed from the C# code to the package. I know how to set it at the C# code end i.e.

    ssisPackage.Variables["PaidWeight"].Value = '5'

    but what I dont know is, how do i use this at the SSIS package end in a ExecuteSQL task. Do i create a package wide variable? Pls help.

    Thank you

    Gomz

    conningtower@gmail.com

  • October 24, 2009 at 10:12 am

    #1070390

    Did you not understand what was posted at:

    http://www.sqlservercentral.com/Forums/Topic803085-148-1.aspx

    CEWII

  • October 24, 2009 at 10:41 am

    #1070393

    Hi elliot

    I m sorry for not getting back , the problem i faced was i needed to get the package variable into a ole db source so that I can use it to create my output and send it to a flat file destination. I dont know how i could do that when i use a execute sql task like the way u had suggested.

    Thank you

    Gomz

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

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