Summary Table

Categories Total Count
PII 1
URL 6
DNS 0
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="3/23/2018 7:01:00 AM"
DTS:CreationName="Microsoft.Package"
DTS:CreatorComputerName="BAY-LTCA112936"
DTS:CreatorName="
PII "
DTS:DTSID="{170257FF-412C-4154-84DE-DF6EB686E427}"
DTS:ExecutableType="Microsoft.Package"
DTS:LastModifiedProductVersion="14.0.3002.68"
DTS:LocaleID="1033"
DTS:ObjectName="extCon_OneConsultSync"
DTS:PackageType="5"
DTS:ProtectionLevel="0"
DTS:VersionBuild="7"
DTS:VersionGUID="{F5E4B805-8CD3-46AA-935F-518CB36014D1}">
<DTS:Property
DTS:Name="PackageFormatVersion">8</DTS:Property>
<DTS:ConnectionManagers>
<DTS:ConnectionManager
DTS:refId="Package.ConnectionManagers[
URL .CBOPC_EPRS_Shadow]"
DTS:CreationName="ADO.NET:SQL"
DTS:DTSID="{E4CBECAA-B848-497E-9926-8C8DD245B33E}"
DTS:ObjectName="
URL .CBOPC_EPRS_Shadow">
<DTS:ObjectData>
<DTS:ConnectionManager
DTS:ConnectionString="Data Source=
URL ;Integrated Security=SSPI;Connect Timeout=30;" />
</DTS:ObjectData>
</DTS:ConnectionManager>
<DTS:ConnectionManager
DTS:refId="Package.ConnectionManagers[
URL .CBOPC_EPRS]"
DTS:CreationName="ADO.NET:SQL"
DTS:DTSID="{E1F8A8A0-B1EA-4D30-8937-5B2AF3449532}"
DTS:ObjectName="
URL .CBOPC_EPRS">
<DTS:ObjectData>
<DTS:ConnectionManager
DTS:ConnectionString="Data Source=
URL ;Integrated Security=SSPI;Connect Timeout=30;" />
</DTS:ObjectData>
</DTS:ConnectionManager>
</DTS:ConnectionManagers>
<DTS:Variables />
<DTS:Executables>
<DTS:Executable
DTS:refId="Package\Execute SQL Task"
DTS:CreationName="Microsoft.ExecuteSQLTask"
DTS:Description="Execute SQL Task"
DTS:DTSID="{2AE0A909-370B-4845-945D-8881ADBC16AD}"
DTS:ExecutableType="Microsoft.ExecuteSQLTask"
DTS:LocaleID="-1"
DTS:ObjectName="Execute SQL Task"
DTS:ThreadHint="0">
<DTS:Variables />
<DTS:ObjectData>
<SQLTask:SqlTaskData
SQLTask:Connection="{CA06F0CF-F25E-48DC-84F4-7E552846C904}"
SQLTask:SqlStatementSource="EXEC [App].[uspMasterDoSynchOneConsultDataFromRaw];" xmlns:SQLTask="www.microsoft.com/sqlserver/dts/tasks/sqltask" />
</DTS:ObjectData>
</DTS:Executable>
<DTS:Executable
DTS:refId="Package\Rebuild Index Task"
DTS:CreationName="Microsoft.DbMaintenanceReindexTask"
DTS:Description="Rebuild Index Task"
DTS:DTSID="{13E7CF95-C235-41A8-B8D5-91AAB2B45FC4}"
DTS:ExecutableType="Microsoft.DbMaintenanceReindexTask"
DTS:LocaleID="-1"
DTS:ObjectName="Rebuild Index Task"
DTS:ThreadHint="0">
<DTS:Variables />
<DTS:ObjectData>
<SQLTask:SqlTaskData
SQLTask:Connection="{E1F8A8A0-B1EA-4D30-8937-5B2AF3449532}"
SQLTask:DatabaseSelectionType="4"
SQLTask:TableSelectionType="1"
SQLTask:ObjectType="0"
SQLTask:ServerVersion="13"
SQLTask:ExtendedLogging="True"
SQLTask:LocalConnectionForLogging=""
SQLTask:TaskName=""
SQLTask:IgnoreDatabasesInNotOnlineState="False"
SQLTask:UseOriginalAmount="True"
SQLTask:Percentage="20"
SQLTask:Sort="True"
SQLTask:KeepOnline="False"
SQLTask:SkipUnsupported="False"
SQLTask:PadIndex="True"
SQLTask:MaximumDegreeOfParallelismUsed="False"
SQLTask:LowPriorityUsed="False"
SQLTask:CheckFragmentationPercentUsed="True"
SQLTask:CheckPageCountUsed="False"
SQLTask:FragmentationOp="Fast"
SQLTask:FragmentationPercent="15"
SQLTask:CheckLastUsageInDaysUsed="False" xmlns:SQLTask="www.microsoft.com/sqlserver/dts/tasks/sqltask">
<SQLTask:SelectedDatabases
SQLTask:DatabaseName="CBOPC_EPRS" />
<SQLTask:SelectedTables
SQLTask:TableName="App.BatchLogs" />
<SQLTask:SelectedTables
SQLTask:TableName="App.DimDurationPeriods" />
<SQLTask:SelectedTables
SQLTask:TableName="App.OneConsults" />
<SQLTask:SelectedTables
SQLTask:TableName="App.Regions" />
<SQLTask:SelectedTables
SQLTask:TableName="App.RequestServices" />
<SQLTask:SelectedTables
SQLTask:TableName="App.Stations" />
<SQLTask:SelectedTables
SQLTask:TableName="App.StatusTypes" />
<SQLTask:SelectedTables
SQLTask:TableName="App.Visns" />
<SQLTask:SelectedTables
SQLTask:TableName="zraw._conConsult" />
</SQLTask:SqlTaskData>
</DTS:ObjectData>
</DTS:Executable>
</DTS:Executables>
<DTS:PrecedenceConstraints>
<DTS:PrecedenceConstraint
DTS:refId="Package.PrecedenceConstraints[Constraint]"
DTS:CreationName=""
DTS:DTSID="{08E28DF7-1DD1-4986-BB90-87EC5ED8201D}"
DTS:From="Package\Execute SQL Task"
DTS:LogicalAnd="True"
DTS:ObjectName="Constraint"
DTS:To="Package\Rebuild Index Task" />
</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="4" 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">
<NodeLayout
Size="164,42"
Id="Package\Execute SQL Task"
TopLeft="116.571430556628,61.1764714462122" />
<NodeLayout
Size="170,42"
Id="Package\Rebuild Index Task"
TopLeft="193.14286043206,172.517649478318" />
<EdgeLayout
Id="Package.PrecedenceConstraints[Constraint]"
TopLeft="198.571430556628,102.776471446212">
<EdgeLayout.Curve>
<mssgle:Curve
StartConnector="{x:Null}"
EndConnector="79.7714298754324,69.741178032106"
Start="0,0"
End="79.7714298754324,62.241178032106">
<mssgle:Curve.Segments>
<mssgle:SegmentCollection
Capacity="5">
<mssgle:LineSegment
End="0,30.870589016053" />
<mssgle:CubicBezierSegment
Point1="0,30.870589016053"
Point2="0,34.870589016053"
Point3="4,34.870589016053" />
<mssgle:LineSegment
End="75.7714298754324,34.870589016053" />
<mssgle:CubicBezierSegment
Point1="75.7714298754324,34.870589016053"
Point2="79.7714298754324,34.870589016053"
Point3="79.7714298754324,38.870589016053" />
<mssgle:LineSegment
End="79.7714298754324,62.241178032106" />
</mssgle:SegmentCollection>
</mssgle:Curve.Segments>
</mssgle:Curve>
</EdgeLayout.Curve>
<EdgeLayout.Labels>
<EdgeLabelCollection />
</EdgeLayout.Labels>
</EdgeLayout>
</GraphLayout>
</LayoutInfo>
</Package>
</Objects>]]></DTS:DesignTimeProperties>
</DTS:Executable>