HRESULT: 0xC0202022 An error occurred due to no connection. A connection is required when requesting metadata.



PROBLEMIf you are using Sybase as a OLEDB Source the list of tables can appear in the "Name of the Table or the View" drop down on the OLE DB Srouce Editor even if SSIS is in "offline". Once you select a table, then try to view the columns you get the following error:


Error at Data Flow Task [OLE DB Destination [1]]: An error occurred due to no connection. A connection is required when requesting metadata.


(Microsoft Visual Studio)


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


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


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


Program Location:


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


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


at Microsoft.DataTransformationServices.DataFlowUI.DataFlowAdapterUI.connectionPage_SaveConnectionAttributes(Object sender, ConnectionAttributesEventArgs args)


RESOLUTION: On the tool bar select SSIS, then clear "Work Offline".


http://blogs.msdn.com/photos/chrissk/images/628270/original.aspx


Comments (0)

Skip to main content