Post reply

Script component with package variables

  • May 22, 2009 at 8:10 am

    #134369

    Hi all,

    i can t store values in package variable in Script component.

    i implement the following

    i have a flat file source and i use multi task component,

    i split the data by Derived Column then i use use script component

    in that i m calling stored procedure, it will check data is exists in Database

    then return primary key as output parameter .

    but i cant assign this value to the package level variable ?

    i got error :The collection of variables locked for read and write access is not available outside of PostExecute.

    then i used the PostExecute() method , even i got the ssame error

    how to resolve that ?

    Public Overrides Sub PostExecute()

    MyBase.PostExecute()

    Me.Variables.ClaimId = CType(sqlParamClaimID.Value, Int32)

    Me.Variables.MemberId = CType(sqlParamMemberID.Value, Int32)

    Me.Variables.ProviderId = CType(sqlParamProviderId.Value, Int32)

    End Sub

  • May 22, 2009 at 1:07 pm

    #999124

    You need to remove the variables from the ReadWrite variables list and use the Variable Dispenser to unlock the variable for write within the script component.

    Check out this link.

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

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

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