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******
1. Find _extChildOLEDBFlow_clonethis.dtsx in the list and right-click-->Copy
2. Find the folder SSIS Packages and right-click-->Paste
3. Find the newly created file (e.g., _extChildOLEDBFlow--clonethis 1.dtsx), right-click-->Rename
4. Rename the file to something that starts with cext (e.g., extFBCSUB92Claims.dtsx)

5. Open up the newly cloned file
6. Right-click Open Variables (looks like an eraser, right hand corner)
7. Change rawTableName and sourceTableName
8. *Update the OLEDB Source; remember to update the parameters as needed.
9. *Easier to delete and re-create the OLEDB Destination, because the new OLEDB Destinationn will automatically hook the source fields in
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>