Summary Table

Categories Total Count
PII 1
URL 5
DNS 1
EKL 0
IP 0
PORT 0
VsID 0
CF 0
AI 0
VPD 0
PL 0
Other 0

File Content

<?xml version="1.0"?>
<DTS:Executable xmlns:DTS="www.microsoft.com/SqlServer/Dts"
DTS:refId="Package"
DTS:CreationDate="8/21/2017 3:12:14 PM"
DTS:CreationName="Microsoft.Package"
DTS:CreatorComputerName="
DNS "
DTS:CreatorName="
PII "
DTS:DTSID="{CF3DD8B7-3CAE-4AA3-92AA-614F3452EFAF}"
DTS:ExecutableType="Microsoft.Package"
DTS:LastModifiedProductVersion="14.0.0800.90"
DTS:LocaleID="1033"
DTS:ObjectName="ChildADONetFlowPkgConsult"
DTS:PackageType="5"
DTS:VersionBuild="98"
DTS:VersionGUID="{4E035D53-8868-4B5E-A163-4851C801B12F}">
<DTS:Property
DTS:Name="PackageFormatVersion">8</DTS:Property>
<DTS:ConnectionManagers>
<DTS:ConnectionManager
DTS:refId="Package.ConnectionManagers[
URL .EPRS_Shadow]"
DTS:CreationName="OLEDB"
DTS:DTSID="{C36C046C-119A-42DF-B4BF-808D36A34544}"
DTS:ObjectName="
URL .EPRS_Shadow">
<DTS:ObjectData>
<DTS:ConnectionManager
DTS:ConnectionString="Data Source=
URL ;Initial Catalog=EPRS_Shadow;Provider=SQLNCLI11.1;Integrated Security=SSPI;Auto Translate=False;" />
</DTS:ObjectData>
</DTS:ConnectionManager>
</DTS:ConnectionManagers>
<DTS:Variables>
<DTS:Variable
DTS:CreationName=""
DTS:DTSID="{A1662DA6-8EBB-4859-9B77-B83DF19677EE}"
DTS:IncludeInDebugDump="6789"
DTS:Namespace="User"
DTS:ObjectName="batchLogId">
<DTS:VariableValue
DTS:DataType="20">0</DTS:VariableValue>
</DTS:Variable>
<DTS:Variable
DTS:CreationName=""
DTS:DTSID="{8113C285-4056-4CA0-A1B8-37E9A00CB733}"
DTS:IncludeInDebugDump="6789"
DTS:Namespace="User"
DTS:ObjectName="batchRecordCount">
<DTS:VariableValue
DTS:DataType="20">0</DTS:VariableValue>
</DTS:Variable>
<DTS:Variable
DTS:CreationName=""
DTS:DTSID="{21DEDC2F-BD0D-4105-BB5D-6E248E0B5B37}"
DTS:IncludeInDebugDump="2345"
DTS:Namespace="User"
DTS:ObjectName="loadStatusComplete">
<DTS:VariableValue
DTS:DataType="8">EXTCOMPLETE</DTS:VariableValue>
</DTS:Variable>
<DTS:Variable
DTS:CreationName=""
DTS:DTSID="{91E013CE-0AC0-4B7E-95BE-8DBBF1D3812B}"
DTS:IncludeInDebugDump="2345"
DTS:Namespace="User"
DTS:ObjectName="loadStatusError">
<DTS:VariableValue
DTS:DataType="8">EXTERROR</DTS:VariableValue>
</DTS:Variable>
<DTS:Variable
DTS:CreationName=""
DTS:DTSID="{F0678DC9-0510-470F-933F-D346F85D4E63}"
DTS:IncludeInDebugDump="6789"
DTS:Namespace="User"
DTS:ObjectName="maxSourceBatchNumber">
<DTS:VariableValue
DTS:DataType="20">0</DTS:VariableValue>
</DTS:Variable>
<DTS:Variable
DTS:CreationName=""
DTS:DTSID="{667A29B3-C7F6-4EB6-9267-4FAC4853BC74}"
DTS:IncludeInDebugDump="6789"
DTS:Namespace="User"
DTS:ObjectName="priorSourceBatchNumber">
<DTS:VariableValue
DTS:DataType="20">0</DTS:VariableValue>
</DTS:Variable>
<DTS:Variable
DTS:CreationName=""
DTS:DTSID="{B8BC3A11-38AB-4505-9E61-7ACE0906630D}"
DTS:IncludeInDebugDump="2345"
DTS:Namespace="User"
DTS:ObjectName="rawTableName">
<DTS:VariableValue
DTS:DataType="8">zraw._conConsultspv</DTS:VariableValue>
</DTS:Variable>
<DTS:Variable
DTS:CreationName=""
DTS:DTSID="{83C09810-34AA-497B-BD62-7B1E0B5C7C1F}"
DTS:IncludeInDebugDump="6789"
DTS:Namespace="User"
DTS:ObjectName="resultOK">
<DTS:VariableValue
DTS:DataType="3">0</DTS:VariableValue>
</DTS:Variable>
<DTS:Variable
DTS:CreationName=""
DTS:DTSID="{5B3B9CE8-A7A1-45F0-A481-D6033D11E9DB}"
DTS:IncludeInDebugDump="2345"
DTS:Namespace="User"
DTS:ObjectName="sourceTableName">
<DTS:VariableValue
DTS:DataType="8">con.consult</DTS:VariableValue>
</DTS:Variable>
</DTS:Variables>
<DTS:Executables>
<DTS:Executable
DTS:refId="Package\Data Flow Task"
DTS:CreationName="Microsoft.Pipeline"
DTS:Description="Data Flow Task"
DTS:DTSID="{C2E55D1B-87E3-4F4C-93E3-F3DFCF3932A0}"
DTS:ExecutableType="Microsoft.Pipeline"
DTS:LocaleID="-1"
DTS:ObjectName="Data Flow Task"
DTS:TaskContact="Performs high-performance data extraction, transformation and loading;Microsoft Corporation; Microsoft SQL Server; (C) Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1">
<DTS:Variables />
<DTS:ObjectData>
<pipeline
version="1">
<components>
<component
refId="Package\Data Flow Task\ADO NET Destination"
componentClassID="Microsoft.ManagedComponentHost"
contactInfo="Loads data into an ADO.NET-compliant database that uses a database table or view. Load data into a new or existing table. For example, use an ADO.NET provider for ODBC to load data into an ODBC destination.;Microsoft Corporation; Microsoft SQL Server; © Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;2"
description="Loads data into an ADO.NET-compliant database that uses a database table or view. Load data into a new or existing table. For example, use an ADO.NET provider for ODBC to load data into an ODBC destination."
name="ADO NET Destination"
usesDispositions="true"
version="2">
<properties>
<property
dataType="System.String"
description="The Destination database table name."
expressionType="Notify"
name="TableOrViewName"
UITypeEditor="Microsoft.DataTransformationServices.Controls.ModalMultilineStringEditor">"zraw"."_conConsultspv"</property>
<property
dataType="System.Int32"
description="Specify the number of rows per batch. The default is 0 which uses the same size as SSIS internal buffer. "
expressionType="Notify"
name="BatchSize">0</property>
<property
dataType="System.Int32"
description="The number of seconds before a command times out. A value of 0 indicates infinite time-out. "
expressionType="Notify"
name="CommandTimeout">30</property>
<property
dataType="System.Boolean"
description="Specifies whether to use the SqlBulkCopy interface to improve the performance of bulk insert operations. Only certain providers support this interface."
expressionType="Notify"
name="UseBulkInsertWhenPossible">true</property>
<property
dataType="System.String"
name="UserComponentTypeName">Microsoft.ADONETDestination</property>
</properties>
<connections>
<connection
refId="Package\Data Flow Task\ADO NET Destination.Connections[IDbConnection]"
connectionManagerID="{357B8BF8-C32A-44A8-B818-929F68D4ED41}:external"
connectionManagerRefId="Project.ConnectionManagers[
URL EPRS_ShadowADONET]"
description="Managed connection manager"
name="IDbConnection" />
</connections>
<inputs>
<input
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input]"
errorRowDisposition="FailComponent"
hasSideEffects="true"
name="ADO NET Destination Input">
<inputColumns>
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[ConsultSID]"
cachedDataType="i8"
cachedName="ConsultSID"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[ConsultSID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ConsultSID]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[ConsultIEN]"
cachedDataType="wstr"
cachedLength="50"
cachedName="ConsultIEN"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[ConsultIEN]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ConsultIEN]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[Sta3n]"
cachedDataType="i2"
cachedName="Sta3n"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[Sta3n]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[Sta3n]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[PatientSID]"
cachedDataType="i4"
cachedName="PatientSID"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[PatientSID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[PatientSID]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[PatientLocationSID]"
cachedDataType="i4"
cachedName="PatientLocationSID"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[PatientLocationSID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[PatientLocationSID]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[ProtocolSID]"
cachedDataType="i4"
cachedName="ProtocolSID"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[ProtocolSID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ProtocolSID]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[GMRCProcedureSID]"
cachedDataType="i4"
cachedName="GMRCProcedureSID"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[GMRCProcedureSID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[GMRCProcedureSID]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[GMRCProcedure]"
cachedDataType="wstr"
cachedLength="100"
cachedName="GMRCProcedure"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[GMRCProcedure]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[GMRCProcedure]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[ClinicalProcedureSID]"
cachedDataType="i4"
cachedName="ClinicalProcedureSID"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[ClinicalProcedureSID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ClinicalProcedureSID]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[ToRequestServiceSID]"
cachedDataType="i4"
cachedName="ToRequestServiceSID"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[ToRequestServiceSID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ToRequestServiceSID]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[ToRequestServiceName]"
cachedDataType="wstr"
cachedLength="100"
cachedName="ToRequestServiceName"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[ToRequestServiceName]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ToRequestServiceName]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[RequestDateTime]"
cachedDataType="dbTimeStamp2"
cachedName="RequestDateTime"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[RequestDateTime]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[RequestDateTime]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[RequestVistaErrorDate]"
cachedDataType="wstr"
cachedLength="50"
cachedName="RequestVistaErrorDate"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[RequestVistaErrorDate]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[RequestVistaErrorDate]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[RequestDateTimeTransformSID]"
cachedDataType="i8"
cachedName="RequestDateTimeTransformSID"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[RequestDateTimeTransformSID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[RequestDateTimeTransformSID]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[RequestDateSID]"
cachedDataType="i4"
cachedName="RequestDateSID"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[RequestDateSID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[RequestDateSID]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[FileEntryDateTime]"
cachedDataType="dbTimeStamp2"
cachedName="FileEntryDateTime"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[FileEntryDateTime]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[FileEntryDateTime]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[FileEntryVistaErrorDate]"
cachedDataType="wstr"
cachedLength="50"
cachedName="FileEntryVistaErrorDate"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[FileEntryVistaErrorDate]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[FileEntryVistaErrorDate]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[FileEntryDateTimeTransformSID]"
cachedDataType="i8"
cachedName="FileEntryDateTimeTransformSID"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[FileEntryDateTimeTransformSID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[FileEntryDateTimeTransformSID]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[FromLocationSID]"
cachedDataType="i4"
cachedName="FromLocationSID"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[FromLocationSID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[FromLocationSID]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[RequestType]"
cachedDataType="wstr"
cachedLength="50"
cachedName="RequestType"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[RequestType]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[RequestType]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[ToStaffSID]"
cachedDataType="i4"
cachedName="ToStaffSID"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[ToStaffSID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ToStaffSID]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[OrderStatusSID]"
cachedDataType="i4"
cachedName="OrderStatusSID"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[OrderStatusSID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[OrderStatusSID]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[CPRSOrderSID]"
cachedDataType="i8"
cachedName="CPRSOrderSID"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[CPRSOrderSID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[CPRSOrderSID]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[CPRSStatus]"
cachedDataType="wstr"
cachedLength="50"
cachedName="CPRSStatus"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[CPRSStatus]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[CPRSStatus]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[RecentActivityTypeSID]"
cachedDataType="i4"
cachedName="RecentActivityTypeSID"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[RecentActivityTypeSID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[RecentActivityTypeSID]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[RecentActivityType]"
cachedDataType="wstr"
cachedLength="100"
cachedName="RecentActivityType"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[RecentActivityType]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[RecentActivityType]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[SendingStaffSID]"
cachedDataType="i4"
cachedName="SendingStaffSID"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[SendingStaffSID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[SendingStaffSID]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[SignificantFindings]"
cachedDataType="wstr"
cachedLength="1"
cachedName="SignificantFindings"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[SignificantFindings]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[SignificantFindings]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[UrgencyProtocolSID]"
cachedDataType="i4"
cachedName="UrgencyProtocolSID"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[UrgencyProtocolSID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[UrgencyProtocolSID]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[Urgency]"
cachedDataType="wstr"
cachedLength="50"
cachedName="Urgency"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[Urgency]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[Urgency]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[ConsultPlaceProtocolSID]"
cachedDataType="i4"
cachedName="ConsultPlaceProtocolSID"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[ConsultPlaceProtocolSID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ConsultPlaceProtocolSID]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[PlaceOfConsultation]"
cachedDataType="wstr"
cachedLength="50"
cachedName="PlaceOfConsultation"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[PlaceOfConsultation]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[PlaceOfConsultation]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[DisplayTextOfItemOrdered]"
cachedDataType="wstr"
cachedLength="100"
cachedName="DisplayTextOfItemOrdered"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[DisplayTextOfItemOrdered]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[DisplayTextOfItemOrdered]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[OrderingInstitutionSID]"
cachedDataType="i4"
cachedName="OrderingInstitutionSID"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[OrderingInstitutionSID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[OrderingInstitutionSID]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[OrderingSta3n]"
cachedDataType="i2"
cachedName="OrderingSta3n"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[OrderingSta3n]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[OrderingSta3n]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[InpatOutpat]"
cachedDataType="wstr"
cachedLength="50"
cachedName="InpatOutpat"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[InpatOutpat]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[InpatOutpat]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[ProvisionalDiagnosis]"
cachedDataType="wstr"
cachedLength="255"
cachedName="ProvisionalDiagnosis"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[ProvisionalDiagnosis]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ProvisionalDiagnosis]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[ProvisionalDiagnosisCode]"
cachedDataType="wstr"
cachedLength="50"
cachedName="ProvisionalDiagnosisCode"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[ProvisionalDiagnosisCode]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ProvisionalDiagnosisCode]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[RemoteRole]"
cachedDataType="wstr"
cachedLength="50"
cachedName="RemoteRole"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[RemoteRole]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[RemoteRole]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[RemoteService]"
cachedDataType="wstr"
cachedLength="100"
cachedName="RemoteService"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[RemoteService]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[RemoteService]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[RemoteConsultInstitutionSID]"
cachedDataType="i4"
cachedName="RemoteConsultInstitutionSID"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[RemoteConsultInstitutionSID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[RemoteConsultInstitutionSID]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[RemoteConsultSta3n]"
cachedDataType="wstr"
cachedLength="50"
cachedName="RemoteConsultSta3n"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[RemoteConsultSta3n]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[RemoteConsultSta3n]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[RemoteConsultSID]"
cachedDataType="i8"
cachedName="RemoteConsultSID"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[RemoteConsultSID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[RemoteConsultSID]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[TIUDocumentSID]"
cachedDataType="i8"
cachedName="TIUDocumentSID"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[TIUDocumentSID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[TIUDocumentSID]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[EarliestDate]"
cachedDataType="dbDate"
cachedName="EarliestDate"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[EarliestDate]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[EarliestDate]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[EarliestVistaErrorDate]"
cachedDataType="wstr"
cachedLength="50"
cachedName="EarliestVistaErrorDate"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[EarliestVistaErrorDate]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[EarliestVistaErrorDate]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[EarliestDateTransformSID]"
cachedDataType="i8"
cachedName="EarliestDateTransformSID"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[EarliestDateTransformSID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[EarliestDateTransformSID]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[ClinicalProcedureIEN]"
cachedDataType="wstr"
cachedLength="50"
cachedName="ClinicalProcedureIEN"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[ClinicalProcedureIEN]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ClinicalProcedureIEN]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[ConsultPlaceProtocolIEN]"
cachedDataType="wstr"
cachedLength="50"
cachedName="ConsultPlaceProtocolIEN"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[ConsultPlaceProtocolIEN]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ConsultPlaceProtocolIEN]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[CPRSOrderIEN]"
cachedDataType="wstr"
cachedLength="50"
cachedName="CPRSOrderIEN"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[CPRSOrderIEN]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[CPRSOrderIEN]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[FromLocationIEN]"
cachedDataType="wstr"
cachedLength="50"
cachedName="FromLocationIEN"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[FromLocationIEN]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[FromLocationIEN]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[GMRCProcedureIEN]"
cachedDataType="wstr"
cachedLength="50"
cachedName="GMRCProcedureIEN"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[GMRCProcedureIEN]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[GMRCProcedureIEN]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[OrderingInstitutionIEN]"
cachedDataType="wstr"
cachedLength="50"
cachedName="OrderingInstitutionIEN"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[OrderingInstitutionIEN]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[OrderingInstitutionIEN]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[OrderStatusIEN]"
cachedDataType="wstr"
cachedLength="50"
cachedName="OrderStatusIEN"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[OrderStatusIEN]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[OrderStatusIEN]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[PatientIEN]"
cachedDataType="wstr"
cachedLength="50"
cachedName="PatientIEN"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[PatientIEN]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[PatientIEN]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[PatientLocationIEN]"
cachedDataType="wstr"
cachedLength="50"
cachedName="PatientLocationIEN"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[PatientLocationIEN]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[PatientLocationIEN]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[ProtocolIEN]"
cachedDataType="wstr"
cachedLength="50"
cachedName="ProtocolIEN"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[ProtocolIEN]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ProtocolIEN]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[RecentActivityTypeIEN]"
cachedDataType="wstr"
cachedLength="50"
cachedName="RecentActivityTypeIEN"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[RecentActivityTypeIEN]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[RecentActivityTypeIEN]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[RemoteConsultIEN]"
cachedDataType="wstr"
cachedLength="50"
cachedName="RemoteConsultIEN"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[RemoteConsultIEN]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[RemoteConsultIEN]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[RemoteConsultInstitutionIEN]"
cachedDataType="wstr"
cachedLength="50"
cachedName="RemoteConsultInstitutionIEN"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[RemoteConsultInstitutionIEN]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[RemoteConsultInstitutionIEN]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[SendingStaffIEN]"
cachedDataType="wstr"
cachedLength="50"
cachedName="SendingStaffIEN"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[SendingStaffIEN]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[SendingStaffIEN]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[TIUDocumentIEN]"
cachedDataType="wstr"
cachedLength="50"
cachedName="TIUDocumentIEN"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[TIUDocumentIEN]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[TIUDocumentIEN]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[ToRequestServiceIEN]"
cachedDataType="wstr"
cachedLength="50"
cachedName="ToRequestServiceIEN"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[ToRequestServiceIEN]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ToRequestServiceIEN]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[ToStaffIEN]"
cachedDataType="wstr"
cachedLength="50"
cachedName="ToStaffIEN"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[ToStaffIEN]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ToStaffIEN]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[UrgencyProtocolIEN]"
cachedDataType="wstr"
cachedLength="50"
cachedName="UrgencyProtocolIEN"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[UrgencyProtocolIEN]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[UrgencyProtocolIEN]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[ResultIEN]"
cachedDataType="wstr"
cachedLength="50"
cachedName="ResultIEN"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[ResultIEN]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ResultIEN]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[ResultSID]"
cachedDataType="i8"
cachedName="ResultSID"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[ResultSID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ResultSID]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[ResultPointedToFileNumber]"
cachedDataType="wstr"
cachedLength="50"
cachedName="ResultPointedToFileNumber"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[ResultPointedToFileNumber]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ResultPointedToFileNumber]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[ETLBatchID]"
cachedDataType="i4"
cachedName="ETLBatchID"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[ETLBatchID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ETLBatchID]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[OpCode]"
cachedDataType="wstr"
cachedLength="1"
cachedName="OpCode"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[OpCode]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[OpCode]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[VistaCreateDate]"
cachedDataType="dbTimeStamp"
cachedName="VistaCreateDate"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[VistaCreateDate]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[VistaCreateDate]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[VistaEditDate]"
cachedDataType="dbTimeStamp"
cachedName="VistaEditDate"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[VistaEditDate]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[VistaEditDate]" />
<inputColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].Columns[BatchLogID]"
cachedDataType="i8"
cachedName="BatchLogID"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[BatchLogID]"
lineageId="Package\Data Flow Task\Derived Column.Outputs[Derived Column Output].Columns[BatchLogID]" />
</inputColumns>
<externalMetadataColumns
isUsed="True">
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[ConsultSID]"
dataType="i8"
name="ConsultSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[ConsultIEN]"
dataType="wstr"
length="50"
name="ConsultIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[Sta3n]"
dataType="i2"
name="Sta3n" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[PatientSID]"
dataType="i4"
name="PatientSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[PatientLocationSID]"
dataType="i4"
name="PatientLocationSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[ProtocolSID]"
dataType="i4"
name="ProtocolSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[GMRCProcedureSID]"
dataType="i4"
name="GMRCProcedureSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[GMRCProcedure]"
dataType="wstr"
length="100"
name="GMRCProcedure" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[ClinicalProcedureSID]"
dataType="i4"
name="ClinicalProcedureSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[ToRequestServiceSID]"
dataType="i4"
name="ToRequestServiceSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[ToRequestServiceName]"
dataType="wstr"
length="100"
name="ToRequestServiceName" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[RequestDateTime]"
dataType="dbTimeStamp"
name="RequestDateTime" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[RequestVistaErrorDate]"
dataType="wstr"
length="50"
name="RequestVistaErrorDate" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[RequestDateTimeTransformSID]"
dataType="i8"
name="RequestDateTimeTransformSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[RequestDateSID]"
dataType="i4"
name="RequestDateSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[FileEntryDateTime]"
dataType="dbTimeStamp"
name="FileEntryDateTime" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[FileEntryVistaErrorDate]"
dataType="wstr"
length="50"
name="FileEntryVistaErrorDate" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[FileEntryDateTimeTransformSID]"
dataType="i8"
name="FileEntryDateTimeTransformSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[FromLocationSID]"
dataType="i4"
name="FromLocationSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[RequestType]"
dataType="wstr"
length="50"
name="RequestType" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[ToStaffSID]"
dataType="i4"
name="ToStaffSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[OrderStatusSID]"
dataType="i4"
name="OrderStatusSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[CPRSOrderSID]"
dataType="i8"
name="CPRSOrderSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[CPRSStatus]"
dataType="wstr"
length="50"
name="CPRSStatus" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[RecentActivityTypeSID]"
dataType="i4"
name="RecentActivityTypeSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[RecentActivityType]"
dataType="wstr"
length="100"
name="RecentActivityType" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[SendingStaffSID]"
dataType="i4"
name="SendingStaffSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[SignificantFindings]"
dataType="wstr"
length="1"
name="SignificantFindings" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[UrgencyProtocolSID]"
dataType="i4"
name="UrgencyProtocolSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[Urgency]"
dataType="wstr"
length="50"
name="Urgency" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[ConsultPlaceProtocolSID]"
dataType="i4"
name="ConsultPlaceProtocolSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[PlaceOfConsultation]"
dataType="wstr"
length="50"
name="PlaceOfConsultation" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[DisplayTextOfItemOrdered]"
dataType="wstr"
length="100"
name="DisplayTextOfItemOrdered" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[OrderingInstitutionSID]"
dataType="i4"
name="OrderingInstitutionSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[OrderingSta3n]"
dataType="i2"
name="OrderingSta3n" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[InpatOutpat]"
dataType="wstr"
length="50"
name="InpatOutpat" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[ProvisionalDiagnosis]"
dataType="wstr"
length="255"
name="ProvisionalDiagnosis" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[ProvisionalDiagnosisCode]"
dataType="wstr"
length="50"
name="ProvisionalDiagnosisCode" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[RemoteRole]"
dataType="wstr"
length="50"
name="RemoteRole" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[RemoteService]"
dataType="wstr"
length="100"
name="RemoteService" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[RemoteConsultInstitutionSID]"
dataType="i4"
name="RemoteConsultInstitutionSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[RemoteConsultSta3n]"
dataType="wstr"
length="50"
name="RemoteConsultSta3n" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[RemoteConsultSID]"
dataType="i8"
name="RemoteConsultSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[TIUDocumentSID]"
dataType="i8"
name="TIUDocumentSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[EarliestDate]"
dataType="dbTimeStamp"
name="EarliestDate" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[EarliestVistaErrorDate]"
dataType="wstr"
length="50"
name="EarliestVistaErrorDate" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[EarliestDateTransformSID]"
dataType="i8"
name="EarliestDateTransformSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[ClinicalProcedureIEN]"
dataType="wstr"
length="50"
name="ClinicalProcedureIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[ConsultPlaceProtocolIEN]"
dataType="wstr"
length="50"
name="ConsultPlaceProtocolIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[CPRSOrderIEN]"
dataType="wstr"
length="50"
name="CPRSOrderIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[FromLocationIEN]"
dataType="wstr"
length="50"
name="FromLocationIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[GMRCProcedureIEN]"
dataType="wstr"
length="50"
name="GMRCProcedureIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[OrderingInstitutionIEN]"
dataType="wstr"
length="50"
name="OrderingInstitutionIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[OrderStatusIEN]"
dataType="wstr"
length="50"
name="OrderStatusIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[PatientIEN]"
dataType="wstr"
length="50"
name="PatientIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[PatientLocationIEN]"
dataType="wstr"
length="50"
name="PatientLocationIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[ProtocolIEN]"
dataType="wstr"
length="50"
name="ProtocolIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[RecentActivityTypeIEN]"
dataType="wstr"
length="50"
name="RecentActivityTypeIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[RemoteConsultIEN]"
dataType="wstr"
length="50"
name="RemoteConsultIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[RemoteConsultInstitutionIEN]"
dataType="wstr"
length="50"
name="RemoteConsultInstitutionIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[SendingStaffIEN]"
dataType="wstr"
length="50"
name="SendingStaffIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[TIUDocumentIEN]"
dataType="wstr"
length="50"
name="TIUDocumentIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[ToRequestServiceIEN]"
dataType="wstr"
length="50"
name="ToRequestServiceIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[ToStaffIEN]"
dataType="wstr"
length="50"
name="ToStaffIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[UrgencyProtocolIEN]"
dataType="wstr"
length="50"
name="UrgencyProtocolIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[ResultIEN]"
dataType="wstr"
length="50"
name="ResultIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[ResultSID]"
dataType="i8"
name="ResultSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[ResultPointedToFileNumber]"
dataType="wstr"
length="50"
name="ResultPointedToFileNumber" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[ETLBatchID]"
dataType="i4"
name="ETLBatchID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[OpCode]"
dataType="wstr"
length="1"
name="OpCode" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[VistaCreateDate]"
dataType="dbTimeStamp"
name="VistaCreateDate" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[VistaEditDate]"
dataType="dbTimeStamp"
name="VistaEditDate" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input].ExternalColumns[BatchLogID]"
dataType="i8"
name="BatchLogID" />
</externalMetadataColumns>
</input>
</inputs>
<outputs>
<output
refId="Package\Data Flow Task\ADO NET Destination.Outputs[ADO NET Destination Error Output]"
exclusionGroup="1"
isErrorOut="true"
name="ADO NET Destination Error Output"
synchronousInputId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input]">
<outputColumns>
<outputColumn
refId="Package\Data Flow Task\ADO NET Destination.Outputs[ADO NET Destination Error Output].Columns[ErrorCode]"
dataType="i4"
lineageId="Package\Data Flow Task\ADO NET Destination.Outputs[ADO NET Destination Error Output].Columns[ErrorCode]"
name="ErrorCode"
specialFlags="1" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Destination.Outputs[ADO NET Destination Error Output].Columns[ErrorColumn]"
dataType="i4"
lineageId="Package\Data Flow Task\ADO NET Destination.Outputs[ADO NET Destination Error Output].Columns[ErrorColumn]"
name="ErrorColumn"
specialFlags="2" />
</outputColumns>
<externalMetadataColumns />
</output>
</outputs>
</component>
<component
refId="Package\Data Flow Task\ADO NET Source"
componentClassID="Microsoft.ManagedComponentHost"
contactInfo="Consumes data from SQL Server, OLE DB, ODBC, or Oracle, using the corresponding .NET Framework data provider. Use a Transact-SQL statement to define the result set. For example, extract data from SQL Server with the .NET Framework data provider for SQL Server.;Microsoft Corporation; Microsoft SQL Server; © Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;4"
description="Consumes data from SQL Server, OLE DB, ODBC, or Oracle, using the corresponding .NET Framework data provider. Use a Transact-SQL statement to define the result set. For example, extract data from SQL Server with the .NET Framework data provider for SQL Server."
name="ADO NET Source"
usesDispositions="true"
version="4">
<properties>
<property
dataType="System.String"
description="Specifies the SQL statement used by the component to extract data."
expressionType="Notify"
name="SqlCommand"
UITypeEditor="Microsoft.DataTransformationServices.Controls.ModalMultilineStringEditor">SELECT *
FROM con.consult
Where RequestDateTime &gt; '08-17-2016' and RequestDateTime &lt; '08-18-2016'
and Sta3n = 648</property>
<property
dataType="System.Int32"
description="The number of seconds before a command times out. A value of 0 indicates an infinite time-out."
name="CommandTimeout">30</property>
<property
dataType="System.Boolean"
description="Indicates whether to allow non-string external columns to be implicitly converted to strings at the output columns."
name="AllowImplicitStringConversion">true</property>
<property
dataType="System.String"
description="The Source database table name."
expressionType="Notify"
name="TableOrViewName"
UITypeEditor="Microsoft.DataTransformationServices.Controls.ModalMultilineStringEditor">"dbo"."SourceSamples"</property>
<property
dataType="System.Int32"
description="Specify the mode to retrieve external column information"
name="AccessMode"
typeConverter="Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter+EnumToStringConverter">2</property>
<property
dataType="System.String"
name="UserComponentTypeName">Microsoft.DataReaderSourceAdapter</property>
</properties>
<connections>
<connection
refId="Package\Data Flow Task\ADO NET Source.Connections[IDbConnection]"
connectionManagerID="{B0B8FA1D-A76C-4176-9A78-853ABBCCA1F6}:external"
connectionManagerRefId="Project.ConnectionManagers[
URL SPVADONET]"
description="Managed connection manager"
name="IDbConnection" />
</connections>
<outputs>
<output
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output]"
name="ADO NET Source Output">
<outputColumns>
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ConsultSID]"
dataType="i8"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[ConsultSID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ConsultSID]"
name="ConsultSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ConsultIEN]"
dataType="wstr"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[ConsultIEN]"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ConsultIEN]"
name="ConsultIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[Sta3n]"
dataType="i2"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[Sta3n]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[Sta3n]"
name="Sta3n"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[PatientSID]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[PatientSID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[PatientSID]"
name="PatientSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[PatientLocationSID]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[PatientLocationSID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[PatientLocationSID]"
name="PatientLocationSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ProtocolSID]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[ProtocolSID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ProtocolSID]"
name="ProtocolSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[GMRCProcedureSID]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[GMRCProcedureSID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[GMRCProcedureSID]"
name="GMRCProcedureSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[GMRCProcedure]"
dataType="wstr"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[GMRCProcedure]"
length="100"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[GMRCProcedure]"
name="GMRCProcedure"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ClinicalProcedureSID]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[ClinicalProcedureSID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ClinicalProcedureSID]"
name="ClinicalProcedureSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ToRequestServiceSID]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[ToRequestServiceSID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ToRequestServiceSID]"
name="ToRequestServiceSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ToRequestServiceName]"
dataType="wstr"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[ToRequestServiceName]"
length="100"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ToRequestServiceName]"
name="ToRequestServiceName"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[RequestDateTime]"
dataType="dbTimeStamp2"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[RequestDateTime]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[RequestDateTime]"
name="RequestDateTime"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[RequestVistaErrorDate]"
dataType="wstr"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[RequestVistaErrorDate]"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[RequestVistaErrorDate]"
name="RequestVistaErrorDate"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[RequestDateTimeTransformSID]"
dataType="i8"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[RequestDateTimeTransformSID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[RequestDateTimeTransformSID]"
name="RequestDateTimeTransformSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[RequestDateSID]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[RequestDateSID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[RequestDateSID]"
name="RequestDateSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[FileEntryDateTime]"
dataType="dbTimeStamp2"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[FileEntryDateTime]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[FileEntryDateTime]"
name="FileEntryDateTime"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[FileEntryVistaErrorDate]"
dataType="wstr"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[FileEntryVistaErrorDate]"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[FileEntryVistaErrorDate]"
name="FileEntryVistaErrorDate"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[FileEntryDateTimeTransformSID]"
dataType="i8"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[FileEntryDateTimeTransformSID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[FileEntryDateTimeTransformSID]"
name="FileEntryDateTimeTransformSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[FromLocationSID]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[FromLocationSID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[FromLocationSID]"
name="FromLocationSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[RequestType]"
dataType="wstr"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[RequestType]"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[RequestType]"
name="RequestType"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ToStaffSID]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[ToStaffSID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ToStaffSID]"
name="ToStaffSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[OrderStatusSID]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[OrderStatusSID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[OrderStatusSID]"
name="OrderStatusSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[CPRSOrderSID]"
dataType="i8"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[CPRSOrderSID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[CPRSOrderSID]"
name="CPRSOrderSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[CPRSStatus]"
dataType="wstr"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[CPRSStatus]"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[CPRSStatus]"
name="CPRSStatus"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[RecentActivityTypeSID]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[RecentActivityTypeSID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[RecentActivityTypeSID]"
name="RecentActivityTypeSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[RecentActivityType]"
dataType="wstr"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[RecentActivityType]"
length="100"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[RecentActivityType]"
name="RecentActivityType"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[SendingStaffSID]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[SendingStaffSID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[SendingStaffSID]"
name="SendingStaffSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[SignificantFindings]"
dataType="wstr"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[SignificantFindings]"
length="1"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[SignificantFindings]"
name="SignificantFindings"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[UrgencyProtocolSID]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[UrgencyProtocolSID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[UrgencyProtocolSID]"
name="UrgencyProtocolSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[Urgency]"
dataType="wstr"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[Urgency]"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[Urgency]"
name="Urgency"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ConsultPlaceProtocolSID]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[ConsultPlaceProtocolSID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ConsultPlaceProtocolSID]"
name="ConsultPlaceProtocolSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[PlaceOfConsultation]"
dataType="wstr"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[PlaceOfConsultation]"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[PlaceOfConsultation]"
name="PlaceOfConsultation"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[DisplayTextOfItemOrdered]"
dataType="wstr"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[DisplayTextOfItemOrdered]"
length="100"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[DisplayTextOfItemOrdered]"
name="DisplayTextOfItemOrdered"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[OrderingInstitutionSID]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[OrderingInstitutionSID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[OrderingInstitutionSID]"
name="OrderingInstitutionSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[OrderingSta3n]"
dataType="i2"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[OrderingSta3n]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[OrderingSta3n]"
name="OrderingSta3n"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[InpatOutpat]"
dataType="wstr"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[InpatOutpat]"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[InpatOutpat]"
name="InpatOutpat"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ProvisionalDiagnosis]"
dataType="wstr"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[ProvisionalDiagnosis]"
length="255"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ProvisionalDiagnosis]"
name="ProvisionalDiagnosis"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ProvisionalDiagnosisCode]"
dataType="wstr"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[ProvisionalDiagnosisCode]"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ProvisionalDiagnosisCode]"
name="ProvisionalDiagnosisCode"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[RemoteRole]"
dataType="wstr"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[RemoteRole]"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[RemoteRole]"
name="RemoteRole"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[RemoteService]"
dataType="wstr"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[RemoteService]"
length="100"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[RemoteService]"
name="RemoteService"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[RemoteConsultInstitutionSID]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[RemoteConsultInstitutionSID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[RemoteConsultInstitutionSID]"
name="RemoteConsultInstitutionSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[RemoteConsultSta3n]"
dataType="wstr"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[RemoteConsultSta3n]"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[RemoteConsultSta3n]"
name="RemoteConsultSta3n"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[RemoteConsultSID]"
dataType="i8"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[RemoteConsultSID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[RemoteConsultSID]"
name="RemoteConsultSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[TIUDocumentSID]"
dataType="i8"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[TIUDocumentSID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[TIUDocumentSID]"
name="TIUDocumentSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[EarliestDate]"
dataType="dbDate"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[EarliestDate]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[EarliestDate]"
name="EarliestDate"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[EarliestVistaErrorDate]"
dataType="wstr"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[EarliestVistaErrorDate]"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[EarliestVistaErrorDate]"
name="EarliestVistaErrorDate"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[EarliestDateTransformSID]"
dataType="i8"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[EarliestDateTransformSID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[EarliestDateTransformSID]"
name="EarliestDateTransformSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ClinicalProcedureIEN]"
dataType="wstr"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[ClinicalProcedureIEN]"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ClinicalProcedureIEN]"
name="ClinicalProcedureIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ConsultPlaceProtocolIEN]"
dataType="wstr"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[ConsultPlaceProtocolIEN]"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ConsultPlaceProtocolIEN]"
name="ConsultPlaceProtocolIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[CPRSOrderIEN]"
dataType="wstr"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[CPRSOrderIEN]"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[CPRSOrderIEN]"
name="CPRSOrderIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[FromLocationIEN]"
dataType="wstr"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[FromLocationIEN]"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[FromLocationIEN]"
name="FromLocationIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[GMRCProcedureIEN]"
dataType="wstr"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[GMRCProcedureIEN]"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[GMRCProcedureIEN]"
name="GMRCProcedureIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[OrderingInstitutionIEN]"
dataType="wstr"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[OrderingInstitutionIEN]"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[OrderingInstitutionIEN]"
name="OrderingInstitutionIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[OrderStatusIEN]"
dataType="wstr"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[OrderStatusIEN]"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[OrderStatusIEN]"
name="OrderStatusIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[PatientIEN]"
dataType="wstr"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[PatientIEN]"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[PatientIEN]"
name="PatientIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[PatientLocationIEN]"
dataType="wstr"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[PatientLocationIEN]"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[PatientLocationIEN]"
name="PatientLocationIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ProtocolIEN]"
dataType="wstr"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[ProtocolIEN]"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ProtocolIEN]"
name="ProtocolIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[RecentActivityTypeIEN]"
dataType="wstr"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[RecentActivityTypeIEN]"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[RecentActivityTypeIEN]"
name="RecentActivityTypeIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[RemoteConsultIEN]"
dataType="wstr"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[RemoteConsultIEN]"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[RemoteConsultIEN]"
name="RemoteConsultIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[RemoteConsultInstitutionIEN]"
dataType="wstr"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[RemoteConsultInstitutionIEN]"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[RemoteConsultInstitutionIEN]"
name="RemoteConsultInstitutionIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[SendingStaffIEN]"
dataType="wstr"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[SendingStaffIEN]"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[SendingStaffIEN]"
name="SendingStaffIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[TIUDocumentIEN]"
dataType="wstr"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[TIUDocumentIEN]"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[TIUDocumentIEN]"
name="TIUDocumentIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ToRequestServiceIEN]"
dataType="wstr"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[ToRequestServiceIEN]"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ToRequestServiceIEN]"
name="ToRequestServiceIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ToStaffIEN]"
dataType="wstr"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[ToStaffIEN]"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ToStaffIEN]"
name="ToStaffIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[UrgencyProtocolIEN]"
dataType="wstr"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[UrgencyProtocolIEN]"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[UrgencyProtocolIEN]"
name="UrgencyProtocolIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ResultIEN]"
dataType="wstr"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[ResultIEN]"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ResultIEN]"
name="ResultIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ResultSID]"
dataType="i8"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[ResultSID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ResultSID]"
name="ResultSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ResultPointedToFileNumber]"
dataType="wstr"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[ResultPointedToFileNumber]"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ResultPointedToFileNumber]"
name="ResultPointedToFileNumber"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ETLBatchID]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[ETLBatchID]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[ETLBatchID]"
name="ETLBatchID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[OpCode]"
dataType="wstr"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[OpCode]"
length="1"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[OpCode]"
name="OpCode"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[VistaCreateDate]"
dataType="dbTimeStamp"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[VistaCreateDate]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[VistaCreateDate]"
name="VistaCreateDate"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[VistaEditDate]"
dataType="dbTimeStamp"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[VistaEditDate]"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].Columns[VistaEditDate]"
name="VistaEditDate"
truncationRowDisposition="FailComponent" />
</outputColumns>
<externalMetadataColumns
isUsed="True">
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[ConsultSID]"
dataType="i8"
name="ConsultSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[ConsultIEN]"
dataType="wstr"
length="50"
name="ConsultIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[Sta3n]"
dataType="i2"
name="Sta3n" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[PatientSID]"
dataType="i4"
name="PatientSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[PatientLocationSID]"
dataType="i4"
name="PatientLocationSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[ProtocolSID]"
dataType="i4"
name="ProtocolSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[GMRCProcedureSID]"
dataType="i4"
name="GMRCProcedureSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[GMRCProcedure]"
dataType="wstr"
length="100"
name="GMRCProcedure" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[ClinicalProcedureSID]"
dataType="i4"
name="ClinicalProcedureSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[ToRequestServiceSID]"
dataType="i4"
name="ToRequestServiceSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[ToRequestServiceName]"
dataType="wstr"
length="100"
name="ToRequestServiceName" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[RequestDateTime]"
dataType="dbTimeStamp2"
name="RequestDateTime" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[RequestVistaErrorDate]"
dataType="wstr"
length="50"
name="RequestVistaErrorDate" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[RequestDateTimeTransformSID]"
dataType="i8"
name="RequestDateTimeTransformSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[RequestDateSID]"
dataType="i4"
name="RequestDateSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[FileEntryDateTime]"
dataType="dbTimeStamp2"
name="FileEntryDateTime" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[FileEntryVistaErrorDate]"
dataType="wstr"
length="50"
name="FileEntryVistaErrorDate" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[FileEntryDateTimeTransformSID]"
dataType="i8"
name="FileEntryDateTimeTransformSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[FromLocationSID]"
dataType="i4"
name="FromLocationSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[RequestType]"
dataType="wstr"
length="50"
name="RequestType" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[ToStaffSID]"
dataType="i4"
name="ToStaffSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[OrderStatusSID]"
dataType="i4"
name="OrderStatusSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[CPRSOrderSID]"
dataType="i8"
name="CPRSOrderSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[CPRSStatus]"
dataType="wstr"
length="50"
name="CPRSStatus" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[RecentActivityTypeSID]"
dataType="i4"
name="RecentActivityTypeSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[RecentActivityType]"
dataType="wstr"
length="100"
name="RecentActivityType" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[SendingStaffSID]"
dataType="i4"
name="SendingStaffSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[SignificantFindings]"
dataType="wstr"
length="1"
name="SignificantFindings" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[UrgencyProtocolSID]"
dataType="i4"
name="UrgencyProtocolSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[Urgency]"
dataType="wstr"
length="50"
name="Urgency" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[ConsultPlaceProtocolSID]"
dataType="i4"
name="ConsultPlaceProtocolSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[PlaceOfConsultation]"
dataType="wstr"
length="50"
name="PlaceOfConsultation" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[DisplayTextOfItemOrdered]"
dataType="wstr"
length="100"
name="DisplayTextOfItemOrdered" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[OrderingInstitutionSID]"
dataType="i4"
name="OrderingInstitutionSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[OrderingSta3n]"
dataType="i2"
name="OrderingSta3n" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[InpatOutpat]"
dataType="wstr"
length="50"
name="InpatOutpat" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[ProvisionalDiagnosis]"
dataType="wstr"
length="255"
name="ProvisionalDiagnosis" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[ProvisionalDiagnosisCode]"
dataType="wstr"
length="50"
name="ProvisionalDiagnosisCode" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[RemoteRole]"
dataType="wstr"
length="50"
name="RemoteRole" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[RemoteService]"
dataType="wstr"
length="100"
name="RemoteService" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[RemoteConsultInstitutionSID]"
dataType="i4"
name="RemoteConsultInstitutionSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[RemoteConsultSta3n]"
dataType="wstr"
length="50"
name="RemoteConsultSta3n" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[RemoteConsultSID]"
dataType="i8"
name="RemoteConsultSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[TIUDocumentSID]"
dataType="i8"
name="TIUDocumentSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[EarliestDate]"
dataType="dbDate"
name="EarliestDate" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[EarliestVistaErrorDate]"
dataType="wstr"
length="50"
name="EarliestVistaErrorDate" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[EarliestDateTransformSID]"
dataType="i8"
name="EarliestDateTransformSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[ClinicalProcedureIEN]"
dataType="wstr"
length="50"
name="ClinicalProcedureIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[ConsultPlaceProtocolIEN]"
dataType="wstr"
length="50"
name="ConsultPlaceProtocolIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[CPRSOrderIEN]"
dataType="wstr"
length="50"
name="CPRSOrderIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[FromLocationIEN]"
dataType="wstr"
length="50"
name="FromLocationIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[GMRCProcedureIEN]"
dataType="wstr"
length="50"
name="GMRCProcedureIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[OrderingInstitutionIEN]"
dataType="wstr"
length="50"
name="OrderingInstitutionIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[OrderStatusIEN]"
dataType="wstr"
length="50"
name="OrderStatusIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[PatientIEN]"
dataType="wstr"
length="50"
name="PatientIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[PatientLocationIEN]"
dataType="wstr"
length="50"
name="PatientLocationIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[ProtocolIEN]"
dataType="wstr"
length="50"
name="ProtocolIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[RecentActivityTypeIEN]"
dataType="wstr"
length="50"
name="RecentActivityTypeIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[RemoteConsultIEN]"
dataType="wstr"
length="50"
name="RemoteConsultIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[RemoteConsultInstitutionIEN]"
dataType="wstr"
length="50"
name="RemoteConsultInstitutionIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[SendingStaffIEN]"
dataType="wstr"
length="50"
name="SendingStaffIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[TIUDocumentIEN]"
dataType="wstr"
length="50"
name="TIUDocumentIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[ToRequestServiceIEN]"
dataType="wstr"
length="50"
name="ToRequestServiceIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[ToStaffIEN]"
dataType="wstr"
length="50"
name="ToStaffIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[UrgencyProtocolIEN]"
dataType="wstr"
length="50"
name="UrgencyProtocolIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[ResultIEN]"
dataType="wstr"
length="50"
name="ResultIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[ResultSID]"
dataType="i8"
name="ResultSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[ResultPointedToFileNumber]"
dataType="wstr"
length="50"
name="ResultPointedToFileNumber" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[ETLBatchID]"
dataType="i4"
name="ETLBatchID" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[OpCode]"
dataType="wstr"
length="1"
name="OpCode" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[VistaCreateDate]"
dataType="dbTimeStamp"
name="VistaCreateDate" />
<externalMetadataColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output].ExternalColumns[VistaEditDate]"
dataType="dbTimeStamp"
name="VistaEditDate" />
</externalMetadataColumns>
</output>
<output
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output]"
isErrorOut="true"
name="ADO NET Source Error Output">
<outputColumns>
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[ConsultSID]"
dataType="i8"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[ConsultSID]"
name="ConsultSID" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[ConsultIEN]"
dataType="wstr"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[ConsultIEN]"
name="ConsultIEN" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[Sta3n]"
dataType="i2"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[Sta3n]"
name="Sta3n" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[PatientSID]"
dataType="i4"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[PatientSID]"
name="PatientSID" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[PatientLocationSID]"
dataType="i4"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[PatientLocationSID]"
name="PatientLocationSID" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[ProtocolSID]"
dataType="i4"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[ProtocolSID]"
name="ProtocolSID" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[GMRCProcedureSID]"
dataType="i4"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[GMRCProcedureSID]"
name="GMRCProcedureSID" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[GMRCProcedure]"
dataType="wstr"
length="100"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[GMRCProcedure]"
name="GMRCProcedure" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[ClinicalProcedureSID]"
dataType="i4"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[ClinicalProcedureSID]"
name="ClinicalProcedureSID" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[ToRequestServiceSID]"
dataType="i4"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[ToRequestServiceSID]"
name="ToRequestServiceSID" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[ToRequestServiceName]"
dataType="wstr"
length="100"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[ToRequestServiceName]"
name="ToRequestServiceName" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[RequestDateTime]"
dataType="dbTimeStamp2"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[RequestDateTime]"
name="RequestDateTime" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[RequestVistaErrorDate]"
dataType="wstr"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[RequestVistaErrorDate]"
name="RequestVistaErrorDate" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[RequestDateTimeTransformSID]"
dataType="i8"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[RequestDateTimeTransformSID]"
name="RequestDateTimeTransformSID" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[RequestDateSID]"
dataType="i4"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[RequestDateSID]"
name="RequestDateSID" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[FileEntryDateTime]"
dataType="dbTimeStamp2"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[FileEntryDateTime]"
name="FileEntryDateTime" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[FileEntryVistaErrorDate]"
dataType="wstr"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[FileEntryVistaErrorDate]"
name="FileEntryVistaErrorDate" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[FileEntryDateTimeTransformSID]"
dataType="i8"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[FileEntryDateTimeTransformSID]"
name="FileEntryDateTimeTransformSID" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[FromLocationSID]"
dataType="i4"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[FromLocationSID]"
name="FromLocationSID" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[RequestType]"
dataType="wstr"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[RequestType]"
name="RequestType" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[ToStaffSID]"
dataType="i4"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[ToStaffSID]"
name="ToStaffSID" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[OrderStatusSID]"
dataType="i4"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[OrderStatusSID]"
name="OrderStatusSID" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[CPRSOrderSID]"
dataType="i8"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[CPRSOrderSID]"
name="CPRSOrderSID" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[CPRSStatus]"
dataType="wstr"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[CPRSStatus]"
name="CPRSStatus" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[RecentActivityTypeSID]"
dataType="i4"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[RecentActivityTypeSID]"
name="RecentActivityTypeSID" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[RecentActivityType]"
dataType="wstr"
length="100"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[RecentActivityType]"
name="RecentActivityType" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[SendingStaffSID]"
dataType="i4"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[SendingStaffSID]"
name="SendingStaffSID" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[SignificantFindings]"
dataType="wstr"
length="1"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[SignificantFindings]"
name="SignificantFindings" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[UrgencyProtocolSID]"
dataType="i4"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[UrgencyProtocolSID]"
name="UrgencyProtocolSID" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[Urgency]"
dataType="wstr"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[Urgency]"
name="Urgency" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[ConsultPlaceProtocolSID]"
dataType="i4"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[ConsultPlaceProtocolSID]"
name="ConsultPlaceProtocolSID" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[PlaceOfConsultation]"
dataType="wstr"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[PlaceOfConsultation]"
name="PlaceOfConsultation" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[DisplayTextOfItemOrdered]"
dataType="wstr"
length="100"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[DisplayTextOfItemOrdered]"
name="DisplayTextOfItemOrdered" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[OrderingInstitutionSID]"
dataType="i4"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[OrderingInstitutionSID]"
name="OrderingInstitutionSID" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[OrderingSta3n]"
dataType="i2"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[OrderingSta3n]"
name="OrderingSta3n" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[InpatOutpat]"
dataType="wstr"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[InpatOutpat]"
name="InpatOutpat" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[ProvisionalDiagnosis]"
dataType="wstr"
length="255"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[ProvisionalDiagnosis]"
name="ProvisionalDiagnosis" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[ProvisionalDiagnosisCode]"
dataType="wstr"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[ProvisionalDiagnosisCode]"
name="ProvisionalDiagnosisCode" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[RemoteRole]"
dataType="wstr"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[RemoteRole]"
name="RemoteRole" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[RemoteService]"
dataType="wstr"
length="100"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[RemoteService]"
name="RemoteService" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[RemoteConsultInstitutionSID]"
dataType="i4"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[RemoteConsultInstitutionSID]"
name="RemoteConsultInstitutionSID" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[RemoteConsultSta3n]"
dataType="wstr"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[RemoteConsultSta3n]"
name="RemoteConsultSta3n" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[RemoteConsultSID]"
dataType="i8"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[RemoteConsultSID]"
name="RemoteConsultSID" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[TIUDocumentSID]"
dataType="i8"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[TIUDocumentSID]"
name="TIUDocumentSID" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[EarliestDate]"
dataType="dbDate"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[EarliestDate]"
name="EarliestDate" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[EarliestVistaErrorDate]"
dataType="wstr"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[EarliestVistaErrorDate]"
name="EarliestVistaErrorDate" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[EarliestDateTransformSID]"
dataType="i8"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[EarliestDateTransformSID]"
name="EarliestDateTransformSID" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[ClinicalProcedureIEN]"
dataType="wstr"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[ClinicalProcedureIEN]"
name="ClinicalProcedureIEN" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[ConsultPlaceProtocolIEN]"
dataType="wstr"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[ConsultPlaceProtocolIEN]"
name="ConsultPlaceProtocolIEN" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[CPRSOrderIEN]"
dataType="wstr"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[CPRSOrderIEN]"
name="CPRSOrderIEN" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[FromLocationIEN]"
dataType="wstr"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[FromLocationIEN]"
name="FromLocationIEN" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[GMRCProcedureIEN]"
dataType="wstr"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[GMRCProcedureIEN]"
name="GMRCProcedureIEN" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[OrderingInstitutionIEN]"
dataType="wstr"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[OrderingInstitutionIEN]"
name="OrderingInstitutionIEN" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[OrderStatusIEN]"
dataType="wstr"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[OrderStatusIEN]"
name="OrderStatusIEN" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[PatientIEN]"
dataType="wstr"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[PatientIEN]"
name="PatientIEN" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[PatientLocationIEN]"
dataType="wstr"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[PatientLocationIEN]"
name="PatientLocationIEN" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[ProtocolIEN]"
dataType="wstr"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[ProtocolIEN]"
name="ProtocolIEN" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[RecentActivityTypeIEN]"
dataType="wstr"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[RecentActivityTypeIEN]"
name="RecentActivityTypeIEN" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[RemoteConsultIEN]"
dataType="wstr"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[RemoteConsultIEN]"
name="RemoteConsultIEN" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[RemoteConsultInstitutionIEN]"
dataType="wstr"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[RemoteConsultInstitutionIEN]"
name="RemoteConsultInstitutionIEN" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[SendingStaffIEN]"
dataType="wstr"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[SendingStaffIEN]"
name="SendingStaffIEN" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[TIUDocumentIEN]"
dataType="wstr"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[TIUDocumentIEN]"
name="TIUDocumentIEN" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[ToRequestServiceIEN]"
dataType="wstr"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[ToRequestServiceIEN]"
name="ToRequestServiceIEN" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[ToStaffIEN]"
dataType="wstr"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[ToStaffIEN]"
name="ToStaffIEN" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[UrgencyProtocolIEN]"
dataType="wstr"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[UrgencyProtocolIEN]"
name="UrgencyProtocolIEN" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[ResultIEN]"
dataType="wstr"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[ResultIEN]"
name="ResultIEN" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[ResultSID]"
dataType="i8"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[ResultSID]"
name="ResultSID" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[ResultPointedToFileNumber]"
dataType="wstr"
length="50"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[ResultPointedToFileNumber]"
name="ResultPointedToFileNumber" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[ETLBatchID]"
dataType="i4"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[ETLBatchID]"
name="ETLBatchID" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[OpCode]"
dataType="wstr"
length="1"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[OpCode]"
name="OpCode" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[VistaCreateDate]"
dataType="dbTimeStamp"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[VistaCreateDate]"
name="VistaCreateDate" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[VistaEditDate]"
dataType="dbTimeStamp"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[VistaEditDate]"
name="VistaEditDate" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[ErrorCode]"
dataType="i4"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[ErrorCode]"
name="ErrorCode"
specialFlags="1" />
<outputColumn
refId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[ErrorColumn]"
dataType="i4"
lineageId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Error Output].Columns[ErrorColumn]"
name="ErrorColumn"
specialFlags="2" />
</outputColumns>
<externalMetadataColumns />
</output>
</outputs>
</component>
<component
refId="Package\Data Flow Task\Derived Column"
componentClassID="Microsoft.DerivedColumn"
contactInfo="Derived Column;Microsoft Corporation; Microsoft SQL Server; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;0"
description="Creates new column values by applying expressions to transformation input columns. Create new columns or overwrite existing ones. For example, concatenate the values from the 'first name' and 'last name' column to make a 'full name' column."
name="Derived Column"
usesDispositions="true">
<inputs>
<input
refId="Package\Data Flow Task\Derived Column.Inputs[Derived Column Input]"
description="Input to the Derived Column Transformation"
name="Derived Column Input">
<externalMetadataColumns />
</input>
</inputs>
<outputs>
<output
refId="Package\Data Flow Task\Derived Column.Outputs[Derived Column Output]"
description="Default Output of the Derived Column Transformation"
exclusionGroup="1"
name="Derived Column Output"
synchronousInputId="Package\Data Flow Task\Derived Column.Inputs[Derived Column Input]">
<outputColumns>
<outputColumn
refId="Package\Data Flow Task\Derived Column.Outputs[Derived Column Output].Columns[BatchLogID]"
dataType="i8"
errorOrTruncationOperation="Computation"
errorRowDisposition="FailComponent"
lineageId="Package\Data Flow Task\Derived Column.Outputs[Derived Column Output].Columns[BatchLogID]"
name="BatchLogID"
truncationRowDisposition="FailComponent">
<properties>
<property
containsID="true"
dataType="System.String"
description="Derived Column Expression"
name="Expression">@[User::batchLogId]</property>
<property
containsID="true"
dataType="System.String"
description="Derived Column Friendly Expression"
expressionType="Notify"
name="FriendlyExpression">@[User::batchLogId]</property>
</properties>
</outputColumn>
</outputColumns>
<externalMetadataColumns />
</output>
<output
refId="Package\Data Flow Task\Derived Column.Outputs[Derived Column Error Output]"
description="Error Output of the Derived Column Transformation"
exclusionGroup="1"
isErrorOut="true"
name="Derived Column Error Output"
synchronousInputId="Package\Data Flow Task\Derived Column.Inputs[Derived Column Input]">
<outputColumns>
<outputColumn
refId="Package\Data Flow Task\Derived Column.Outputs[Derived Column Error Output].Columns[ErrorCode]"
dataType="i4"
lineageId="Package\Data Flow Task\Derived Column.Outputs[Derived Column Error Output].Columns[ErrorCode]"
name="ErrorCode"
specialFlags="1" />
<outputColumn
refId="Package\Data Flow Task\Derived Column.Outputs[Derived Column Error Output].Columns[ErrorColumn]"
dataType="i4"
lineageId="Package\Data Flow Task\Derived Column.Outputs[Derived Column Error Output].Columns[ErrorColumn]"
name="ErrorColumn"
specialFlags="2" />
</outputColumns>
<externalMetadataColumns />
</output>
</outputs>
</component>
</components>
<paths>
<path
refId="Package\Data Flow Task.Paths[ADO NET Source Output]"
endId="Package\Data Flow Task\Derived Column.Inputs[Derived Column Input]"
name="ADO NET Source Output"
startId="Package\Data Flow Task\ADO NET Source.Outputs[ADO NET Source Output]" />
<path
refId="Package\Data Flow Task.Paths[Derived Column Output]"
endId="Package\Data Flow Task\ADO NET Destination.Inputs[ADO NET Destination Input]"
name="Derived Column Output"
startId="Package\Data Flow Task\Derived Column.Outputs[Derived Column Output]" />
</paths>
</pipeline>
</DTS:ObjectData>
</DTS:Executable>
<DTS:Executable
DTS:refId="Package\Do Delete Raw for BatchLogID in case of existing recs for that batch"
DTS:CreationName="Microsoft.ExecuteSQLTask"
DTS:Description="Execute SQL Task"
DTS:DTSID="{15BDCB90-E389-4DE8-8CB7-81C0A86517D7}"
DTS:ExecutableType="Microsoft.ExecuteSQLTask"
DTS:LocaleID="-1"
DTS:ObjectName="Do Delete Raw for BatchLogID in case of existing recs for that batch"
DTS:TaskContact="Execute SQL Task; Microsoft Corporation; SQL Server 2016; © 2015 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1"
DTS:ThreadHint="0">
<DTS:Variables />
<DTS:ObjectData>
<SQLTask:SqlTaskData
SQLTask:Connection="{357B8BF8-C32A-44A8-B818-929F68D4ED41}"
SQLTask:SqlStatementSource="&#x9;&#x9;EXEC uspDoDeleteRaw @batchLogId, @rawTableName, @resultOK OUTPUT;"
SQLTask:ResultType="ResultSetType_SingleRow" xmlns:SQLTask="www.microsoft.com/sqlserver/dts/tasks/sqltask">
<SQLTask:ResultBinding
SQLTask:ResultName="0"
SQLTask:DtsVariableName="User::resultOK" />
<SQLTask:ParameterBinding
SQLTask:ParameterName="@batchLogId"
SQLTask:DtsVariableName="User::batchLogId"
SQLTask:ParameterDirection="Input"
SQLTask:DataType="12"
SQLTask:ParameterSize="-1" />
<SQLTask:ParameterBinding
SQLTask:ParameterName="@rawTableName"
SQLTask:DtsVariableName="User::rawTableName"
SQLTask:ParameterDirection="Input"
SQLTask:DataType="16"
SQLTask:ParameterSize="-1" />
<SQLTask:ParameterBinding
SQLTask:ParameterName="@resultOK"
SQLTask:DtsVariableName="User::resultOK"
SQLTask:ParameterDirection="Output"
SQLTask:DataType="11"
SQLTask:ParameterSize="-1" />
</SQLTask:SqlTaskData>
</DTS:ObjectData>
</DTS:Executable>
<DTS:Executable
DTS:refId="Package\Get Max Source Batch ID and Batch Count"
DTS:CreationName="Microsoft.ExecuteSQLTask"
DTS:Description="Execute SQL Task"
DTS:DTSID="{82B1E518-D03F-430D-B889-0F5CDB77BF0C}"
DTS:ExecutableType="Microsoft.ExecuteSQLTask"
DTS:LocaleID="-1"
DTS:ObjectName="Get Max Source Batch ID and Batch Count"
DTS:TaskContact="Execute SQL Task; Microsoft Corporation; SQL Server 2016; © 2015 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1"
DTS:ThreadHint="0">
<DTS:Variables />
<DTS:ObjectData>
<SQLTask:SqlTaskData
SQLTask:Connection="{C36C046C-119A-42DF-B4BF-808D36A34544}"
SQLTask:SqlStatementSource="SELECT COUNT(1) AS BatchRecordCount, &#xA;IsNull(Max(ETLBatchID), 0) AS MaxSourceBatchNumber&#xA;FROM zraw._conConsultspv&#xA;WHERE BatchLogID = ?"
SQLTask:ResultType="ResultSetType_SingleRow" xmlns:SQLTask="www.microsoft.com/sqlserver/dts/tasks/sqltask">
<SQLTask:ResultBinding
SQLTask:ResultName="MaxSourceBatchNumber"
SQLTask:DtsVariableName="User::maxSourceBatchNumber" />
<SQLTask:ResultBinding
SQLTask:ResultName="BatchRecordCount"
SQLTask:DtsVariableName="User::batchRecordCount" />
<SQLTask:ParameterBinding
SQLTask:ParameterName="@batchLogId"
SQLTask:DtsVariableName="User::batchLogId"
SQLTask:ParameterDirection="Input"
SQLTask:DataType="3"
SQLTask:ParameterSize="-1" />
</SQLTask:SqlTaskData>
</DTS:ObjectData>
</DTS:Executable>
<DTS:Executable
DTS:refId="Package\Sequence Container"
DTS:CreationName="STOCK:SEQUENCE"
DTS:Description="Sequence Container"
DTS:DTSID="{7E730892-CD78-43F4-A8CC-E1885433B08E}"
DTS:ExecutableType="STOCK:SEQUENCE"
DTS:LocaleID="-1"
DTS:ObjectName="Sequence Container">
<DTS:Variables />
<DTS:Executables>
<DTS:Executable
DTS:refId="Package\Sequence Container\Get Batch Log ID"
DTS:CreationName="Microsoft.ExecuteSQLTask"
DTS:Description="Execute SQL Task"
DTS:DTSID="{AE7CD660-1BA8-4765-A297-DC194B2DBDC0}"
DTS:ExecutableType="Microsoft.ExecuteSQLTask"
DTS:LocaleID="-1"
DTS:ObjectName="Get Batch Log ID"
DTS:TaskContact="Execute SQL Task; Microsoft Corporation; SQL Server 2016; © 2015 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1"
DTS:ThreadHint="0">
<DTS:Variables />
<DTS:ObjectData>
<SQLTask:SqlTaskData
SQLTask:Connection="{357B8BF8-C32A-44A8-B818-929F68D4ED41}"
SQLTask:SqlStatementSource="EXEC uspSetBatchLogsReadyforBatchYD @rawTableName, @batchLogId OUTPUT" xmlns:SQLTask="www.microsoft.com/sqlserver/dts/tasks/sqltask">
<SQLTask:ParameterBinding
SQLTask:ParameterName="@batchLogId"
SQLTask:DtsVariableName="User::batchLogId"
SQLTask:ParameterDirection="Output"
SQLTask:DataType="12"
SQLTask:ParameterSize="-1" />
<SQLTask:ParameterBinding
SQLTask:ParameterName="@rawTableName"
SQLTask:DtsVariableName="User::rawTableName"
SQLTask:ParameterDirection="Input"
SQLTask:DataType="16"
SQLTask:ParameterSize="-1" />
</SQLTask:SqlTaskData>
</DTS:ObjectData>
</DTS:Executable>
<DTS:Executable
DTS:refId="Package\Sequence Container\Get Prior Max Source Batch ID"
DTS:CreationName="Microsoft.ExecuteSQLTask"
DTS:Description="Execute SQL Task"
DTS:DTSID="{F86D0F10-CBDD-407E-8AC4-5F08182DDC0A}"
DTS:ExecutableType="Microsoft.ExecuteSQLTask"
DTS:LocaleID="-1"
DTS:ObjectName="Get Prior Max Source Batch ID"
DTS:TaskContact="Execute SQL Task; Microsoft Corporation; SQL Server 2016; © 2015 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1"
DTS:ThreadHint="1">
<DTS:Variables />
<DTS:ObjectData>
<SQLTask:SqlTaskData
SQLTask:Connection="{357B8BF8-C32A-44A8-B818-929F68D4ED41}"
SQLTask:SqlStatementSource="SELECT MAX(SourceBatchNumber) AS PriorSourceBatchNumber&#xA;FROM dbo.BatchLogs&#xA;WHERE TableName = @rawTableName&#xA;AND LoadStatus In('EXTCOMPLETE','INTCOMPLETE','INTPROCESSING')"
SQLTask:ResultType="ResultSetType_SingleRow" xmlns:SQLTask="www.microsoft.com/sqlserver/dts/tasks/sqltask">
<SQLTask:ResultBinding
SQLTask:ResultName="0"
SQLTask:DtsVariableName="User::priorSourceBatchNumber" />
<SQLTask:ParameterBinding
SQLTask:ParameterName="@rawTableName"
SQLTask:DtsVariableName="User::rawTableName"
SQLTask:ParameterDirection="Input"
SQLTask:DataType="16"
SQLTask:ParameterSize="-1" />
</SQLTask:SqlTaskData>
</DTS:ObjectData>
</DTS:Executable>
</DTS:Executables>
</DTS:Executable>
<DTS:Executable
DTS:refId="Package\Set Batch Log Status"
DTS:CreationName="Microsoft.ExecuteSQLTask"
DTS:Description="Execute SQL Task"
DTS:DTSID="{7FD464FE-2DB2-4C5F-B813-E35F6257EB87}"
DTS:ExecutableType="Microsoft.ExecuteSQLTask"
DTS:LocaleID="-1"
DTS:ObjectName="Set Batch Log Status"
DTS:TaskContact="Execute SQL Task; Microsoft Corporation; SQL Server 2016; © 2015 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1"
DTS:ThreadHint="0">
<DTS:Variables />
<DTS:ObjectData>
<SQLTask:SqlTaskData
SQLTask:Connection="{357B8BF8-C32A-44A8-B818-929F68D4ED41}"
SQLTask:SqlStatementSource="EXEC uspSetBatchLogStatus @batchLogId, @batchRecordCount, @maxSourceBatchNumber, @loadStatus;" xmlns:SQLTask="www.microsoft.com/sqlserver/dts/tasks/sqltask">
<SQLTask:ParameterBinding
SQLTask:ParameterName="@batchLogId"
SQLTask:DtsVariableName="User::batchLogId"
SQLTask:ParameterDirection="Input"
SQLTask:DataType="12"
SQLTask:ParameterSize="-1" />
<SQLTask:ParameterBinding
SQLTask:ParameterName="@batchRecordCount"
SQLTask:DtsVariableName="User::batchRecordCount"
SQLTask:ParameterDirection="Input"
SQLTask:DataType="12"
SQLTask:ParameterSize="-1" />
<SQLTask:ParameterBinding
SQLTask:ParameterName="@maxSourceBatchNumber"
SQLTask:DtsVariableName="User::maxSourceBatchNumber"
SQLTask:ParameterDirection="Input"
SQLTask:DataType="12"
SQLTask:ParameterSize="-1" />
<SQLTask:ParameterBinding
SQLTask:ParameterName="@loadStatus"
SQLTask:DtsVariableName="User::loadStatusComplete"
SQLTask:ParameterDirection="Input"
SQLTask:DataType="16"
SQLTask:ParameterSize="-1" />
</SQLTask:SqlTaskData>
</DTS:ObjectData>
</DTS:Executable>
<DTS:Executable
DTS:refId="Package\Set BatchLogs EXTERROR"
DTS:CreationName="Microsoft.ExecuteSQLTask"
DTS:Description="Execute SQL Task"
DTS:DTSID="{0229A576-C0F1-451B-9FC5-F843428F1C18}"
DTS:ExecutableType="Microsoft.ExecuteSQLTask"
DTS:LocaleID="-1"
DTS:ObjectName="Set BatchLogs EXTERROR"
DTS:TaskContact="Execute SQL Task; Microsoft Corporation; SQL Server 2016; © 2015 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1"
DTS:ThreadHint="1">
<DTS:Variables />
<DTS:ObjectData>
<SQLTask:SqlTaskData
SQLTask:Connection="{357B8BF8-C32A-44A8-B818-929F68D4ED41}"
SQLTask:SqlStatementSource="EXEC uspSetBatchLogStatus @batchLogId, @batchRecordCount, @maxSourceBatchNumber, @loadStatus;" xmlns:SQLTask="www.microsoft.com/sqlserver/dts/tasks/sqltask">
<SQLTask:ParameterBinding
SQLTask:ParameterName="@batchLogId"
SQLTask:DtsVariableName="User::batchLogId"
SQLTask:ParameterDirection="Input"
SQLTask:DataType="12"
SQLTask:ParameterSize="-1" />
<SQLTask:ParameterBinding
SQLTask:ParameterName="@batchRecordCount"
SQLTask:DtsVariableName="User::batchRecordCount"
SQLTask:ParameterDirection="Input"
SQLTask:DataType="12"
SQLTask:ParameterSize="-1" />
<SQLTask:ParameterBinding
SQLTask:ParameterName="@maxSourceBatchNumber"
SQLTask:DtsVariableName="User::maxSourceBatchNumber"
SQLTask:ParameterDirection="Input"
SQLTask:DataType="12"
SQLTask:ParameterSize="-1" />
<SQLTask:ParameterBinding
SQLTask:ParameterName="@loadStatus"
SQLTask:DtsVariableName="User::loadStatusError"
SQLTask:ParameterDirection="Input"
SQLTask:DataType="16"
SQLTask:ParameterSize="-1" />
</SQLTask:SqlTaskData>
</DTS:ObjectData>
</DTS:Executable>
</DTS:Executables>
<DTS:PrecedenceConstraints>
<DTS:PrecedenceConstraint
DTS:refId="Package.PrecedenceConstraints[Constraint]"
DTS:CreationName=""
DTS:DTSID="{945DD348-E714-4DD2-92E2-587317EF09C2}"
DTS:EvalOp="1"
DTS:Expression="@[User::batchLogId] &gt; 0"
DTS:From="Package\Sequence Container"
DTS:LogicalAnd="True"
DTS:ObjectName="Constraint"
DTS:To="Package\Do Delete Raw for BatchLogID in case of existing recs for that batch" />
<DTS:PrecedenceConstraint
DTS:refId="Package.PrecedenceConstraints[Constraint 1]"
DTS:CreationName=""
DTS:DTSID="{9A2C8DEB-00D6-40A9-B4DA-3C3FBF80E478}"
DTS:From="Package\Data Flow Task"
DTS:LogicalAnd="True"
DTS:ObjectName="Constraint 1"
DTS:To="Package\Get Max Source Batch ID and Batch Count" />
<DTS:PrecedenceConstraint
DTS:refId="Package.PrecedenceConstraints[Constraint 2]"
DTS:CreationName=""
DTS:DTSID="{C3D4C9AC-D942-4FFD-8CF3-934D2EB82E5F}"
DTS:From="Package\Get Max Source Batch ID and Batch Count"
DTS:LogicalAnd="True"
DTS:ObjectName="Constraint 2"
DTS:To="Package\Set Batch Log Status" />
<DTS:PrecedenceConstraint
DTS:refId="Package.PrecedenceConstraints[Constraint 3]"
DTS:CreationName=""
DTS:DTSID="{1619EF4C-EAAA-44E3-9775-F6E5DA5E3A09}"
DTS:From="Package\Data Flow Task"
DTS:LogicalAnd="True"
DTS:ObjectName="Constraint 3"
DTS:To="Package\Set BatchLogs EXTERROR"
DTS:Value="1" />
<DTS:PrecedenceConstraint
DTS:refId="Package.PrecedenceConstraints[Constraint 4]"
DTS:CreationName=""
DTS:DTSID="{CAB1A948-91BF-4280-971D-A828410B392D}"
DTS:From="Package\Do Delete Raw for BatchLogID in case of existing recs for that batch"
DTS:LogicalAnd="True"
DTS:ObjectName="Constraint 4"
DTS:To="Package\Data Flow Task" />
<DTS:PrecedenceConstraint
DTS:refId="Package.PrecedenceConstraints[Constraint 5]"
DTS:CreationName=""
DTS:DTSID="{99C89550-9380-423F-B05A-52669E33D53E}"
DTS:From="Package\Do Delete Raw for BatchLogID in case of existing recs for that batch"
DTS:LogicalAnd="True"
DTS:ObjectName="Constraint 5"
DTS:To="Package\Set BatchLogs EXTERROR"
DTS:Value="1" />
</DTS:PrecedenceConstraints>
<DTS:DesignTimeProperties><![CDATA[<?xml version="1.0"?>
<!--This CDATA section contains the layout information of the package. The section includes information such as (x,y) coordinates, width, and height.-->
<!--If you manually edit this section and make a mistake, you can delete it. -->
<!--The package will still be able to load normally but the previous layout information will be lost and the designer will automatically re-arrange the elements on the design surface.-->
<Objects
Version="8">
<!--Each node below will contain properties that do not affect runtime behavior.-->
<Package
design-time-name="Package">
<LayoutInfo>
<GraphLayout
Capacity="16" xmlns="clr-namespace:Microsoft.SqlServer.IntegrationServices.Designer.Model.Serialization;assembly=Microsoft.SqlServer.IntegrationServices.Graph" xmlns:mssgle="clr-namespace:Microsoft.SqlServer.Graph.LayoutEngine;assembly=Microsoft.SqlServer.Graph" xmlns:assembly="http://schemas.microsoft.com/winfx/2006/xaml" xmlns:mssgm="clr-namespace:Microsoft.SqlServer.Graph.Model;assembly=Microsoft.SqlServer.Graph">
<NodeLayout
Size="153,42"
Id="Package\Data Flow Task"
TopLeft="337,225" />
<NodeLayout
Size="220,73"
Id="Package\Do Delete Raw for BatchLogID in case of existing recs for that batch"
TopLeft="354,57" />
<NodeLayout
Size="281,42"
Id="Package\Get Max Source Batch ID and Batch Count"
TopLeft="343,308" />
<NodeLayout
Size="162,42"
Id="Package\Sequence Container\Get Batch Log ID"
TopLeft="52,23" />
<NodeLayout
Size="224,42"
Id="Package\Sequence Container\Get Prior Max Source Batch ID"
TopLeft="35,92" />
<ContainerLayout
HeaderHeight="43"
IsExpanded="True"
PanelSize="269,180"
Size="269,223"
Id="Package\Sequence Container"
TopLeft="16,41" />
<NodeLayout
Size="179,42"
Id="Package\Set Batch Log Status"
TopLeft="300,397" />
<NodeLayout
Size="203,42"
Id="Package\Set BatchLogs EXTERROR"
TopLeft="515,239" />
<EdgeLayout
Id="Package.PrecedenceConstraints[Constraint]"
TopLeft="285,152.5">
<EdgeLayout.Curve>
<mssgle:Curve
StartConnector="{assembly:Null}"
EndConnector="69,-59"
Start="0,0"
End="61.5,-59">
<mssgle:Curve.Segments>
<mssgle:SegmentCollection
Capacity="5">
<mssgle:LineSegment
End="30.5,0" />
<mssgle:CubicBezierSegment
Point1="30.5,0"
Point2="34.5,0"
Point3="34.5,-4" />
<mssgle:LineSegment
End="34.5,-55" />
<mssgle:CubicBezierSegment
Point1="34.5,-55"
Point2="34.5,-59"
Point3="38.5,-59" />
<mssgle:LineSegment
End="61.5,-59" />
</mssgle:SegmentCollection>
</mssgle:Curve.Segments>
</mssgle:Curve>
</EdgeLayout.Curve>
<EdgeLayout.Labels>
<mssgm:EdgeLabel
BoundingBox="26.5,1,16,16"
RelativePosition="Any" />
</EdgeLayout.Labels>
</EdgeLayout>
<EdgeLayout
Id="Package.PrecedenceConstraints[Constraint 1]"
TopLeft="413.5,267">
<EdgeLayout.Curve>
<mssgle:Curve
StartConnector="{assembly:Null}"
EndConnector="70,41"
Start="0,0"
End="70,33.5">
<mssgle:Curve.Segments>
<mssgle:SegmentCollection
Capacity="5">
<mssgle:LineSegment
End="0,16.5" />
<mssgle:CubicBezierSegment
Point1="0,16.5"
Point2="0,20.5"
Point3="4,20.5" />
<mssgle:LineSegment
End="66,20.5" />
<mssgle:CubicBezierSegment
Point1="66,20.5"
Point2="70,20.5"
Point3="70,24.5" />
<mssgle:LineSegment
End="70,33.5" />
</mssgle:SegmentCollection>
</mssgle:Curve.Segments>
</mssgle:Curve>
</EdgeLayout.Curve>
<EdgeLayout.Labels>
<EdgeLabelCollection />
</EdgeLayout.Labels>
</EdgeLayout>
<EdgeLayout
Id="Package.PrecedenceConstraints[Constraint 2]"
TopLeft="483.5,350">
<EdgeLayout.Curve>
<mssgle:Curve
StartConnector="{assembly:Null}"
EndConnector="-94,47"
Start="0,0"
End="-94,39.5">
<mssgle:Curve.Segments>
<mssgle:SegmentCollection
Capacity="5">
<mssgle:LineSegment
End="0,19.5" />
<mssgle:CubicBezierSegment
Point1="0,19.5"
Point2="0,23.5"
Point3="-4,23.5" />
<mssgle:LineSegment
End="-90,23.5" />
<mssgle:CubicBezierSegment
Point1="-90,23.5"
Point2="-94,23.5"
Point3="-94,27.5" />
<mssgle:LineSegment
End="-94,39.5" />
</mssgle:SegmentCollection>
</mssgle:Curve.Segments>
</mssgle:Curve>
</EdgeLayout.Curve>
<EdgeLayout.Labels>
<EdgeLabelCollection />
</EdgeLayout.Labels>
</EdgeLayout>
<EdgeLayout
Id="Package.PrecedenceConstraints[Constraint 3]"
TopLeft="490,246">
<EdgeLayout.Curve>
<mssgle:Curve
StartConnector="{assembly:Null}"
EndConnector="25,14"
Start="0,0"
End="17.5,14">
<mssgle:Curve.Segments>
<mssgle:SegmentCollection
Capacity="5">
<mssgle:LineSegment
End="8.5,0" />
<mssgle:CubicBezierSegment
Point1="8.5,0"
Point2="12.5,0"
Point3="12.5,4" />
<mssgle:LineSegment
End="12.5,10" />
<mssgle:CubicBezierSegment
Point1="12.5,10"
Point2="12.5,14"
Point3="16.5,14" />
<mssgle:LineSegment
End="17.5,14" />
</mssgle:SegmentCollection>
</mssgle:Curve.Segments>
</mssgle:Curve>
</EdgeLayout.Curve>
<EdgeLayout.Labels>
<mssgm:EdgeLabel
BoundingBox="-2.74134765625,-15.7490234375,30.4826953125,9.7490234375"
RelativePosition="Any" />
</EdgeLayout.Labels>
</EdgeLayout>
<EdgeLayout
Id="Package.PrecedenceConstraints[Constraint 4]"
TopLeft="428.666666666667,130">
<EdgeLayout.Curve>
<mssgle:Curve
StartConnector="{assembly:Null}"
EndConnector="-15.1666666666666,95"
Start="0,0"
End="-15.1666666666666,87.5">
<mssgle:Curve.Segments>
<mssgle:SegmentCollection
Capacity="5">
<mssgle:LineSegment
End="0,34.4115523465704" />
<mssgle:CubicBezierSegment
Point1="0,34.4115523465704"
Point2="0,38.4115523465704"
Point3="-4,38.4115523465704" />
<mssgle:LineSegment
End="-11.1666666666666,38.4115523465704" />
<mssgle:CubicBezierSegment
Point1="-11.1666666666666,38.4115523465704"
Point2="-15.1666666666666,38.4115523465704"
Point3="-15.1666666666666,42.4115523465704" />
<mssgle:LineSegment
End="-15.1666666666666,87.5" />
</mssgle:SegmentCollection>
</mssgle:Curve.Segments>
</mssgle:Curve>
</EdgeLayout.Curve>
<EdgeLayout.Labels>
<EdgeLabelCollection />
</EdgeLayout.Labels>
</EdgeLayout>
<EdgeLayout
Id="Package.PrecedenceConstraints[Constraint 5]"
TopLeft="499.333333333333,130">
<EdgeLayout.Curve>
<mssgle:Curve
StartConnector="{assembly:Null}"
EndConnector="117.166666666667,109"
Start="0,0"
End="117.166666666667,101.5">
<mssgle:Curve.Segments>
<mssgle:SegmentCollection
Capacity="5">
<mssgle:LineSegment
End="0,40.072202166065" />
<mssgle:CubicBezierSegment
Point1="0,40.072202166065"
Point2="0,44.072202166065"
Point3="4,44.072202166065" />
<mssgle:LineSegment
End="113.166666666667,44.072202166065" />
<mssgle:CubicBezierSegment
Point1="113.166666666667,44.072202166065"
Point2="117.166666666667,44.072202166065"
Point3="117.166666666667,48.072202166065" />
<mssgle:LineSegment
End="117.166666666667,101.5" />
</mssgle:SegmentCollection>
</mssgle:Curve.Segments>
</mssgle:Curve>
</EdgeLayout.Curve>
<EdgeLayout.Labels>
<mssgm:EdgeLabel
BoundingBox="43.3419856770835,49.072202166065,30.4826953125,9.7490234375"
RelativePosition="Any" />
</EdgeLayout.Labels>
</EdgeLayout>
<AnnotationLayout
Text="There is still probably room for improvement on the error handling."
ParentId="Package"
FontInfo="{assembly:Null}"
Size="387,40"
Id="93b4425d-3980-4d2a-a138-cd2143f374e8"
TopLeft="318,16" />
</GraphLayout>
</LayoutInfo>
</Package>
<TaskHost
design-time-name="Package\Data Flow Task">
<LayoutInfo>
<GraphLayout
Capacity="8" xmlns="clr-namespace:Microsoft.SqlServer.IntegrationServices.Designer.Model.Serialization;assembly=Microsoft.SqlServer.IntegrationServices.Graph" xmlns:mssgle="clr-namespace:Microsoft.SqlServer.Graph.LayoutEngine;assembly=Microsoft.SqlServer.Graph" xmlns:assembly="http://schemas.microsoft.com/winfx/2006/xaml">
<NodeLayout
Size="156,42"
Id="Package\Data Flow Task\Derived Column"
TopLeft="340,119" />
<NodeLayout
Size="160,42"
Id="Package\Data Flow Task\ADO NET Source"
TopLeft="146,179" />
<NodeLayout
Size="181,42"
Id="Package\Data Flow Task\ADO NET Destination"
TopLeft="421,194" />
<EdgeLayout
Id="Package\Data Flow Task.Paths[Derived Column Output]"
TopLeft="418,161">
<EdgeLayout.Curve>
<mssgle:Curve
StartConnector="{assembly:Null}"
EndConnector="93.5,33"
Start="0,0"
End="93.5,25.5">
<mssgle:Curve.Segments>
<mssgle:SegmentCollection
Capacity="5">
<mssgle:LineSegment
End="0,12.5" />
<mssgle:CubicBezierSegment
Point1="0,12.5"
Point2="0,16.5"
Point3="4,16.5" />
<mssgle:LineSegment
End="89.5,16.5" />
<mssgle:CubicBezierSegment
Point1="89.5,16.5"
Point2="93.5,16.5"
Point3="93.5,20.5" />
<mssgle:LineSegment
End="93.5,25.5" />
</mssgle:SegmentCollection>
</mssgle:Curve.Segments>
</mssgle:Curve>
</EdgeLayout.Curve>
<EdgeLayout.Labels>
<EdgeLabelCollection />
</EdgeLayout.Labels>
</EdgeLayout>
<EdgeLayout
Id="Package\Data Flow Task.Paths[ADO NET Source Output]"
TopLeft="306,200">
<EdgeLayout.Curve>
<mssgle:Curve
StartConnector="{assembly:Null}"
EndConnector="34,-60"
Start="0,0"
End="26.5,-60">
<mssgle:Curve.Segments>
<mssgle:SegmentCollection
Capacity="5">
<mssgle:LineSegment
End="13,0" />
<mssgle:CubicBezierSegment
Point1="13,0"
Point2="17,0"
Point3="17,-4" />
<mssgle:LineSegment
End="17,-56" />
<mssgle:CubicBezierSegment
Point1="17,-56"
Point2="17,-60"
Point3="21,-60" />
<mssgle:LineSegment
End="26.5,-60" />
</mssgle:SegmentCollection>
</mssgle:Curve.Segments>
</mssgle:Curve>
</EdgeLayout.Curve>
<EdgeLayout.Labels>
<EdgeLabelCollection />
</EdgeLayout.Labels>
</EdgeLayout>
</GraphLayout>
</LayoutInfo>
</TaskHost>
<PipelineComponentMetadata
design-time-name="Package\Data Flow Task\ADO NET Source">
<Properties>
<Property>
<Name>DataSourceViewID</Name>
</Property>
</Properties>
</PipelineComponentMetadata>
<PipelineComponentMetadata
design-time-name="Package\Data Flow Task\ADO NET Destination">
<Properties>
<Property>
<Name>DataSourceViewID</Name>
</Property>
</Properties>
</PipelineComponentMetadata>
</Objects>]]></DTS:DesignTimeProperties>
</DTS:Executable>