Package won't run on new server

We have a BIDS 2008 R2 that we are trying to run on a new server, but we are getting the error below.

The package seems to be complaining about a parameter not being passed to the Slowly Changing Wizard (see image). We can't find the parameter anywhere. This "child" package is being called by a parent package and we think the parent package may be trying to pass a value to the child using package variables.

The package runs fine on the legacy server.

Any idea how to track this down? 

Error: 0xC0202009 at Load DimPublicHolidays, StgDimPublicHolidays Slowly Changing Dimension [181]: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E5D.
An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 11.0"  Hresult: 0x80040E5D  Description: "Parameter name is unrecognized.".
Error: 0xC004701A at Load DimPublicHolidays, SSIS.Pipeline: component "StgDimPublicHolidays Slowly Changing Dimension 1" (181) failed the pre-execute phase and returned error code 0xC0202009.
Information: 0x40043008 at Load DimPublicHolidays, SSIS.Pipeline: Post Execute phase is beginning.

September 9th, 2015 11:58am

Hi Amir,

If the parent package is on the old machine, and the child on the new box this is the reason I trust as it is an un-usual setup.

If you cannot run both on the same computer then you would need to take a copy of this package, delete the SCD Task and then re-create as it seems to be a binary corruption case.

If that does not help then re-do the entire package.

Free Windows Admin Tool Kit Click here and download it now
September 9th, 2015 1:33pm

The packages are all on the same computer. 

The problems is that the same packages that run fine on the old server, won't run on the new server.

September 10th, 2015 3:22am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics