One of the easier ways of handling this is to create a package level boolean variable set to False.

In your event handler, check if the variable is true - if...

Because of the sequence number (and assuming it is correct that I can assume it positions the expected column values) you can do this with sub-queries. I used CTE's...

I suggest you find a VB.Net forum and post there.

This is not the correct forum.

I will add - you should not be re-opening and closing the destination connection in your...

You could add a calculated field to a table to have two fields in the table with the same data and two different names. Or, you could create a...

It will row version everything. It needs to keep the original copy of anything being used by any transaction because the database engine does not know if you will...

You may have a table name that needs square brackets.

[font="Courier New"]DECLARE @Database VARCHAR(100)

DECLARE @Table VARCHAR(100)

DECLARE @cmd NVARCHAR(300)

DECLARE @fillfactor INT

SET @fillfactor = 70

SET @Database = ‘TestOnly’

SET @cmd = ‘DECLARE TableCursor...

Yup - size does matter.

BLOB fields cause this problem a lot.

I assume the sync table is used by just an insert, a single query, and a delete (basically a queue).

It should be pretty easy to tune this because the activity...

Without knowing exactly what you are doing this is a bit hard, but I think you have declared your variable at the wrong scope.

Add a sequence container to the loop...

A check constraint will work, but you take a performance hit so be careful.

I seem to remember there being some kind of 3rd party product for doing this so you...

You should look at the feature lists for the editions of SQL to make sure you do not need standard edition features.

Per-processor licensing seems a lot for you. Per-user...

Are you accessing the oracle server with OPENQUERY or by using a 4 part name?

Try both - this may clue you into the issue. If openquery works but 4...

There are probably a bunch of scripts for doing this, but I wanted to see if I could get something with just a few lines of code. I added...

You say you are locked into 32 bit because of some delivered apps, but you may want to look into the feasibility of 64 bit.

If you can move the other...

Check the Oracle installs and make sure your TNSNames configuration is the same.

Also, since you copied a virtual machine, make sure there is not a DNS conflict of some sort....