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.