|
![]() |
Property | Value |
Name | OLE_DEST Load Verification table ZipCounty |
Description | OLE DB Destination |
Up Stream Components | |
Down Stream Components | none |
ID | 1745 |
Component Class ID | {5A0B62E8-D91D-49F5-94A5-7BE58DE508F0} |
Contact Info | OLE DB Destination;Microsoft Corporation; Microsoft SqlServer v10; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;4 |
Identification String | component "OLE_DEST Load Verification table ZipCounty" (1745) |
Is Default Locale | True |
Pipeline Version | 0 |
Uses Dispositions | True |
Validate External Metadata | True |
Version | 4 |
Name | Connection Manager | Description |
OleDbConnection |
Name | Value |
AccessMode |
3 |
AlwaysUseDefaultCodePage |
False |
CommandTimeout |
0 |
DefaultCodePage |
1252 |
FastLoadKeepIdentity |
False |
FastLoadKeepNulls |
False |
FastLoadMaxInsertCommitSize |
2147483647 |
FastLoadOptions |
TABLOCK,CHECK_CONSTRAINTS |
OpenRowset |
[dbo].[Verify_dbo_DimZipCounty] |
OpenRowsetVariable |
|
SqlCommand |
Name | ID | LineageID |
City |
2255 |
2233 |
County |
2254 |
2230 |
CountyFIPS |
2253 |
2227 |
RowIsDuplicate |
2045 |
552 |
RowIsSelected |
2046 |
555 |
State |
2256 |
2236 |
ZipCode |
2252 |
2224 |
ZipCodeAK |
2251 |
2221 |
Name | ID | LineageID |
ErrorCode |
1760 |
1760 |
ErrorColumn |
1761 |
1761 |
Powered by BI Documenter |