SSIS2012 - Package parameters - Error: Accessing variable

Question

SSIS2012 - Package parameters - Error: Accessing variable

Vince Poirier

SSC Eights!

Points: 932
More actions
October 25, 2016 at 1:06 pm

#400937

Hello,
I have a very strange situation.
I work with SSIS 2012 with SQL Server 2012 SP3.
I'm under Project Deployment Model.
I created a very simple package.
That package uses parameters.
Two of the package parameters are used in an OleDB Source as Parameters for a SQL Query:
SELECT Field1
FROM [Schema].[Table1]
where Param1 = ?
and Param2 = ?
The package works perfectly well on my computer and on some collegues' ones also.
But for an unknown reason, when we deployed it in Prod, one of the association was lost.
The association between first parameter and package param1 is correct but the second one seems to be lost.
Here's the error I got:
Error: Accessing Variable "{2CFF****-****-****-****-************}"
Failed with error code 0xC0010001
Any ideas?
Thanks,
Vince

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Brandon Groom SSC Journeyman Points: 77 More actions · Answer 1

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.

Phil Parkin SSC Guru Points: 246985 More actions · Answer 2

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!

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel