I am trying to convert a package from 2005 to 2008 and am running into some rpblems that seem to be related to synonym lookups. This worked fine in 2005 but for some reason is breaking in 2008, thanks for any assistance. Here is the error text:
===================================
Error at Update Existing Assets [Lookup Asset to Make sure [90]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E14 Description: "Deferred prepare could not be completed.". An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Unspecified error".
Error at Update Existing Assets [Lookup Asset to Make sure [90]]: OLE DB error occurred while loading column metadata. Check SQLCommand and SqlCommandParam properties.
Error at Update Existing Assets [Lookup Asset to Make sure [90]]: The call to Lookup transform method, ReinitializeMetadata, failed.
(Microsoft Visual Studio)
===================================
Exception from HRESULT: 0xC02090F0 (Microsoft.SqlServer.DTSPipelineWrap)
Program Location:
at Microsoft.SqlServer.Dts.Pipeline.Wrapper.CManagedComponentWrapperClass.ReinitializeMetaData() at Microsoft.DataTransformationServices.DataFlowUI.DataFlowComponentUI.ReinitializeMetadata() at Microsoft.DataTransformationServices.DataFlowUI.LookupTransformUI.connPage_SetOleDbConnectionInfo(Object sender, LkConnectionInfoEventArgs args)
Thanks, Andy