Geek asks and answers

What is the difference between two retention identifiers at oledb destination

What is the difference between storing an identifier in the OLE DB Destination Editor and fast loading in an OLE DB listing?

+3
source share
2 answers

I assume you are talking about the difference between OLE DB Destination Editor

OLE DB Destination Editor

and corresponding property?

OLE DB Destination Properties

It is the same. The second image is what is serialized in XML from the object, and the first is a representation of these BIDS / SSDT properties. You can verify this by turning it on or off, and observing the same change will affect the other.

, SSIS , . SSIS .

+3

, . , A B, B , " ", B A.

(, B (1,1):

TableA ID   TableB keep identity off    TableB keep identity on
10                   1                              10
11                   2                              11
12                   3                              12
+6

More articles:


All Articles