Summary Table
Categories |
Total Count |
PII |
1 |
URL |
3 |
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="{77438C96-C4AD-4235-AFB4-D115B4ACCEF8}"
DTS:ExecutableType="Microsoft.Package"
DTS:LastModifiedProductVersion="14.0.3002.92"
DTS:LocaleID="1033"
DTS:ObjectName="extCon_OneConsultSyncShadow"
DTS:PackageType="5"
DTS:ProtectionLevel="0"
DTS:VersionBuild="7"
DTS:VersionGUID="{BF21E866-7996-40A3-B437-87A8322B0500}">
<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="{61AA110C-E3F5-4861-AC19-60F0C7CF02A0}"
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:ConnectionManagers>
<DTS:Variables />
<DTS:Executables>
<DTS:Executable
DTS:refId="Package\Execute SQL Task"
DTS:CreationName="Microsoft.ExecuteSQLTask"
DTS:Description="Execute SQL Task"
DTS:DTSID="{46D77025-9A04-41BB-8FAC-778E8500B893}"
DTS:ExecutableType="Microsoft.ExecuteSQLTask"
DTS:LocaleID="-1"
DTS:ObjectName="Execute SQL Task"
DTS:ThreadHint="0">
<DTS:Variables />
<DTS:ObjectData>
<SQLTask:SqlTaskData
SQLTask:Connection="{356C7A9E-5B7E-4A1C-BE76-9B6781E71E73}"
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="{720C6ECE-6930-4E67-A1DF-9A7C7DF0EE03}"
DTS:ExecutableType="Microsoft.DbMaintenanceReindexTask"
DTS:LocaleID="-1"
DTS:ObjectName="Rebuild Index Task"
DTS:ThreadHint="0">
<DTS:Variables />
<DTS:ObjectData>
<SQLTask:SqlTaskData
SQLTask:Connection="{61AA110C-E3F5-4861-AC19-60F0C7CF02A0}"
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="30"
SQLTask:CheckLastUsageInDaysUsed="False" xmlns:SQLTask="www.microsoft.com/sqlserver/dts/tasks/sqltask">
<SQLTask:SelectedDatabases
SQLTask:DatabaseName="CBOPC_EPRS_Shadow" />
<SQLTask:SelectedTables
SQLTask:TableName="APP.BatchLogs" />
<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="{DEDFDC1D-372A-4644-95CD-B4EAB53696A4}"
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="181.714288808862,187.811767339871" />
<EdgeLayout
Id="Package.PrecedenceConstraints[Constraint]"
TopLeft="198.571430556628,102.776471446212">
<EdgeLayout.Curve>
<mssgle:Curve
StartConnector="{x:Null}"
EndConnector="68.3428582522335,85.0352958936591"
Start="0,0"
End="68.3428582522335,77.5352958936591">
<mssgle:Curve.Segments>
<mssgle:SegmentCollection
Capacity="5">
<mssgle:LineSegment
End="0,38.5176479468295" />
<mssgle:CubicBezierSegment
Point1="0,38.5176479468295"
Point2="0,42.5176479468295"
Point3="4,42.5176479468295" />
<mssgle:LineSegment
End="64.3428582522335,42.5176479468295" />
<mssgle:CubicBezierSegment
Point1="64.3428582522335,42.5176479468295"
Point2="68.3428582522335,42.5176479468295"
Point3="68.3428582522335,46.5176479468295" />
<mssgle:LineSegment
End="68.3428582522335,77.5352958936591" />
</mssgle:SegmentCollection>
</mssgle:Curve.Segments>
</mssgle:Curve>
</EdgeLayout.Curve>
<EdgeLayout.Labels>
<EdgeLabelCollection />
</EdgeLayout.Labels>
</EdgeLayout>
</GraphLayout>
</LayoutInfo>
</Package>
</Objects>]]></DTS:DesignTimeProperties>
</DTS:Executable>