Post reply

Urgent! Assigning a value to SSIS package variables

  • December 28, 2009 at 7:10 am

    #137759

    Hi,

    I am converting DTS to SSIS, in DTS there are 3 package global variables & dataflow task which is taking data from CSV file into table, our requirement is that we have to assign the value from the csv file to package variables which is passed to stored procedure as a parameter, in DTS they have used the following code

    DTSGlobalVariables("as_of_date").Value = Trim(DTSSource("Col001"))

    DTSGlobalVariables("file_type").Value = Trim(DTSSource("Col013"))

    DTSGlobalVariables("product_type").Value = "BBLN"

    In SSIS I have taken a Script component & wrote in following way

    Dts.Variables("as_of_date").Value = Trim(Col001)

    but it gives syntax error like blue underline in Dts

    Can any one help me that how to write this in SSIS or suggest any other way?

    Thanks,

  • December 29, 2009 at 3:14 am

    #1096953

    It's unclear from your question if need to assign a value to a variable in the control flow. Assuming you are, you may want to use the "Execute SQL" task, query the table and assign the results to the variables. I can give you a more detailed example, just let me know if this is your intention.

  • December 29, 2009 at 5:13 am

    #1096974

    Hi,

    Thanks for your reply!

    I got the solution, I have writen the code as below

    Me.ReadOnlyVariables("as_of_date").Value = Trim(Row.Column0)

    and set the ReadOnlyVariables property of Script component Task with variable name (as_of_date)

    Thanks

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

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