Home Dashboard Directory Help

SSIS (any pre 2012) - Error Cannot apply indexing with [] to an expression of type 'Microsoft.SqlServer.Dts.Runtime.Variables' by ArthurZ



Sign in
to vote
Type: Bug
ID: 744390
Opened: 5/27/2012 7:36:19 PM
Access Restriction: Public
User(s) can reproduce this bug


Unable to create scripts in Script Task of SSIS after installing SSIS 2012.

Upon opening the Script Editor and adding code to get a variable content I get error:
Error    1    Cannot apply indexing with [] to an expression of type 'Microsoft.SqlServer.Dts.Runtime.Variables'

And indeed, I can see the reference to Microsoft.SqlServer.ManagedDTS marked with a yellow icon.
This happened after a side by side complete installation of SQL Server 2012 (already have SQL Server 2008 and 2008 R2 full installs).
Sign in to post a comment.
Posted by CraigIW2 on 5/14/2014 at 5:31 AM
Stated workaround does not work for me as the files do not exist. I have SQL 2008 Developer edition installed. All was fine with BIDS until I installed SQL 2014 Management Studio. Can confirm that script runs, but intellisense gives warning as per title and Microsoft.SqlServer.ManagedDts reference has a yellow warning triangle.
Posted by Dmitriy Gavrikov on 5/7/2013 at 9:16 PM
Thank you, what the doctor ordered. SQL Server 2008 R2 SP2
Posted by Sudeep Raj on 7/16/2012 at 11:28 AM
@Chema_che thanks for pointing out the workaround. It worked like it should :)
Posted by Microsoft on 7/3/2012 at 1:37 AM
Hi Arthur,
Thanks for your feedback. We find it builds successfully even though it throws intellisense error in the first compiling. Please see the analysis and workaround here: http://support.microsoft.com/kb/938608/en-us
We're actively looking at it.
Posted by Chema_che on 6/12/2012 at 4:29 AM
This may help
Sign in to post a workaround.
Posted by Chema_che on 6/12/2012 at 4:27 AM
I solve the problem moving the file "Microsoft.SQLServer.ManagedDTS.dll" located in the path:
"C:\Program Files (x86)\Microsoft SQL Server\110\SDK\Assemblies" to a backup folder, then the bids take the reference from the path C:\Windows\assembly\GAC_MSIL\Microsoft.SqlServer.ManagedDTS\\Microsoft.SqlServer.ManagedDTS.dll

My Windows 7 is 64 Bit Version.