Post reply

Accessing user-defined variables inside Data Flow

  • March 11, 2010 at 2:21 pm

    #137879

    Hello,

    I am reading a CSV flat file inside a data flow task. With the output from that file, I want to add a value stored in a user-defined variable. I have to use a stored procedure to do that since the SP is doing some other stuff too, and I cannot insert all output in the required table by using the table's or a view's name.

    So, here is the scenario. I am getting 9 values from the flat file. The tenth is the user-defined variable (scope is package). Now I want to call a stored procedure and insert one line at a time from the flat file, along with the value of user-defined variable.

    Please help.

    Thanks.

  • March 12, 2010 at 8:24 am

    #1132739

    You can probably add the variable using a Derived Column task and the OLE DB Command task. If you are moving a lot of data this is going to be a REALLY inefficient method.

    CEWII

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

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