Honeywell OLE DB Source Exception - RPC_E_SERVERFAULT

Hello,

Visual Studio is throwing an exception to an OLE DB source. The provider is Honeywell's and it allows access to its PHD system. The SQL command is:

Code Snippet

SELECT TAGNAME, TAGNO, TIMESTAMP, VALUE, CONF, UNITS
FROM IP_PHD_RAW
WHERE (TAGNAME IN ('T701.SPAVAILABILITY_DAY.BC', 'T200.F2AVAILABILITY_DAY.BC')) AND TIMESTAMP > '2006-04-01'

You can view the data Using Query Build successful return. However, Visual Studio throws this exception for everything else:

Code Snippet

The server threw an exception. (Exception from HRESULT: 0x80010105 (RPC_E_SERVERFAULT)) (Microsoft Visual Studio)

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)

If you know the cause of the problem or how to access Honeywell data in PHD, I would be appreciative for your assistance.

Visual Studio? Are your building a SSIS package? What have you done? What connection type?

Talk to Honeywell and find out what scenarios their provider is supported under, should it work with SSIS?

|||

Darren,

Using Professional Edition of visual studio to build the SSIS package and the OLE DB provider is from Honeywell. I'm able to view the data using the Query Builder with a SQL command. However, visual studio crashes when you select to see the Columns on the return trip to the OLE DB Source Editor.

I’m open to any suggestions

Thanks for taking an interest,

Ian

|||

Darren,

I think the Honeywell PHD is an OPC server (OLE for Process Control). It may be that Query Tool you are using mimics an OPC client enough for Honeywell to respond but your application doesn't. Sorry to say, my experience accessing Honeywell data is with an "off the shelf" OPC Client, not one I've written myself. However, you may find enough information at the OPC Foundations web site (http://www.opcfoundation.org/) to aid you.

On another note, the Honeywell PHD does come with an Oracle database. It stores configuration information about the Honeywell data as well as information on how well your Honeywell system is running. It is accessible via OLE DB or ODBC. But you probably already know that.

Hope this helps some.

Maineac

PI System Administrator

|||

Hello,

The Honeywell provider is only a partial implementation of OLE. They believe that a schema needed be returned as the data source has only one table, or some obscure reason. I’m guessing that Intergraded Services visual programming nature relies on a schema and crashes with no is found. My question now is, can I create a Data Source without using the visual method, define a file holding the connection and column mapping and import that into Integration Services?

.i