Summary Table

Categories Total Count
PII 1
URL 0
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="6/14/2018 12:30:34 PM"
DTS:CreationName=""
DTS:CreatorComputerName="
DNS "
DTS:CreatorName="
PII "
DTS:DTSID="{837572D9-4D6F-4E6F-8EA3-105FFF6D94BA}"
DTS:ExecutableType=""
DTS:LastModifiedProductVersion="14.0.3002.68"
DTS:LocaleID="1033"
DTS:ObjectName="__README_ChildFlow_ExtractCookieCutter"
DTS:PackageType="5"
DTS:ProtectionLevel="0"
DTS:VersionBuild="7"
DTS:VersionGUID="{55736490-4A79-4492-8D9D-1933BBC679DB}">
<DTS:Property
DTS:Name="PackageFormatVersion">8</DTS:Property>
<DTS:Variables />
<DTS:Executables />
<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:assembly="http://schemas.microsoft.com/winfx/2006/xaml">
<AnnotationLayout
Text="******Steps for cloning / modifying the Child Flow Extract cookie cutter******&#xA;1. Find _extChildOLEDBFlow_clonethis.dtsx in the list and right-click--&gt;Copy&#xA;2. Find the folder SSIS Packages and right-click--&gt;Paste&#xA;3. Find the newly created file (e.g., _extChildOLEDBFlow--clonethis 1.dtsx), right-click--&gt;Rename&#xA;4. Rename the file to something that starts with cext (e.g., extFBCSUB92Claims.dtsx)&#xA;&#xA;5. Open up the newly cloned file&#xA;6. Right-click Open Variables (looks like an eraser, right hand corner)&#xA;7. Change rawTableName and sourceTableName&#xA;8. *Update the OLEDB Source; remember to update the parameters as needed.&#xA;9. *Easier to delete and re-create the OLEDB Destination, because the new OLEDB Destinationn will automatically hook the source fields in&#xA;10. **Modify the SQL Statement for the Get Max Source BatchID and Batch Count"
ParentId="Package"
FontInfo="{assembly:Null}"
Size="759,218"
Id="87c91725-a2db-4e0f-9a5a-fdcf90f7978c"
TopLeft="60,60" />
</GraphLayout>
</LayoutInfo>
</Package>
</Objects>]]></DTS:DesignTimeProperties>
</DTS:Executable>