Home Forums Data Warehousing Integration Services SSIS2012 - Package parameters - Error: Accessing variable RE: SSIS2012 - Package parameters - Error: Accessing variable

  • December 5, 2016 at 5:42 pm

    #1916130

    Brandon Groom (12/5/2016)

    I had this error also and it turned out to be a source code promotion merge issue with the project file. After the merge, the parameter ID in the project file no longer matched the ID in the package file.

    Project XML snippet:

    <SSIS:Property SSIS:Name="ID">

    <SSIS:Parameters>

    <SSIS:Parameter SSIS:Name="parameter_name">

    <SSIS:Properties>

    <SSIS:Property SSIS:Name="ID">{XXXX-XXX...}</SSIS:Property>

    Package XML snippet:

    <DTS:PackageParameter

    DTS:DTSID="{XXXX-XXX...}"

    XXXX-XXX... values should match.

    I'll bet that was a fun one to track down!

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.