July 20, 2009 at 12:46 am
Hi,
In my SSIS package i have seq container and one script task. In the script task I want to verify whether the file is exist or not.
In the script designer while I'm writing script as mentioned below.
Dim myVariable As Variable
Dts.VariableDispenser.LockOneForWrite("FileFound", myVariable)
I'm getting below error, plz guide me.
Vlaue of type 'Microsoft.SqlServer.Dts.Runtime.Variable' can not be converted to
'Microsoft.SqlServer.Dts.Runtime.Variables'.
Thanks in advance,
Sridhar.
July 20, 2009 at 7:34 pm
It looks like your code sample is incomplete. However, I suspect that you're missing a .Value property when you reference the variables elsewhere in the code.
See the following URL for a syntax reference: http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.variabledispenser.lockoneforwrite.aspx
Tim Mitchell, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply