|
|
||||||
|
|
||||||
DataFlow Screenshot
Properties
| Property | Value |
| Name | Load CSV File into ZIPCodes |
| Description | Data Flow Task |
| Precedence Executables | none |
| Contrained Executables | none |
| ID | a6d148e4-c379-431d-879c-088c42c5c911 |
| BLOB Temp Storage Path | |
| Buffer Temp Storage Path | |
| Default Buffer Max Rows | 10000 |
| Default Buffer Size | 10485760 |
| Run In Optimized Mode | True |
| Locale ID | English (United States) |
| Logging Mode | UseParentSetting |
| Forced Execution Value | 0 |
| Force Execution Value | False |
| Delay Validation | False |
| Disable | False |
| Disable Event Handlers | False |
| Fail Package On Failure | False |
| Fail Parent On Failure | False |
| Maximum Error Count | 1 |
| Isolation Level | Serializable |
| Suspend Required | False |
| Transaction Option | Supported |
Components
| Name | Type | Description |
12 |
Data Conversion |
|
10 |
OLE DB Destination |
|
9 |
Flat File Source |
Column Mappings
| Component | Input Column | Destination Column | |
DC_Assign Correct Data Types |
|||
Data Conversion Input |
|||
AreaCode [?] |
 |
AreaCode |
|
CarrierRouteRateSortation [?] |
|
CarrierRouteRateSortation |
|
City [?] |
|
City |
|
CityAliasAbbreviation [?] |
|
CityAliasAbbreviation |
|
CityAliasCode [?] |
|
CityAliasCode |
|
CityAliasMixedCase [?] |
|
CityAliasMixedCase |
|
CityAliasName [?] |
|
CityAliasName |
|
CityDeliveryIndicator [?] |
|
CityDeliveryIndicator |
|
CityMixedCase [?] |
|
CityMixedCase |
|
CityStateKey [?] |
|
CityStateKey |
|
CityType [?] |
|
CityType |
|
ClassificationCode [?] |
|
ClassificationCode |
|
County [?] |
|
County |
|
CountyANSI [?] |
|
CountyANSI |
|
CountyFIPS [?] |
|
CountyFIPS |
|
DayLightSaving [?] |
|
DayLightSaving |
|
Elevation [?] |
|
Elevation |
|
FacilityCode [?] |
|
FacilityCode |
|
FinanceNumber [?] |
|
FinanceNumber |
|
Latitude [?] |
|
Latitude |
|
Longitude [?] |
|
Longitude |
|
MultiCounty [?] |
|
MultiCounty |
|
PreferredLastLineKey [?] |
|
PreferredLastLineKey |
|
PrimaryRecord [?] |
|
PrimaryRecord |
|
State [?] |
|
State |
|
StateANSI [?] |
|
StateANSI |
|
StateFIPS [?] |
|
StateFIPS |
|
TimeZone [?] |
|
TimeZone |
|
UniqueZIPName [?] |
|
UniqueZIPName |
|
ZipCode [?] |
|
ZipCode |
|
DST_Load ZIPCodes |
|||
Destination Input |
|||
AreaCode [?] |
|
AreaCode |
|
CarrierRouteRateSortation [?] |
|
CarrierRouteRateSortation |
|
City [?] |
|
City |
|
CityAliasAbbreviation [?] |
|
CityAliasAbbreviation |
|
CityAliasCode [?] |
|
CityAliasCode |
|
CityAliasMixedCase [?] |
|
CityAliasMixedCase |
|
CityAliasName [?] |
|
CityAliasName |
|
CityDeliveryIndicator [?] |
|
CityDeliveryIndicator |
|
CityMixedCase [?] |
|
CityMixedCase |
|
CityStateKey [?] |
|
CityStateKey |
|
CityType [?] |
|
CityType |
|
ClassificationCode [?] |
|
ClassificationCode |
|
County [?] |
|
County |
|
CountyANSI [?] |
|
CountyANSI |
|
CountyFIPS [?] |
|
CountyFIPS |
|
DayLightSaving [?] |
|
DayLightSaving |
|
Elevation [?] |
|
Elevation |
|
FacilityCode [?] |
|
FacilityCode |
|
FinanceNumber [?] |
|
FinanceNumber |
|
Latitude [?] |
|
Latitude |
|
Longitude [?] |
|
Longitude |
|
MultiCounty [?] |
|
MultiCounty |
|
PreferredLastLineKey [?] |
|
PreferredLastLineKey |
|
PrimaryRecord [?] |
|
PrimaryRecord |
|
State [?] |
|
State |
|
StateANSI [?] |
|
StateANSI |
|
StateFIPS [?] |
|
StateFIPS |
|
TimeZone [?] |
|
TimeZone |
|
UniqueZIPName [?] |
|
UniqueZIPName |
|
ZipCode [?] |
|
ZipCode |
|
Variables
| Name | Value | Description |
| Powered by BI Documenter |
