Thank you Grant for your reply.

Grant,

I have EF Core interceptor created for my app. I want to calculate such hash value for the query being executeted. Next I want to match this hash to the...

I think I know the solution of my problem.

Because messages guaranteed by those contracts has WELL_FORMED_XML validation so is up to developer imagination what they can deliver to receiver....

Those not queues but...

There is no information about those contracts:

http://schemas.microsoft.com/SQL/ServiceBroker/ServiceEcho

http://schemas.microsoft.com/SQL/ServiceBroker/ServiceDiagnostic.

First contract implements "ping" to the service broker instance (I think). The second contract implements message Query sent by initiator...

Which way your package was deployed on the production server?

keywestfl9 (1/23/2008)

---

i want to append rows from excel file to sql server table

Table has a identity column.

How do i achieve it thru SSIS or thru DTSWizard? I get error...

Here it is:

Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)

'

' Add your code here

...

Give me more information about job error.

Try to read this thread:

http://www.sqlservercentral.com/Forums/Topic423399-148-1.aspx

Read this thread:

http://www.sqlservercentral.com/Forums/Topic423399-148-1.aspx

What kind an error? Give me more information (error message).

Is logging enabled for this package?

Is onError enabled for this container?

Yes, but SynchronusOutputId property for given output of this task should be set to none. Then counts of input and output rows can differ.

During designing time under BIDS of course (and testing time...