SQL Server Performance

Variables in Script Task

Discussion in 'SQL Server 2005 Integration Services' started by ubear, Oct 27, 2006.

  1. ubear New Member

    I recieve the below error when I attempt to execute a Script Component in a Data Flow Task:

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

    This is the code I used:

    Imports System

    Imports System.Data

    Imports System.Math

    Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper

    Imports Microsoft.SqlServer.Dts.Runtime.Wrapper

    Public Class ScriptMain

    Inherits UserComponent

    Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)

    Output0Buffer.AddRow()

    Output0Buffer.BillerId = CType(ReadWriteVariables("CustId").Value, Int32)

    Output0Buffer.UserAccount = CType(Row.Column0, String)

    Output0Buffer.UserSubAccount = CType("001", String)

    Output0Buffer.PaymentAmount = CType(Row.Column1, Decimal)

    Output0Buffer.DueDate = CType(Row.Column2, String)

    Output0Buffer.EmailAddress = CType(Row.Column3, String)

    Output0Buffer.ImportDateTime = DateTime.Now

    Output0Buffer.FileName = CType(ReadWriteVariables("FileName").Value, String)

    Output0Buffer.FileCreationDate = CType(ReadWriteVariables("FileCreateDate").Value, String)

    End Sub

    End Class



    I use the variables "CustId,FileName,FileCreateDate" in the ReadWriteVariables collection. Any ideas would be appreciated as to how to get around this error.

Share This Page