Home Forums Data Warehousing Integration Services how to read contents of flat file in SSIS and extract from it just one value for use in variable? RE: how to read contents of flat file in SSIS and extract from it just one value for use in variable?

  • KoldCoffee (1/28/2015)


    Cannot apply indexing with [] to an expression type Microsoft. SQLServer.Dts.Runtime.Variables

    I've never seen that before, Doing some research it seems to be an issue if you have multiple versions of SSIS installed:

    https://connect.microsoft.com/SQLServer/feedback/details/744390/ssis-any-pre-2012-error-cannot-apply-indexing-with-to-an-expression-of-type-microsoft-sqlserver-dts-runtime-variables

    http://support.microsoft.com/kb/938608/en-us/

    http://stackoverflow.com/questions/24409771/cannot-apply-indexing-with-to-an-expression-of-type