Informix to SQL 2005

• mohairfan

  Grasshopper

  Points: 12

  More actions

  March 12, 2009 at 5:33 am

  #128956

  hi,

  I'm new to SQL. I have prob.

  I want to integrate the Informix IDS Database to SQL.

  I'm using OpenLink ODBC Bridge to connect.

  When i tried the Integration in SQL 2000 using DTS Package, it's working fine. But not in SQL 2005.

  When I try to integrate in SQL 2005, I'm getting the below error,

  ===================================

  Error at Data Flow Task [OLE DB Source [66]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E37.

  Error at Data Flow Task [OLE DB Source [66]]: Opening a rowset for ""dadmin"."teller"" failed. Check that the object exists in the database.

  (Microsoft Visual Studio)

  ===================================

  Exception from HRESULT: 0xC02020E8 (Microsoft.SqlServer.DTSPipelineWrap)

  ------------------------------

  Program Location:

  at Microsoft.SqlServer.Dts.Pipeline.Wrapper.CManagedComponentWrapperClass.ReinitializeMetaData()

  at Microsoft.DataTransformationServices.DataFlowUI.DataFlowComponentUI.ReinitializeMetadata()

  at Microsoft.DataTransformationServices.DataFlowUI.DataFlowAdapterUI.SaveConnectionPage(ConnectionAttributesEventArgs args)

  Thanks,

  Irfan

• steve block

  SSCertifiable

  Points: 7698

  More actions

  March 23, 2009 at 8:42 am

  #964468

  Did you create the DTS yourself or did someone do it for you? DTS is being replaced by SSIS in 2005. If you created it yourself, try re-creating with SSIS.

  Steve

• mohairfan

  Grasshopper

  Points: 12

  More actions

  March 23, 2009 at 6:25 pm

  #964916

  hi Steve,

  Yeah i got that, By using ADO Net i can able to integrate. SQL 2005 SP3 or SQL 2008 is working perfectly.

  Thanks,

  Irfan