ssis

Using Variables in ssis Script Component
I've found a technique to efficiently exchange information between a script component and the host ssis package. I always use package level variables as I have not seen nor heard of any reason to use component level variables. I don't use the readonly/writeonly variables in the script task editor. Instead I use the following VB code: Dts.VariableDispenser.LockForRead("User::sales_file") Dts.VariableDispenser.LockForWrite("User::ftp_sales") The above code locks the sales_file� variable for