forked from thamunkpillai/webapplication
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathTransformLayer1.dtsx
More file actions
125 lines (125 loc) · 5.09 KB
/
TransformLayer1.dtsx
File metadata and controls
125 lines (125 loc) · 5.09 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
<?xml version="1.0"?>
<DTS:Executable xmlns:DTS="www.microsoft.com/SqlServer/Dts"
DTS:refId="Package"
DTS:CreationDate="6/28/2023 12:26:48 PM"
DTS:CreationName="Microsoft.Package"
DTS:CreatorComputerName="AUTOPORPEEET6FB"
DTS:CreatorName="CONDUENT\C5147500"
DTS:DTSID="{E0492271-1FD0-4C99-9271-D8344A6BB6C5}"
DTS:ExecutableType="Microsoft.Package"
DTS:LastModifiedProductVersion="16.0.5035.3"
DTS:LocaleID="1033"
DTS:ObjectName="Package1"
DTS:PackageType="5"
DTS:VersionBuild="1"
DTS:VersionGUID="{2792300A-6002-42C2-BE27-E905037D66BE}">
<DTS:Property
DTS:Name="PackageFormatVersion">8</DTS:Property>
<DTS:Variables />
<DTS:Executables>
<DTS:Executable
DTS:refId="Package\Load dimension table"
DTS:CreationName="STOCK:SEQUENCE"
DTS:Description="Sequence Container"
DTS:DTSID="{7C686650-2EDB-457F-B845-0B60AB197F84}"
DTS:ExecutableType="STOCK:SEQUENCE"
DTS:LocaleID="-1"
DTS:ObjectName="Load dimension table">
<DTS:Variables />
<DTS:Executables>
<DTS:Executable
DTS:refId="Package\Load dimension table\Execute SQL Task"
DTS:CreationName="Microsoft.ExecuteSQLTask"
DTS:Description="Execute SQL Task"
DTS:DTSID="{DEAE4993-9311-4958-A000-7C1B7CB845B0}"
DTS:ExecutableType="Microsoft.ExecuteSQLTask"
DTS:LocaleID="-1"
DTS:ObjectName="Execute SQL Task"
DTS:TaskContact="Execute SQL Task; Microsoft Corporation; SQL Server 2022; © 2022 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1"
DTS:ThreadHint="0">
<DTS:Variables />
<DTS:ObjectData>
<SQLTask:SqlTaskData xmlns:SQLTask="www.microsoft.com/sqlserver/dts/tasks/sqltask" />
</DTS:ObjectData>
</DTS:Executable>
</DTS:Executables>
</DTS:Executable>
<DTS:Executable
DTS:refId="Package\Load Fact table"
DTS:CreationName="STOCK:SEQUENCE"
DTS:Description="Sequence Container"
DTS:DTSID="{B92AA9F9-3341-4BC0-9BDF-FE8D354FEF61}"
DTS:ExecutableType="STOCK:SEQUENCE"
DTS:LocaleID="-1"
DTS:ObjectName="Load Fact table">
<DTS:Variables />
<DTS:Executables />
</DTS:Executable>
</DTS:Executables>
<DTS:PrecedenceConstraints>
<DTS:PrecedenceConstraint
DTS:refId="Package.PrecedenceConstraints[Constraint]"
DTS:CreationName=""
DTS:DTSID="{07767CC6-D603-4DA9-8A15-3A579AC0A937}"
DTS:From="Package\Load dimension table"
DTS:LogicalAnd="True"
DTS:ObjectName="Constraint"
DTS:To="Package\Load Fact table" />
</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:assembly="http://schemas.microsoft.com/winfx/2006/xaml">
<NodeLayout
Size="170,42"
Id="Package\Load dimension table\Execute SQL Task"
TopLeft="34,44" />
<ContainerLayout
HeaderHeight="43"
IsExpanded="True"
PanelSize="831,270"
Size="831,313"
Id="Package\Load dimension table"
TopLeft="228,73" />
<ContainerLayout
HeaderHeight="43"
IsExpanded="True"
PanelSize="835,132"
Size="835,175"
Id="Package\Load Fact table"
TopLeft="230,469" />
<EdgeLayout
Id="Package.PrecedenceConstraints[Constraint]"
TopLeft="645.5,386">
<EdgeLayout.Curve>
<mssgle:Curve
StartConnector="{assembly:Null}"
EndConnector="0,83"
Start="0,0"
End="0,75.5">
<mssgle:Curve.Segments>
<mssgle:SegmentCollection
Capacity="5">
<mssgle:LineSegment
End="0,75.5" />
</mssgle:SegmentCollection>
</mssgle:Curve.Segments>
</mssgle:Curve>
</EdgeLayout.Curve>
<EdgeLayout.Labels>
<EdgeLabelCollection />
</EdgeLayout.Labels>
</EdgeLayout>
</GraphLayout>
</LayoutInfo>
</Package>
</Objects>]]></DTS:DesignTimeProperties>
</DTS:Executable>