I agree with your findings - it's as if the insert happens and then rolls back, using up a number in the process.

I do not know whether that behaviour can...

Assume that you have a Boolean variable called Test. Here is how you would set it to True using a Script Task.

1) Create a Script Task.

2) Add 'User::Test' (no quotes)...

This should...

Here is how I would do it, I think.

1. Ensure that there is a string variable defined (eg SourceFile) which contains the filepath of the source data (eg C:\Ryan\Output_.xls)

2. Create...

Should not affect that - I assume you are talking about an IDENTITY primary key?

There must be something else happening ... can you post a bit more detail?

Excellent! My pleasure.

You might find this link interesting - goes deeper than you wanted, but should still be informative for you ...

http://blogs.conchango.com/jamiethomson/archive/2006/09/12/SSIS_3A00_-Checking-if-a-row-exists-and-if-it-does_2C00_-has-it-changed.aspx

Phil

There is another (possibly faster) way of doing this which might help in your case.

Try creating a unique index on RealEstateID in your destination table.

CREATE UNIQUE NONCLUSTERED INDEX [IX_RealEstateID]...

You have not explained your problem very clearly.

Can you describe the requirement and post some sample data showing what's it's like as source and how you would like it to...

Your idea number 2 sounds like it should work OK, except you'll need a multicast before you send the output to the log table destination: one output to the log...

Nice work and no problem - I don't think I helped much. By the sound of it, you already know way more than I do anyway! Glad that you tracked...

Two derived columns seems like the easiest way to me.

If you need help writing the expressions, post back. But give it a go, it's not too difficult.

The error message specifically mentions SQL Native Client - making me wonder whether you tried to connect to Oracle using the wrong provider ...

Can you use SQL Native Client to connect to Oracle?

Actually it's more elegant than that.

Create a Foreach container with 'item' enumeration and add the folders' names as items in column 0.

Then map a variable to this column.

Then plonk your...

Not that similar! Two file system copy tasks would seem to meet your requirement.