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.

Do it as an Execute SQL task after the data flow - ie, on the Control Flow tab.

John Marsh (7/12/2009)

---

Hello,

There is probably a more elegant solution but as a workaround you could edit the Mappings to the Destination Table, to ignore the first and last Input Columns.

Regards,

John...

By "achieve", do you mean how do you unpack it? Sounds like a derived column to me. What's the unpacking algorithm?

Sure thing. Edit the Foreach container, click on Collection, select Expressions and set the Directory and Filespec properties to retrieve the contents of your variables.