Summary Table

Categories Total Count
PII 1
URL 6
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="{B6B39D6E-BEB8-4197-B450-44AF3FF8A608}"
DTS:ExecutableType="Microsoft.Package"
DTS:LastModifiedProductVersion="14.0.3002.68"
DTS:LocaleID="1033"
DTS:ObjectName="_DONTUSEextChildADONetFlowPkgConsult"
DTS:PackageType="5"
DTS:ProtectionLevel="0"
DTS:VersionBuild="110"
DTS:VersionGUID="{12C05736-65C0-42C4-B9B4-64FE2B1724F0}">
<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\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>
<component
refId="Package\Data Flow Task\OLE DB Destination"
componentClassID="Microsoft.OLEDBDestination"
contactInfo="OLE DB Destination;Microsoft Corporation; Microsoft SQL Server; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;4"
description="OLE DB Destination"
name="OLE DB Destination"
usesDispositions="true"
version="4">
<properties>
<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">0</property>
<property
dataType="System.String"
description="Specifies the name of the database object used to open a rowset."
name="OpenRowset">[zraw].[_conConsultspv]</property>
<property
dataType="System.String"
description="Specifies the variable that contains the name of the database object used to open a rowset."
name="OpenRowsetVariable"></property>
<property
dataType="System.String"
description="The SQL command to be executed."
name="SqlCommand"
UITypeEditor="Microsoft.DataTransformationServices.Controls.ModalMultilineStringEditor, Microsoft.DataTransformationServices.Controls, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"></property>
<property
dataType="System.Int32"
description="Specifies the column code page to use when code page information is unavailable from the data source."
name="DefaultCodePage">1252</property>
<property
dataType="System.Boolean"
description="Forces the use of the DefaultCodePage property value when describing character data."
name="AlwaysUseDefaultCodePage">false</property>
<property
dataType="System.Int32"
description="Specifies the mode used to access the database."
name="AccessMode"
typeConverter="AccessMode">3</property>
<property
dataType="System.Boolean"
description="Indicates whether the values supplied for identity columns will be copied to the destination. If false, values for identity columns will be auto-generated at the destination. Applies only if fast load is turned on."
name="FastLoadKeepIdentity">false</property>
<property
dataType="System.Boolean"
description="Indicates whether the columns containing null will have null inserted in the destination. If false, columns containing null will have their default values inserted at the destination. Applies only if fast load is turned on."
name="FastLoadKeepNulls">true</property>
<property
dataType="System.String"
description="Specifies options to be used with fast load. Applies only if fast load is turned on."
name="FastLoadOptions">TABLOCK,CHECK_CONSTRAINTS</property>
<property
dataType="System.Int32"
description="Specifies when commits are issued during data insertion. A value of 0 specifies that one commit will be issued at the end of data insertion. Applies only if fast load is turned on."
name="FastLoadMaxInsertCommitSize">2147483647</property>
</properties>
<connections>
<connection
refId="Package\Data Flow Task\OLE DB Destination.Connections[OleDbConnection]"
connectionManagerID="Package.ConnectionManagers[
URL .EPRS_Shadow]"
connectionManagerRefId="Package.ConnectionManagers[
URL .EPRS_Shadow]"
description="The OLE DB runtime connection used to access the database."
name="OleDbConnection" />
</connections>
<inputs>
<input
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input]"
errorOrTruncationOperation="Insert"
errorRowDisposition="FailComponent"
hasSideEffects="true"
name="OLE DB Destination Input">
<inputColumns>
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[ConsultSID]"
cachedDataType="i8"
cachedName="ConsultSID"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ConsultSID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ConsultSID]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[ConsultIEN]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="ConsultIEN"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ConsultIEN]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ConsultIEN]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[Sta3n]"
cachedDataType="i2"
cachedName="Sta3n"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[Sta3n]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[Sta3n]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[PatientSID]"
cachedDataType="i4"
cachedName="PatientSID"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[PatientSID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[PatientSID]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[PatientLocationSID]"
cachedDataType="i4"
cachedName="PatientLocationSID"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[PatientLocationSID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[PatientLocationSID]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[ProtocolSID]"
cachedDataType="i4"
cachedName="ProtocolSID"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ProtocolSID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ProtocolSID]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[GMRCProcedureSID]"
cachedDataType="i4"
cachedName="GMRCProcedureSID"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[GMRCProcedureSID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[GMRCProcedureSID]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[GMRCProcedure]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="100"
cachedName="GMRCProcedure"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[GMRCProcedure]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[GMRCProcedure]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[ClinicalProcedureSID]"
cachedDataType="i4"
cachedName="ClinicalProcedureSID"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ClinicalProcedureSID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ClinicalProcedureSID]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[ToRequestServiceSID]"
cachedDataType="i4"
cachedName="ToRequestServiceSID"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ToRequestServiceSID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ToRequestServiceSID]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[ToRequestServiceName]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="100"
cachedName="ToRequestServiceName"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ToRequestServiceName]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ToRequestServiceName]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[RequestDateTime]"
cachedDataType="dbTimeStamp2"
cachedName="RequestDateTime"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RequestDateTime]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[RequestDateTime]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[RequestVistaErrorDate]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="RequestVistaErrorDate"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RequestVistaErrorDate]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[RequestVistaErrorDate]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[RequestDateTimeTransformSID]"
cachedDataType="i8"
cachedName="RequestDateTimeTransformSID"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RequestDateTimeTransformSID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[RequestDateTimeTransformSID]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[RequestDateSID]"
cachedDataType="i4"
cachedName="RequestDateSID"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RequestDateSID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[RequestDateSID]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[FileEntryDateTime]"
cachedDataType="dbTimeStamp2"
cachedName="FileEntryDateTime"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[FileEntryDateTime]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[FileEntryDateTime]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[FileEntryVistaErrorDate]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="FileEntryVistaErrorDate"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[FileEntryVistaErrorDate]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[FileEntryVistaErrorDate]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[FileEntryDateTimeTransformSID]"
cachedDataType="i8"
cachedName="FileEntryDateTimeTransformSID"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[FileEntryDateTimeTransformSID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[FileEntryDateTimeTransformSID]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[FromLocationSID]"
cachedDataType="i4"
cachedName="FromLocationSID"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[FromLocationSID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[FromLocationSID]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[RequestType]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="RequestType"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RequestType]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[RequestType]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[ToStaffSID]"
cachedDataType="i4"
cachedName="ToStaffSID"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ToStaffSID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ToStaffSID]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[OrderStatusSID]"
cachedDataType="i4"
cachedName="OrderStatusSID"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[OrderStatusSID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[OrderStatusSID]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[CPRSOrderSID]"
cachedDataType="i8"
cachedName="CPRSOrderSID"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[CPRSOrderSID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[CPRSOrderSID]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[CPRSStatus]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="CPRSStatus"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[CPRSStatus]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[CPRSStatus]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[RecentActivityTypeSID]"
cachedDataType="i4"
cachedName="RecentActivityTypeSID"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RecentActivityTypeSID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[RecentActivityTypeSID]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[RecentActivityType]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="100"
cachedName="RecentActivityType"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RecentActivityType]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[RecentActivityType]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[SendingStaffSID]"
cachedDataType="i4"
cachedName="SendingStaffSID"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[SendingStaffSID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[SendingStaffSID]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[SignificantFindings]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="1"
cachedName="SignificantFindings"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[SignificantFindings]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[SignificantFindings]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[UrgencyProtocolSID]"
cachedDataType="i4"
cachedName="UrgencyProtocolSID"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[UrgencyProtocolSID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[UrgencyProtocolSID]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[Urgency]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="Urgency"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[Urgency]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[Urgency]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[ConsultPlaceProtocolSID]"
cachedDataType="i4"
cachedName="ConsultPlaceProtocolSID"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ConsultPlaceProtocolSID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ConsultPlaceProtocolSID]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[PlaceOfConsultation]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="PlaceOfConsultation"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[PlaceOfConsultation]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[PlaceOfConsultation]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[DisplayTextOfItemOrdered]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="100"
cachedName="DisplayTextOfItemOrdered"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[DisplayTextOfItemOrdered]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[DisplayTextOfItemOrdered]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[OrderingInstitutionSID]"
cachedDataType="i4"
cachedName="OrderingInstitutionSID"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[OrderingInstitutionSID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[OrderingInstitutionSID]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[OrderingSta3n]"
cachedDataType="i2"
cachedName="OrderingSta3n"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[OrderingSta3n]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[OrderingSta3n]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[InpatOutpat]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="InpatOutpat"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[InpatOutpat]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[InpatOutpat]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[ProvisionalDiagnosis]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="255"
cachedName="ProvisionalDiagnosis"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ProvisionalDiagnosis]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ProvisionalDiagnosis]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[ProvisionalDiagnosisCode]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="ProvisionalDiagnosisCode"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ProvisionalDiagnosisCode]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ProvisionalDiagnosisCode]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[RemoteRole]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="RemoteRole"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RemoteRole]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[RemoteRole]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[RemoteService]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="100"
cachedName="RemoteService"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RemoteService]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[RemoteService]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[RemoteConsultInstitutionSID]"
cachedDataType="i4"
cachedName="RemoteConsultInstitutionSID"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RemoteConsultInstitutionSID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[RemoteConsultInstitutionSID]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[RemoteConsultSta3n]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="RemoteConsultSta3n"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RemoteConsultSta3n]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[RemoteConsultSta3n]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[RemoteConsultSID]"
cachedDataType="i8"
cachedName="RemoteConsultSID"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RemoteConsultSID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[RemoteConsultSID]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[TIUDocumentSID]"
cachedDataType="i8"
cachedName="TIUDocumentSID"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[TIUDocumentSID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[TIUDocumentSID]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[EarliestDate]"
cachedDataType="dbDate"
cachedName="EarliestDate"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[EarliestDate]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[EarliestDate]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[EarliestVistaErrorDate]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="EarliestVistaErrorDate"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[EarliestVistaErrorDate]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[EarliestVistaErrorDate]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[EarliestDateTransformSID]"
cachedDataType="i8"
cachedName="EarliestDateTransformSID"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[EarliestDateTransformSID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[EarliestDateTransformSID]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[ClinicalProcedureIEN]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="ClinicalProcedureIEN"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ClinicalProcedureIEN]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ClinicalProcedureIEN]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[ConsultPlaceProtocolIEN]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="ConsultPlaceProtocolIEN"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ConsultPlaceProtocolIEN]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ConsultPlaceProtocolIEN]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[CPRSOrderIEN]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="CPRSOrderIEN"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[CPRSOrderIEN]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[CPRSOrderIEN]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[FromLocationIEN]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="FromLocationIEN"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[FromLocationIEN]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[FromLocationIEN]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[GMRCProcedureIEN]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="GMRCProcedureIEN"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[GMRCProcedureIEN]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[GMRCProcedureIEN]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[OrderingInstitutionIEN]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="OrderingInstitutionIEN"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[OrderingInstitutionIEN]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[OrderingInstitutionIEN]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[OrderStatusIEN]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="OrderStatusIEN"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[OrderStatusIEN]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[OrderStatusIEN]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[PatientIEN]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="PatientIEN"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[PatientIEN]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[PatientIEN]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[PatientLocationIEN]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="PatientLocationIEN"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[PatientLocationIEN]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[PatientLocationIEN]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[ProtocolIEN]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="ProtocolIEN"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ProtocolIEN]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ProtocolIEN]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[RecentActivityTypeIEN]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="RecentActivityTypeIEN"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RecentActivityTypeIEN]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[RecentActivityTypeIEN]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[RemoteConsultIEN]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="RemoteConsultIEN"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RemoteConsultIEN]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[RemoteConsultIEN]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[RemoteConsultInstitutionIEN]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="RemoteConsultInstitutionIEN"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RemoteConsultInstitutionIEN]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[RemoteConsultInstitutionIEN]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[SendingStaffIEN]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="SendingStaffIEN"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[SendingStaffIEN]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[SendingStaffIEN]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[TIUDocumentIEN]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="TIUDocumentIEN"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[TIUDocumentIEN]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[TIUDocumentIEN]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[ToRequestServiceIEN]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="ToRequestServiceIEN"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ToRequestServiceIEN]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ToRequestServiceIEN]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[ToStaffIEN]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="ToStaffIEN"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ToStaffIEN]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ToStaffIEN]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[UrgencyProtocolIEN]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="UrgencyProtocolIEN"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[UrgencyProtocolIEN]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[UrgencyProtocolIEN]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[ResultIEN]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="ResultIEN"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ResultIEN]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ResultIEN]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[ResultSID]"
cachedDataType="i8"
cachedName="ResultSID"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ResultSID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ResultSID]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[ResultPointedToFileNumber]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="50"
cachedName="ResultPointedToFileNumber"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ResultPointedToFileNumber]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ResultPointedToFileNumber]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[OpCode]"
cachedCodepage="1252"
cachedDataType="str"
cachedLength="1"
cachedName="OpCode"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[OpCode]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[OpCode]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[VistaCreateDate]"
cachedDataType="dbTimeStamp"
cachedName="VistaCreateDate"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[VistaCreateDate]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[VistaCreateDate]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[VistaEditDate]"
cachedDataType="dbTimeStamp"
cachedName="VistaEditDate"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[VistaEditDate]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[VistaEditDate]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[ETLBatchID]"
cachedDataType="i8"
cachedName="ETLBatchID"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ETLBatchID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ETLBatchID]" />
<inputColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[BatchLogID]"
cachedDataType="i8"
cachedName="BatchLogID"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB 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\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ConsultSID]"
dataType="i8"
name="ConsultSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ConsultIEN]"
codePage="1252"
dataType="str"
length="50"
name="ConsultIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[Sta3n]"
dataType="i2"
name="Sta3n" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[PatientSID]"
dataType="i4"
name="PatientSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[PatientLocationSID]"
dataType="i4"
name="PatientLocationSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ProtocolSID]"
dataType="i4"
name="ProtocolSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[GMRCProcedureSID]"
dataType="i4"
name="GMRCProcedureSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[GMRCProcedure]"
codePage="1252"
dataType="str"
length="100"
name="GMRCProcedure" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ClinicalProcedureSID]"
dataType="i4"
name="ClinicalProcedureSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ToRequestServiceSID]"
dataType="i4"
name="ToRequestServiceSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ToRequestServiceName]"
codePage="1252"
dataType="str"
length="100"
name="ToRequestServiceName" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RequestDateTime]"
dataType="dbTimeStamp2"
name="RequestDateTime"
scale="7" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RequestVistaErrorDate]"
codePage="1252"
dataType="str"
length="50"
name="RequestVistaErrorDate" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RequestDateTimeTransformSID]"
dataType="i8"
name="RequestDateTimeTransformSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RequestDateSID]"
dataType="i4"
name="RequestDateSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[FileEntryDateTime]"
dataType="dbTimeStamp2"
name="FileEntryDateTime"
scale="7" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[FileEntryVistaErrorDate]"
codePage="1252"
dataType="str"
length="50"
name="FileEntryVistaErrorDate" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[FileEntryDateTimeTransformSID]"
dataType="i8"
name="FileEntryDateTimeTransformSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[FromLocationSID]"
dataType="i4"
name="FromLocationSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RequestType]"
codePage="1252"
dataType="str"
length="50"
name="RequestType" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ToStaffSID]"
dataType="i4"
name="ToStaffSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[OrderStatusSID]"
dataType="i4"
name="OrderStatusSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[CPRSOrderSID]"
dataType="i8"
name="CPRSOrderSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[CPRSStatus]"
codePage="1252"
dataType="str"
length="50"
name="CPRSStatus" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RecentActivityTypeSID]"
dataType="i4"
name="RecentActivityTypeSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RecentActivityType]"
codePage="1252"
dataType="str"
length="100"
name="RecentActivityType" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[SendingStaffSID]"
dataType="i4"
name="SendingStaffSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[SignificantFindings]"
codePage="1252"
dataType="str"
length="1"
name="SignificantFindings" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[UrgencyProtocolSID]"
dataType="i4"
name="UrgencyProtocolSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[Urgency]"
codePage="1252"
dataType="str"
length="50"
name="Urgency" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ConsultPlaceProtocolSID]"
dataType="i4"
name="ConsultPlaceProtocolSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[PlaceOfConsultation]"
codePage="1252"
dataType="str"
length="50"
name="PlaceOfConsultation" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[DisplayTextOfItemOrdered]"
codePage="1252"
dataType="str"
length="100"
name="DisplayTextOfItemOrdered" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[OrderingInstitutionSID]"
dataType="i4"
name="OrderingInstitutionSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[OrderingSta3n]"
dataType="i2"
name="OrderingSta3n" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[InpatOutpat]"
codePage="1252"
dataType="str"
length="50"
name="InpatOutpat" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ProvisionalDiagnosis]"
codePage="1252"
dataType="str"
length="255"
name="ProvisionalDiagnosis" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ProvisionalDiagnosisCode]"
codePage="1252"
dataType="str"
length="50"
name="ProvisionalDiagnosisCode" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RemoteRole]"
codePage="1252"
dataType="str"
length="50"
name="RemoteRole" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RemoteService]"
codePage="1252"
dataType="str"
length="100"
name="RemoteService" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RemoteConsultInstitutionSID]"
dataType="i4"
name="RemoteConsultInstitutionSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RemoteConsultSta3n]"
codePage="1252"
dataType="str"
length="50"
name="RemoteConsultSta3n" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RemoteConsultSID]"
dataType="i8"
name="RemoteConsultSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[TIUDocumentSID]"
dataType="i8"
name="TIUDocumentSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[EarliestDate]"
dataType="dbDate"
name="EarliestDate" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[EarliestVistaErrorDate]"
codePage="1252"
dataType="str"
length="50"
name="EarliestVistaErrorDate" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[EarliestDateTransformSID]"
dataType="i8"
name="EarliestDateTransformSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ClinicalProcedureIEN]"
codePage="1252"
dataType="str"
length="50"
name="ClinicalProcedureIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ConsultPlaceProtocolIEN]"
codePage="1252"
dataType="str"
length="50"
name="ConsultPlaceProtocolIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[CPRSOrderIEN]"
codePage="1252"
dataType="str"
length="50"
name="CPRSOrderIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[FromLocationIEN]"
codePage="1252"
dataType="str"
length="50"
name="FromLocationIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[GMRCProcedureIEN]"
codePage="1252"
dataType="str"
length="50"
name="GMRCProcedureIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[OrderingInstitutionIEN]"
codePage="1252"
dataType="str"
length="50"
name="OrderingInstitutionIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[OrderStatusIEN]"
codePage="1252"
dataType="str"
length="50"
name="OrderStatusIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[PatientIEN]"
codePage="1252"
dataType="str"
length="50"
name="PatientIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[PatientLocationIEN]"
codePage="1252"
dataType="str"
length="50"
name="PatientLocationIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ProtocolIEN]"
codePage="1252"
dataType="str"
length="50"
name="ProtocolIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RecentActivityTypeIEN]"
codePage="1252"
dataType="str"
length="50"
name="RecentActivityTypeIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RemoteConsultIEN]"
codePage="1252"
dataType="str"
length="50"
name="RemoteConsultIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[RemoteConsultInstitutionIEN]"
codePage="1252"
dataType="str"
length="50"
name="RemoteConsultInstitutionIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[SendingStaffIEN]"
codePage="1252"
dataType="str"
length="50"
name="SendingStaffIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[TIUDocumentIEN]"
codePage="1252"
dataType="str"
length="50"
name="TIUDocumentIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ToRequestServiceIEN]"
codePage="1252"
dataType="str"
length="50"
name="ToRequestServiceIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ToStaffIEN]"
codePage="1252"
dataType="str"
length="50"
name="ToStaffIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[UrgencyProtocolIEN]"
codePage="1252"
dataType="str"
length="50"
name="UrgencyProtocolIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ResultIEN]"
codePage="1252"
dataType="str"
length="50"
name="ResultIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ResultSID]"
dataType="i8"
name="ResultSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ResultPointedToFileNumber]"
codePage="1252"
dataType="str"
length="50"
name="ResultPointedToFileNumber" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ETLBatchID]"
dataType="i4"
name="ETLBatchID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[OpCode]"
codePage="1252"
dataType="str"
length="1"
name="OpCode" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[VistaCreateDate]"
dataType="dbTimeStamp"
name="VistaCreateDate" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[VistaEditDate]"
dataType="dbTimeStamp"
name="VistaEditDate" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[BatchLogID]"
dataType="i8"
name="BatchLogID" />
</externalMetadataColumns>
</input>
</inputs>
<outputs>
<output
refId="Package\Data Flow Task\OLE DB Destination.Outputs[OLE DB Destination Error Output]"
exclusionGroup="1"
isErrorOut="true"
name="OLE DB Destination Error Output"
synchronousInputId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input]">
<outputColumns>
<outputColumn
refId="Package\Data Flow Task\OLE DB Destination.Outputs[OLE DB Destination Error Output].Columns[ErrorCode]"
dataType="i4"
lineageId="Package\Data Flow Task\OLE DB Destination.Outputs[OLE DB Destination Error Output].Columns[ErrorCode]"
name="ErrorCode"
specialFlags="1" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Destination.Outputs[OLE DB Destination Error Output].Columns[ErrorColumn]"
dataType="i4"
lineageId="Package\Data Flow Task\OLE DB Destination.Outputs[OLE DB Destination Error Output].Columns[ErrorColumn]"
name="ErrorColumn"
specialFlags="2" />
</outputColumns>
<externalMetadataColumns />
</output>
</outputs>
</component>
<component
refId="Package\Data Flow Task\OLE DB Source"
componentClassID="Microsoft.OLEDBSource"
contactInfo="OLE DB Source;Microsoft Corporation; Microsoft SQL Server; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;7"
description="OLE DB Source"
name="OLE DB Source"
usesDispositions="true"
version="7">
<properties>
<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">0</property>
<property
dataType="System.String"
description="Specifies the name of the database object used to open a rowset."
name="OpenRowset"></property>
<property
dataType="System.String"
description="Specifies the variable that contains the name of the database object used to open a rowset."
name="OpenRowsetVariable"></property>
<property
dataType="System.String"
description="The SQL command to be executed."
name="SqlCommand"
UITypeEditor="Microsoft.DataTransformationServices.Controls.ModalMultilineStringEditor, Microsoft.DataTransformationServices.Controls, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91">Declare @PriorSourceBatchNumber int

SELECT [ConsultSID]
,[ConsultIEN]
,[Sta3n]
,[PatientSID]
,[PatientLocationSID]
,[ProtocolSID]
,[GMRCProcedureSID]
,[GMRCProcedure]
,[ClinicalProcedureSID]
,[ToRequestServiceSID]
,[ToRequestServiceName]
,[RequestDateTime]
,[RequestVistaErrorDate]
,[RequestDateTimeTransformSID]
,[RequestDateSID]
,[FileEntryDateTime]
,[FileEntryVistaErrorDate]
,[FileEntryDateTimeTransformSID]
,[FromLocationSID]
,[RequestType]
,[ToStaffSID]
,[OrderStatusSID]
,[CPRSOrderSID]
,[CPRSStatus]
,[RecentActivityTypeSID]
,[RecentActivityType]
,[SendingStaffSID]
,[SignificantFindings]
,[UrgencyProtocolSID]
,[Urgency]
,[ConsultPlaceProtocolSID]
,[PlaceOfConsultation]
,[DisplayTextOfItemOrdered]
,[OrderingInstitutionSID]
,[OrderingSta3n]
,[InpatOutpat]
,[ProvisionalDiagnosis]
,[ProvisionalDiagnosisCode]
,[RemoteRole]
,[RemoteService]
,[RemoteConsultInstitutionSID]
,[RemoteConsultSta3n]
,[RemoteConsultSID]
,[TIUDocumentSID]
,[EarliestDate]
,[EarliestVistaErrorDate]
,[EarliestDateTransformSID]
,[ClinicalProcedureIEN]
,[ConsultPlaceProtocolIEN]
,[CPRSOrderIEN]
,[FromLocationIEN]
,[GMRCProcedureIEN]
,[OrderingInstitutionIEN]
,[OrderStatusIEN]
,[PatientIEN]
,[PatientLocationIEN]
,[ProtocolIEN]
,[RecentActivityTypeIEN]
,[RemoteConsultIEN]
,[RemoteConsultInstitutionIEN]
,[SendingStaffIEN]
,[TIUDocumentIEN]
,[ToRequestServiceIEN]
,[ToStaffIEN]
,[UrgencyProtocolIEN]
,[ResultIEN]
,[ResultSID]
,[ResultPointedToFileNumber]
-- ,a.[ETLBatchID]
,[OpCode]
,[VistaCreateDate]
,[VistaEditDate]

, [ExtractBatchID] as [ETLBatchID] ---- temp for now since ExtractBatchId is unique as opposed ETLBatchID
,[ETLBatchLoadedDateTime]
,[ExtractBatchLoadedDateTime]
,[DWViewSchema]
,[DWViewName]
,[ViewNameConcat]


FROM SPV.Con.Consult a

inner join [SPV].[EB].[ExtractBatch] b
on a.ETLBatchID = b.ETLBatchID

Where b.DWViewName = 'Consult'
-- started from FY15 then will run the last 3 years from running time
-- HOWEVER DOING ONLY FY17 AND VALIDATING CHANGES IN THE LAST YEAR TO DATE
-- OR DO WE NEED ANY RECORD CHANGED REAGRDLESS OF TIME?
--AND a.RequestDateTime &gt; '10-01-2016'
and a.RequestDateTime &gt; convert (date,Dateadd(day, -365, GETDATE()))

-- and a.RequestDateTime &gt; '10-25-2015' and a.RequestDateTime &lt; '10-27-2015'
and ExtractBatchID &gt; ?
-- testing &gt; (which is the original plan) vs &gt;=
-- and [ExtractBatchID] &gt;= ?
--3903557</property>
<property
dataType="System.String"
description="The variable that contains the SQL command to be executed."
name="SqlCommandVariable"></property>
<property
dataType="System.Int32"
description="Specifies the column code page to use when code page information is unavailable from the data source."
name="DefaultCodePage">1252</property>
<property
dataType="System.Boolean"
description="Forces the use of the DefaultCodePage property value when describing character data."
name="AlwaysUseDefaultCodePage">false</property>
<property
dataType="System.Int32"
description="Specifies the mode used to access the database."
name="AccessMode"
typeConverter="AccessMode">2</property>
<property
dataType="System.String"
description="The mappings between the parameters in the SQL command and variables."
name="ParameterMapping">"Parameter0:Input",{667A29B3-C7F6-4EB6-9267-4FAC4853BC74};</property>
</properties>
<connections>
<connection
refId="Package\Data Flow Task\OLE DB Source.Connections[OleDbConnection]"
connectionManagerID="{830EDAD9-324D-4D2B-A575-C32BAC8260E9}:external"
connectionManagerRefId="Project.ConnectionManagers[
URL SPV_OLEDB]"
description="The OLE DB runtime connection used to access the database."
name="OleDbConnection" />
</connections>
<outputs>
<output
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output]"
name="OLE DB Source Output">
<outputColumns>
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ConsultSID]"
dataType="i8"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ConsultSID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ConsultSID]"
name="ConsultSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ConsultIEN]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ConsultIEN]"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ConsultIEN]"
name="ConsultIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[Sta3n]"
dataType="i2"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[Sta3n]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[Sta3n]"
name="Sta3n"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[PatientSID]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[PatientSID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[PatientSID]"
name="PatientSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[PatientLocationSID]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[PatientLocationSID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[PatientLocationSID]"
name="PatientLocationSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ProtocolSID]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ProtocolSID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ProtocolSID]"
name="ProtocolSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[GMRCProcedureSID]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[GMRCProcedureSID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[GMRCProcedureSID]"
name="GMRCProcedureSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[GMRCProcedure]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[GMRCProcedure]"
length="100"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[GMRCProcedure]"
name="GMRCProcedure"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ClinicalProcedureSID]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ClinicalProcedureSID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ClinicalProcedureSID]"
name="ClinicalProcedureSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ToRequestServiceSID]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ToRequestServiceSID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ToRequestServiceSID]"
name="ToRequestServiceSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ToRequestServiceName]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ToRequestServiceName]"
length="100"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ToRequestServiceName]"
name="ToRequestServiceName"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[RequestDateTime]"
dataType="dbTimeStamp2"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RequestDateTime]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[RequestDateTime]"
name="RequestDateTime"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[RequestVistaErrorDate]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RequestVistaErrorDate]"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[RequestVistaErrorDate]"
name="RequestVistaErrorDate"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[RequestDateTimeTransformSID]"
dataType="i8"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RequestDateTimeTransformSID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[RequestDateTimeTransformSID]"
name="RequestDateTimeTransformSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[RequestDateSID]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RequestDateSID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[RequestDateSID]"
name="RequestDateSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[FileEntryDateTime]"
dataType="dbTimeStamp2"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[FileEntryDateTime]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[FileEntryDateTime]"
name="FileEntryDateTime"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[FileEntryVistaErrorDate]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[FileEntryVistaErrorDate]"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[FileEntryVistaErrorDate]"
name="FileEntryVistaErrorDate"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[FileEntryDateTimeTransformSID]"
dataType="i8"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[FileEntryDateTimeTransformSID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[FileEntryDateTimeTransformSID]"
name="FileEntryDateTimeTransformSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[FromLocationSID]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[FromLocationSID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[FromLocationSID]"
name="FromLocationSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[RequestType]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RequestType]"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[RequestType]"
name="RequestType"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ToStaffSID]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ToStaffSID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ToStaffSID]"
name="ToStaffSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[OrderStatusSID]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[OrderStatusSID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[OrderStatusSID]"
name="OrderStatusSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[CPRSOrderSID]"
dataType="i8"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[CPRSOrderSID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[CPRSOrderSID]"
name="CPRSOrderSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[CPRSStatus]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[CPRSStatus]"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[CPRSStatus]"
name="CPRSStatus"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[RecentActivityTypeSID]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RecentActivityTypeSID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[RecentActivityTypeSID]"
name="RecentActivityTypeSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[RecentActivityType]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RecentActivityType]"
length="100"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[RecentActivityType]"
name="RecentActivityType"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[SendingStaffSID]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[SendingStaffSID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[SendingStaffSID]"
name="SendingStaffSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[SignificantFindings]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[SignificantFindings]"
length="1"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[SignificantFindings]"
name="SignificantFindings"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[UrgencyProtocolSID]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[UrgencyProtocolSID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[UrgencyProtocolSID]"
name="UrgencyProtocolSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[Urgency]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[Urgency]"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[Urgency]"
name="Urgency"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ConsultPlaceProtocolSID]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ConsultPlaceProtocolSID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ConsultPlaceProtocolSID]"
name="ConsultPlaceProtocolSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[PlaceOfConsultation]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[PlaceOfConsultation]"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[PlaceOfConsultation]"
name="PlaceOfConsultation"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[DisplayTextOfItemOrdered]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[DisplayTextOfItemOrdered]"
length="100"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[DisplayTextOfItemOrdered]"
name="DisplayTextOfItemOrdered"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[OrderingInstitutionSID]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[OrderingInstitutionSID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[OrderingInstitutionSID]"
name="OrderingInstitutionSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[OrderingSta3n]"
dataType="i2"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[OrderingSta3n]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[OrderingSta3n]"
name="OrderingSta3n"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[InpatOutpat]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[InpatOutpat]"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[InpatOutpat]"
name="InpatOutpat"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ProvisionalDiagnosis]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ProvisionalDiagnosis]"
length="255"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ProvisionalDiagnosis]"
name="ProvisionalDiagnosis"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ProvisionalDiagnosisCode]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ProvisionalDiagnosisCode]"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ProvisionalDiagnosisCode]"
name="ProvisionalDiagnosisCode"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[RemoteRole]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RemoteRole]"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[RemoteRole]"
name="RemoteRole"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[RemoteService]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RemoteService]"
length="100"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[RemoteService]"
name="RemoteService"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[RemoteConsultInstitutionSID]"
dataType="i4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RemoteConsultInstitutionSID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[RemoteConsultInstitutionSID]"
name="RemoteConsultInstitutionSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[RemoteConsultSta3n]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RemoteConsultSta3n]"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[RemoteConsultSta3n]"
name="RemoteConsultSta3n"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[RemoteConsultSID]"
dataType="i8"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RemoteConsultSID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[RemoteConsultSID]"
name="RemoteConsultSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[TIUDocumentSID]"
dataType="i8"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[TIUDocumentSID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[TIUDocumentSID]"
name="TIUDocumentSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[EarliestDate]"
dataType="dbDate"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[EarliestDate]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[EarliestDate]"
name="EarliestDate"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[EarliestVistaErrorDate]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[EarliestVistaErrorDate]"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[EarliestVistaErrorDate]"
name="EarliestVistaErrorDate"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[EarliestDateTransformSID]"
dataType="i8"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[EarliestDateTransformSID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[EarliestDateTransformSID]"
name="EarliestDateTransformSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ClinicalProcedureIEN]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ClinicalProcedureIEN]"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ClinicalProcedureIEN]"
name="ClinicalProcedureIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ConsultPlaceProtocolIEN]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ConsultPlaceProtocolIEN]"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ConsultPlaceProtocolIEN]"
name="ConsultPlaceProtocolIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[CPRSOrderIEN]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[CPRSOrderIEN]"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[CPRSOrderIEN]"
name="CPRSOrderIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[FromLocationIEN]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[FromLocationIEN]"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[FromLocationIEN]"
name="FromLocationIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[GMRCProcedureIEN]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[GMRCProcedureIEN]"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[GMRCProcedureIEN]"
name="GMRCProcedureIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[OrderingInstitutionIEN]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[OrderingInstitutionIEN]"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[OrderingInstitutionIEN]"
name="OrderingInstitutionIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[OrderStatusIEN]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[OrderStatusIEN]"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[OrderStatusIEN]"
name="OrderStatusIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[PatientIEN]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[PatientIEN]"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[PatientIEN]"
name="PatientIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[PatientLocationIEN]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[PatientLocationIEN]"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[PatientLocationIEN]"
name="PatientLocationIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ProtocolIEN]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ProtocolIEN]"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ProtocolIEN]"
name="ProtocolIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[RecentActivityTypeIEN]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RecentActivityTypeIEN]"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[RecentActivityTypeIEN]"
name="RecentActivityTypeIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[RemoteConsultIEN]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RemoteConsultIEN]"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[RemoteConsultIEN]"
name="RemoteConsultIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[RemoteConsultInstitutionIEN]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RemoteConsultInstitutionIEN]"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[RemoteConsultInstitutionIEN]"
name="RemoteConsultInstitutionIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[SendingStaffIEN]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[SendingStaffIEN]"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[SendingStaffIEN]"
name="SendingStaffIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[TIUDocumentIEN]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[TIUDocumentIEN]"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[TIUDocumentIEN]"
name="TIUDocumentIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ToRequestServiceIEN]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ToRequestServiceIEN]"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ToRequestServiceIEN]"
name="ToRequestServiceIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ToStaffIEN]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ToStaffIEN]"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ToStaffIEN]"
name="ToStaffIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[UrgencyProtocolIEN]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[UrgencyProtocolIEN]"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[UrgencyProtocolIEN]"
name="UrgencyProtocolIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ResultIEN]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ResultIEN]"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ResultIEN]"
name="ResultIEN"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ResultSID]"
dataType="i8"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ResultSID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ResultSID]"
name="ResultSID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ResultPointedToFileNumber]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ResultPointedToFileNumber]"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ResultPointedToFileNumber]"
name="ResultPointedToFileNumber"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[OpCode]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[OpCode]"
length="1"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[OpCode]"
name="OpCode"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[VistaCreateDate]"
dataType="dbTimeStamp"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[VistaCreateDate]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[VistaCreateDate]"
name="VistaCreateDate"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[VistaEditDate]"
dataType="dbTimeStamp"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[VistaEditDate]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[VistaEditDate]"
name="VistaEditDate"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ETLBatchID]"
dataType="i8"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ETLBatchID]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ETLBatchID]"
name="ETLBatchID"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ETLBatchLoadedDateTime]"
dataType="dbTimeStamp2"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ETLBatchLoadedDateTime]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ETLBatchLoadedDateTime]"
name="ETLBatchLoadedDateTime"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ExtractBatchLoadedDateTime]"
dataType="dbTimeStamp2"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ExtractBatchLoadedDateTime]"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ExtractBatchLoadedDateTime]"
name="ExtractBatchLoadedDateTime"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[DWViewSchema]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[DWViewSchema]"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[DWViewSchema]"
name="DWViewSchema"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[DWViewName]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[DWViewName]"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[DWViewName]"
name="DWViewName"
truncationRowDisposition="FailComponent" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ViewNameConcat]"
codePage="1252"
dataType="str"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ViewNameConcat]"
length="101"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[ViewNameConcat]"
name="ViewNameConcat"
truncationRowDisposition="FailComponent" />
</outputColumns>
<externalMetadataColumns
isUsed="True">
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ConsultSID]"
dataType="i8"
name="ConsultSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ConsultIEN]"
codePage="1252"
dataType="str"
length="50"
name="ConsultIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[Sta3n]"
dataType="i2"
name="Sta3n" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[PatientSID]"
dataType="i4"
name="PatientSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[PatientLocationSID]"
dataType="i4"
name="PatientLocationSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ProtocolSID]"
dataType="i4"
name="ProtocolSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[GMRCProcedureSID]"
dataType="i4"
name="GMRCProcedureSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[GMRCProcedure]"
codePage="1252"
dataType="str"
length="100"
name="GMRCProcedure" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ClinicalProcedureSID]"
dataType="i4"
name="ClinicalProcedureSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ToRequestServiceSID]"
dataType="i4"
name="ToRequestServiceSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ToRequestServiceName]"
codePage="1252"
dataType="str"
length="100"
name="ToRequestServiceName" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RequestDateTime]"
dataType="dbTimeStamp2"
name="RequestDateTime" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RequestVistaErrorDate]"
codePage="1252"
dataType="str"
length="50"
name="RequestVistaErrorDate" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RequestDateTimeTransformSID]"
dataType="i8"
name="RequestDateTimeTransformSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RequestDateSID]"
dataType="i4"
name="RequestDateSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[FileEntryDateTime]"
dataType="dbTimeStamp2"
name="FileEntryDateTime" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[FileEntryVistaErrorDate]"
codePage="1252"
dataType="str"
length="50"
name="FileEntryVistaErrorDate" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[FileEntryDateTimeTransformSID]"
dataType="i8"
name="FileEntryDateTimeTransformSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[FromLocationSID]"
dataType="i4"
name="FromLocationSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RequestType]"
codePage="1252"
dataType="str"
length="50"
name="RequestType" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ToStaffSID]"
dataType="i4"
name="ToStaffSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[OrderStatusSID]"
dataType="i4"
name="OrderStatusSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[CPRSOrderSID]"
dataType="i8"
name="CPRSOrderSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[CPRSStatus]"
codePage="1252"
dataType="str"
length="50"
name="CPRSStatus" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RecentActivityTypeSID]"
dataType="i4"
name="RecentActivityTypeSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RecentActivityType]"
codePage="1252"
dataType="str"
length="100"
name="RecentActivityType" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[SendingStaffSID]"
dataType="i4"
name="SendingStaffSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[SignificantFindings]"
codePage="1252"
dataType="str"
length="1"
name="SignificantFindings" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[UrgencyProtocolSID]"
dataType="i4"
name="UrgencyProtocolSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[Urgency]"
codePage="1252"
dataType="str"
length="50"
name="Urgency" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ConsultPlaceProtocolSID]"
dataType="i4"
name="ConsultPlaceProtocolSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[PlaceOfConsultation]"
codePage="1252"
dataType="str"
length="50"
name="PlaceOfConsultation" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[DisplayTextOfItemOrdered]"
codePage="1252"
dataType="str"
length="100"
name="DisplayTextOfItemOrdered" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[OrderingInstitutionSID]"
dataType="i4"
name="OrderingInstitutionSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[OrderingSta3n]"
dataType="i2"
name="OrderingSta3n" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[InpatOutpat]"
codePage="1252"
dataType="str"
length="50"
name="InpatOutpat" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ProvisionalDiagnosis]"
codePage="1252"
dataType="str"
length="255"
name="ProvisionalDiagnosis" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ProvisionalDiagnosisCode]"
codePage="1252"
dataType="str"
length="50"
name="ProvisionalDiagnosisCode" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RemoteRole]"
codePage="1252"
dataType="str"
length="50"
name="RemoteRole" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RemoteService]"
codePage="1252"
dataType="str"
length="100"
name="RemoteService" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RemoteConsultInstitutionSID]"
dataType="i4"
name="RemoteConsultInstitutionSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RemoteConsultSta3n]"
codePage="1252"
dataType="str"
length="50"
name="RemoteConsultSta3n" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RemoteConsultSID]"
dataType="i8"
name="RemoteConsultSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[TIUDocumentSID]"
dataType="i8"
name="TIUDocumentSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[EarliestDate]"
dataType="dbDate"
name="EarliestDate" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[EarliestVistaErrorDate]"
codePage="1252"
dataType="str"
length="50"
name="EarliestVistaErrorDate" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[EarliestDateTransformSID]"
dataType="i8"
name="EarliestDateTransformSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ClinicalProcedureIEN]"
codePage="1252"
dataType="str"
length="50"
name="ClinicalProcedureIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ConsultPlaceProtocolIEN]"
codePage="1252"
dataType="str"
length="50"
name="ConsultPlaceProtocolIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[CPRSOrderIEN]"
codePage="1252"
dataType="str"
length="50"
name="CPRSOrderIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[FromLocationIEN]"
codePage="1252"
dataType="str"
length="50"
name="FromLocationIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[GMRCProcedureIEN]"
codePage="1252"
dataType="str"
length="50"
name="GMRCProcedureIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[OrderingInstitutionIEN]"
codePage="1252"
dataType="str"
length="50"
name="OrderingInstitutionIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[OrderStatusIEN]"
codePage="1252"
dataType="str"
length="50"
name="OrderStatusIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[PatientIEN]"
codePage="1252"
dataType="str"
length="50"
name="PatientIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[PatientLocationIEN]"
codePage="1252"
dataType="str"
length="50"
name="PatientLocationIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ProtocolIEN]"
codePage="1252"
dataType="str"
length="50"
name="ProtocolIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RecentActivityTypeIEN]"
codePage="1252"
dataType="str"
length="50"
name="RecentActivityTypeIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RemoteConsultIEN]"
codePage="1252"
dataType="str"
length="50"
name="RemoteConsultIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[RemoteConsultInstitutionIEN]"
codePage="1252"
dataType="str"
length="50"
name="RemoteConsultInstitutionIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[SendingStaffIEN]"
codePage="1252"
dataType="str"
length="50"
name="SendingStaffIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[TIUDocumentIEN]"
codePage="1252"
dataType="str"
length="50"
name="TIUDocumentIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ToRequestServiceIEN]"
codePage="1252"
dataType="str"
length="50"
name="ToRequestServiceIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ToStaffIEN]"
codePage="1252"
dataType="str"
length="50"
name="ToStaffIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[UrgencyProtocolIEN]"
codePage="1252"
dataType="str"
length="50"
name="UrgencyProtocolIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ResultIEN]"
codePage="1252"
dataType="str"
length="50"
name="ResultIEN" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ResultSID]"
dataType="i8"
name="ResultSID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ResultPointedToFileNumber]"
codePage="1252"
dataType="str"
length="50"
name="ResultPointedToFileNumber" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[OpCode]"
codePage="1252"
dataType="str"
length="1"
name="OpCode" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[VistaCreateDate]"
dataType="dbTimeStamp"
name="VistaCreateDate" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[VistaEditDate]"
dataType="dbTimeStamp"
name="VistaEditDate" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ETLBatchID]"
dataType="i8"
name="ETLBatchID" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ETLBatchLoadedDateTime]"
dataType="dbTimeStamp2"
name="ETLBatchLoadedDateTime" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ExtractBatchLoadedDateTime]"
dataType="dbTimeStamp2"
name="ExtractBatchLoadedDateTime" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[DWViewSchema]"
codePage="1252"
dataType="str"
length="50"
name="DWViewSchema" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[DWViewName]"
codePage="1252"
dataType="str"
length="50"
name="DWViewName" />
<externalMetadataColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ViewNameConcat]"
codePage="1252"
dataType="str"
length="101"
name="ViewNameConcat" />
</externalMetadataColumns>
</output>
<output
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output]"
isErrorOut="true"
name="OLE DB Source Error Output">
<outputColumns>
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ConsultSID]"
dataType="i8"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ConsultSID]"
name="ConsultSID" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ConsultIEN]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ConsultIEN]"
name="ConsultIEN" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[Sta3n]"
dataType="i2"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[Sta3n]"
name="Sta3n" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[PatientSID]"
dataType="i4"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[PatientSID]"
name="PatientSID" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[PatientLocationSID]"
dataType="i4"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[PatientLocationSID]"
name="PatientLocationSID" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ProtocolSID]"
dataType="i4"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ProtocolSID]"
name="ProtocolSID" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[GMRCProcedureSID]"
dataType="i4"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[GMRCProcedureSID]"
name="GMRCProcedureSID" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[GMRCProcedure]"
codePage="1252"
dataType="str"
length="100"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[GMRCProcedure]"
name="GMRCProcedure" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ClinicalProcedureSID]"
dataType="i4"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ClinicalProcedureSID]"
name="ClinicalProcedureSID" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ToRequestServiceSID]"
dataType="i4"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ToRequestServiceSID]"
name="ToRequestServiceSID" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ToRequestServiceName]"
codePage="1252"
dataType="str"
length="100"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ToRequestServiceName]"
name="ToRequestServiceName" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RequestDateTime]"
dataType="dbTimeStamp2"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RequestDateTime]"
name="RequestDateTime" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RequestVistaErrorDate]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RequestVistaErrorDate]"
name="RequestVistaErrorDate" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RequestDateTimeTransformSID]"
dataType="i8"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RequestDateTimeTransformSID]"
name="RequestDateTimeTransformSID" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RequestDateSID]"
dataType="i4"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RequestDateSID]"
name="RequestDateSID" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[FileEntryDateTime]"
dataType="dbTimeStamp2"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[FileEntryDateTime]"
name="FileEntryDateTime" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[FileEntryVistaErrorDate]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[FileEntryVistaErrorDate]"
name="FileEntryVistaErrorDate" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[FileEntryDateTimeTransformSID]"
dataType="i8"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[FileEntryDateTimeTransformSID]"
name="FileEntryDateTimeTransformSID" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[FromLocationSID]"
dataType="i4"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[FromLocationSID]"
name="FromLocationSID" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RequestType]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RequestType]"
name="RequestType" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ToStaffSID]"
dataType="i4"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ToStaffSID]"
name="ToStaffSID" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[OrderStatusSID]"
dataType="i4"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[OrderStatusSID]"
name="OrderStatusSID" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[CPRSOrderSID]"
dataType="i8"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[CPRSOrderSID]"
name="CPRSOrderSID" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[CPRSStatus]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[CPRSStatus]"
name="CPRSStatus" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RecentActivityTypeSID]"
dataType="i4"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RecentActivityTypeSID]"
name="RecentActivityTypeSID" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RecentActivityType]"
codePage="1252"
dataType="str"
length="100"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RecentActivityType]"
name="RecentActivityType" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[SendingStaffSID]"
dataType="i4"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[SendingStaffSID]"
name="SendingStaffSID" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[SignificantFindings]"
codePage="1252"
dataType="str"
length="1"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[SignificantFindings]"
name="SignificantFindings" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[UrgencyProtocolSID]"
dataType="i4"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[UrgencyProtocolSID]"
name="UrgencyProtocolSID" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[Urgency]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[Urgency]"
name="Urgency" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ConsultPlaceProtocolSID]"
dataType="i4"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ConsultPlaceProtocolSID]"
name="ConsultPlaceProtocolSID" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[PlaceOfConsultation]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[PlaceOfConsultation]"
name="PlaceOfConsultation" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[DisplayTextOfItemOrdered]"
codePage="1252"
dataType="str"
length="100"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[DisplayTextOfItemOrdered]"
name="DisplayTextOfItemOrdered" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[OrderingInstitutionSID]"
dataType="i4"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[OrderingInstitutionSID]"
name="OrderingInstitutionSID" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[OrderingSta3n]"
dataType="i2"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[OrderingSta3n]"
name="OrderingSta3n" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[InpatOutpat]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[InpatOutpat]"
name="InpatOutpat" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ProvisionalDiagnosis]"
codePage="1252"
dataType="str"
length="255"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ProvisionalDiagnosis]"
name="ProvisionalDiagnosis" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ProvisionalDiagnosisCode]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ProvisionalDiagnosisCode]"
name="ProvisionalDiagnosisCode" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RemoteRole]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RemoteRole]"
name="RemoteRole" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RemoteService]"
codePage="1252"
dataType="str"
length="100"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RemoteService]"
name="RemoteService" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RemoteConsultInstitutionSID]"
dataType="i4"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RemoteConsultInstitutionSID]"
name="RemoteConsultInstitutionSID" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RemoteConsultSta3n]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RemoteConsultSta3n]"
name="RemoteConsultSta3n" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RemoteConsultSID]"
dataType="i8"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RemoteConsultSID]"
name="RemoteConsultSID" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[TIUDocumentSID]"
dataType="i8"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[TIUDocumentSID]"
name="TIUDocumentSID" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[EarliestDate]"
dataType="dbDate"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[EarliestDate]"
name="EarliestDate" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[EarliestVistaErrorDate]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[EarliestVistaErrorDate]"
name="EarliestVistaErrorDate" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[EarliestDateTransformSID]"
dataType="i8"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[EarliestDateTransformSID]"
name="EarliestDateTransformSID" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ClinicalProcedureIEN]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ClinicalProcedureIEN]"
name="ClinicalProcedureIEN" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ConsultPlaceProtocolIEN]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ConsultPlaceProtocolIEN]"
name="ConsultPlaceProtocolIEN" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[CPRSOrderIEN]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[CPRSOrderIEN]"
name="CPRSOrderIEN" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[FromLocationIEN]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[FromLocationIEN]"
name="FromLocationIEN" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[GMRCProcedureIEN]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[GMRCProcedureIEN]"
name="GMRCProcedureIEN" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[OrderingInstitutionIEN]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[OrderingInstitutionIEN]"
name="OrderingInstitutionIEN" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[OrderStatusIEN]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[OrderStatusIEN]"
name="OrderStatusIEN" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[PatientIEN]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[PatientIEN]"
name="PatientIEN" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[PatientLocationIEN]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[PatientLocationIEN]"
name="PatientLocationIEN" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ProtocolIEN]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ProtocolIEN]"
name="ProtocolIEN" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RecentActivityTypeIEN]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RecentActivityTypeIEN]"
name="RecentActivityTypeIEN" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RemoteConsultIEN]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RemoteConsultIEN]"
name="RemoteConsultIEN" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RemoteConsultInstitutionIEN]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[RemoteConsultInstitutionIEN]"
name="RemoteConsultInstitutionIEN" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[SendingStaffIEN]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[SendingStaffIEN]"
name="SendingStaffIEN" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[TIUDocumentIEN]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[TIUDocumentIEN]"
name="TIUDocumentIEN" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ToRequestServiceIEN]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ToRequestServiceIEN]"
name="ToRequestServiceIEN" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ToStaffIEN]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ToStaffIEN]"
name="ToStaffIEN" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[UrgencyProtocolIEN]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[UrgencyProtocolIEN]"
name="UrgencyProtocolIEN" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ResultIEN]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ResultIEN]"
name="ResultIEN" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ResultSID]"
dataType="i8"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ResultSID]"
name="ResultSID" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ResultPointedToFileNumber]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ResultPointedToFileNumber]"
name="ResultPointedToFileNumber" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[OpCode]"
codePage="1252"
dataType="str"
length="1"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[OpCode]"
name="OpCode" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[VistaCreateDate]"
dataType="dbTimeStamp"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[VistaCreateDate]"
name="VistaCreateDate" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[VistaEditDate]"
dataType="dbTimeStamp"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[VistaEditDate]"
name="VistaEditDate" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ETLBatchID]"
dataType="i8"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ETLBatchID]"
name="ETLBatchID" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ETLBatchLoadedDateTime]"
dataType="dbTimeStamp2"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ETLBatchLoadedDateTime]"
name="ETLBatchLoadedDateTime" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ExtractBatchLoadedDateTime]"
dataType="dbTimeStamp2"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ExtractBatchLoadedDateTime]"
name="ExtractBatchLoadedDateTime" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[DWViewSchema]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[DWViewSchema]"
name="DWViewSchema" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[DWViewName]"
codePage="1252"
dataType="str"
length="50"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[DWViewName]"
name="DWViewName" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ViewNameConcat]"
codePage="1252"
dataType="str"
length="101"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ViewNameConcat]"
name="ViewNameConcat" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ErrorCode]"
dataType="i4"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ErrorCode]"
name="ErrorCode"
specialFlags="1" />
<outputColumn
refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ErrorColumn]"
dataType="i4"
lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ErrorColumn]"
name="ErrorColumn"
specialFlags="2" />
</outputColumns>
<externalMetadataColumns />
</output>
</outputs>
</component>
</components>
<paths>
<path
refId="Package\Data Flow Task.Paths[Derived Column Output]"
endId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input]"
name="Derived Column Output"
startId="Package\Data Flow Task\Derived Column.Outputs[Derived Column Output]" />
<path
refId="Package\Data Flow Task.Paths[OLE DB Source Output]"
endId="Package\Data Flow Task\Derived Column.Inputs[Derived Column Input]"
name="OLE DB Source Output"
startId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source 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="1">
<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="0">
<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:x="http://schemas.microsoft.com/winfx/2006/xaml" xmlns:mssgm="clr-namespace:Microsoft.SqlServer.Graph.Model;assembly=Microsoft.SqlServer.Graph">
<NodeLayout
Size="151,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="{x: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="412.5,267">
<EdgeLayout.Curve>
<mssgle:Curve
StartConnector="{x:Null}"
EndConnector="71,41"
Start="0,0"
End="71,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="67,20.5" />
<mssgle:CubicBezierSegment
Point1="67,20.5"
Point2="71,20.5"
Point3="71,24.5" />
<mssgle:LineSegment
End="71,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="{x: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="488,246">
<EdgeLayout.Curve>
<mssgle:Curve
StartConnector="{x:Null}"
EndConnector="27,14"
Start="0,0"
End="19.5,14">
<mssgle:Curve.Segments>
<mssgle:SegmentCollection
Capacity="5">
<mssgle:LineSegment
End="9.5,0" />
<mssgle:CubicBezierSegment
Point1="9.5,0"
Point2="13.5,0"
Point3="13.5,4" />
<mssgle:LineSegment
End="13.5,10" />
<mssgle:CubicBezierSegment
Point1="13.5,10"
Point2="13.5,14"
Point3="17.5,14" />
<mssgle:LineSegment
End="19.5,14" />
</mssgle:SegmentCollection>
</mssgle:Curve.Segments>
</mssgle:Curve>
</EdgeLayout.Curve>
<EdgeLayout.Labels>
<mssgm:EdgeLabel
BoundingBox="-1.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="{x:Null}"
EndConnector="-16.1666666666666,95"
Start="0,0"
End="-16.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="-12.1666666666666,38.4115523465704" />
<mssgle:CubicBezierSegment
Point1="-12.1666666666666,38.4115523465704"
Point2="-16.1666666666666,38.4115523465704"
Point3="-16.1666666666666,42.4115523465704" />
<mssgle:LineSegment
End="-16.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="{x: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="{x:Null}"
Size="387,42"
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="171,42"
Id="Package\Data Flow Task\OLE DB Destination"
TopLeft="351,349" />
<NodeLayout
Size="150,42"
Id="Package\Data Flow Task\OLE DB Source"
TopLeft="36,119" />
<EdgeLayout
Id="Package\Data Flow Task.Paths[OLE DB Source Output]"
TopLeft="186,140">
<EdgeLayout.Curve>
<mssgle:Curve
StartConnector="{assembly:Null}"
EndConnector="154,0"
Start="0,0"
End="146.5,0">
<mssgle:Curve.Segments>
<mssgle:SegmentCollection
Capacity="5">
<mssgle:LineSegment
End="146.5,0" />
</mssgle:SegmentCollection>
</mssgle:Curve.Segments>
</mssgle:Curve>
</EdgeLayout.Curve>
<EdgeLayout.Labels>
<EdgeLabelCollection />
</EdgeLayout.Labels>
</EdgeLayout>
<EdgeLayout
Id="Package\Data Flow Task.Paths[Derived Column Output]"
TopLeft="418,161">
<EdgeLayout.Curve>
<mssgle:Curve
StartConnector="{assembly:Null}"
EndConnector="18.5,188"
Start="0,0"
End="18.5,180.5">
<mssgle:Curve.Segments>
<mssgle:SegmentCollection
Capacity="5">
<mssgle:LineSegment
End="0,90" />
<mssgle:CubicBezierSegment
Point1="0,90"
Point2="0,94"
Point3="4,94" />
<mssgle:LineSegment
End="14.5,94" />
<mssgle:CubicBezierSegment
Point1="14.5,94"
Point2="18.5,94"
Point3="18.5,98" />
<mssgle:LineSegment
End="18.5,180.5" />
</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\OLE DB Source">
<Properties>
<Property>
<Name>DataSourceViewID</Name>
</Property>
</Properties>
</PipelineComponentMetadata>
<PipelineComponentMetadata
design-time-name="Package\Data Flow Task\OLE DB Destination">
<Properties>
<Property>
<Name>DataSourceViewID</Name>
</Property>
<Property>
<Name>TableInfoObjectType</Name>
<Value
type="q2:string">Table</Value>
</Property>
</Properties>
</PipelineComponentMetadata>
</Objects>]]></DTS:DesignTimeProperties>
</DTS:Executable>