500 lines
28 KiB
XML
500 lines
28 KiB
XML
<?xml version="1.0"?>
|
|
<DTS:Executable xmlns:DTS="www.microsoft.com/SqlServer/Dts"
|
|
DTS:refId="Package"
|
|
DTS:CreationDate="9/4/2020 8:57:56 PM"
|
|
DTS:CreationName="Microsoft.Package"
|
|
DTS:CreatorComputerName="DESKTOP-T3L61F1"
|
|
DTS:CreatorName="DESKTOP-T3L61F1\Richard"
|
|
DTS:DTSID="{D99D7963-C308-43A9-A7B4-956E3178534B}"
|
|
DTS:ExecutableType="Microsoft.Package"
|
|
DTS:LastModifiedProductVersion="15.0.2000.128"
|
|
DTS:LocaleID="2057"
|
|
DTS:ObjectName="CopyProductCategory"
|
|
DTS:PackageType="5"
|
|
DTS:VersionBuild="8"
|
|
DTS:VersionGUID="{0BEEFFF7-A042-4855-8EF6-194FDD3AFF3F}">
|
|
<DTS:Property
|
|
DTS:Name="PackageFormatVersion">8</DTS:Property>
|
|
<DTS:ConnectionManagers>
|
|
<DTS:ConnectionManager
|
|
DTS:refId="Package.ConnectionManagers[AzureDataLakeStorage]"
|
|
DTS:CreationName="AzureStorage"
|
|
DTS:DTSID="{CE6BCC6D-5540-4A57-8FBB-B8552CFEAF47}"
|
|
DTS:ObjectName="AzureDataLakeStorage">
|
|
<DTS:ObjectData>
|
|
<AzureStorageConnectionManager
|
|
ConnectionString="ServiceType=AzureBlobFS;ConnectUsingManagedIdentity=True;AccountName=mydatalakestorage;DefaultEndpointsProtocol=https;EndpointSuffix=core.windows.net;"
|
|
ConnectByProxy="False">
|
|
<AccountKey
|
|
Sensitive="1"
|
|
Encrypted="1">AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAALRKo0Vm/BkOsUrO9CQkY/QAAAAAIAAAARABUAFMAAAAQZgAAAAEAACAAAAAj9D/6eDUxpBbXGcJVL6vp82ez2ul3aK+Ni8U5W7zFVQAAAAAOgAAAAAIAACAAAABbwz4bLoC0/FHBR4yRUyHat9AZ1Zzq+cGQqCe+uQ7BwzAAAABgM//i+vUc1m9CFcoSVna6Ln4M/it1TGx3a75R5g74fhEyHQtIR/ghZfvnAWMnQDJAAAAAB1yg/8cBdcctyLfS9gVtvZhKCsK2yEAN94vaqS1BKLwR8ILLQbLlTuTJBvTvQHQb0YOEcv9gE7nddLKCzX0Tng</AccountKey>
|
|
</AzureStorageConnectionManager>
|
|
</DTS:ObjectData>
|
|
</DTS:ConnectionManager>
|
|
<DTS:ConnectionManager
|
|
DTS:refId="Package.ConnectionManagers[AzureSqlDatabase]"
|
|
DTS:CreationName="OLEDB"
|
|
DTS:DTSID="{A4646A57-6C18-4A9E-A828-05FD91809D1F}"
|
|
DTS:ObjectName="AzureSqlDatabase">
|
|
<DTS:ObjectData>
|
|
<DTS:ConnectionManager
|
|
DTS:ConnectionString="Data Source=myazuresqlserver.database.windows.net;User ID=sqlserverlogin;Initial Catalog=AdventureWorks;Provider=SQLNCLI11.1;Auto Translate=False;" />
|
|
</DTS:ObjectData>
|
|
</DTS:ConnectionManager>
|
|
</DTS:ConnectionManagers>
|
|
<DTS:Variables />
|
|
<DTS:Executables>
|
|
<DTS:Executable
|
|
DTS:refId="Package\DFT Copy ProductCategory"
|
|
DTS:CreationName="Microsoft.Pipeline"
|
|
DTS:Description="Data Flow Task"
|
|
DTS:DTSID="{4E048A3D-6910-4E4D-A6C9-7FECB633672E}"
|
|
DTS:ExecutableType="Microsoft.Pipeline"
|
|
DTS:LocaleID="-1"
|
|
DTS:ObjectName="DFT Copy ProductCategory"
|
|
DTS:TaskContact="Performs high-performance data extraction, transformation and loading;Microsoft Corporation; Microsoft SQL Server; (C) Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1">
|
|
<DTS:Variables />
|
|
<DTS:ObjectData>
|
|
<pipeline
|
|
version="1">
|
|
<components>
|
|
<component
|
|
refId="Package\DFT Copy ProductCategory\FFD lakeroot_Raw"
|
|
componentClassID="Microsoft.ManagedComponentHost"
|
|
contactInfo="MicrosoftContactInfo"
|
|
description="Loads data into a file on various supported storage services, such as Azure Blob Storage and Azure Data Lake Storage Gen2. The supported file formats are: Text, Avro, Orc, and Parquet."
|
|
name="FFD lakeroot_Raw"
|
|
validateExternalMetadata="False">
|
|
<properties>
|
|
<property
|
|
dataType="System.Int32"
|
|
description="Connection manager type"
|
|
name="ConnectionManagerType">0</property>
|
|
<property
|
|
dataType="System.String"
|
|
description="Folder Path"
|
|
expressionType="Notify"
|
|
name="FolderPath">/lakeroot/Raw</property>
|
|
<property
|
|
dataType="System.String"
|
|
description="File Name"
|
|
expressionType="Notify"
|
|
name="FileName">SalesLT.ProductCategory.txt</property>
|
|
<property
|
|
dataType="System.Int32"
|
|
description="File Format"
|
|
name="FileFormat">0</property>
|
|
<property
|
|
dataType="System.String"
|
|
description="The character used to delimit columns in a file"
|
|
name="ColumnDelimiter">,</property>
|
|
<property
|
|
dataType="System.Boolean"
|
|
description="Column names in the first data row"
|
|
expressionType="Notify"
|
|
name="FirstRowAsColumnNames">true</property>
|
|
<property
|
|
dataType="System.Boolean"
|
|
description="Compress File"
|
|
name="CompressFile">false</property>
|
|
<property
|
|
dataType="System.Int32"
|
|
description="Compress Type"
|
|
name="CompressionType">0</property>
|
|
<property
|
|
dataType="System.Int32"
|
|
description="Compress Level"
|
|
name="CompressionLevel">0</property>
|
|
<property
|
|
dataType="System.String"
|
|
description="The character used to separate rows in a file"
|
|
name="RowDelimiter"></property>
|
|
<property
|
|
dataType="System.String"
|
|
description="The special character used to escape a column delimiter in the content of input file"
|
|
name="EscapeChar"></property>
|
|
<property
|
|
dataType="System.String"
|
|
description="The character used to quote a string value"
|
|
name="QuoteChar"></property>
|
|
<property
|
|
dataType="System.String"
|
|
description="One or more characters used to represent a null value"
|
|
name="NullValue">\N</property>
|
|
<property
|
|
dataType="System.String"
|
|
description="Specify the encoding name"
|
|
name="EncodingName">UTF-8</property>
|
|
<property
|
|
dataType="System.Int32"
|
|
description="Indicates the number of non-empty rows to skip when reading data from input files"
|
|
expressionType="Notify"
|
|
name="SkipLineCount">0</property>
|
|
<property
|
|
dataType="System.Boolean"
|
|
description="Specifies whether to treat null or empty string as a null value when reading data from an input file"
|
|
name="TreatEmptyAsNull">true</property>
|
|
<property
|
|
dataType="System.String"
|
|
name="UserComponentTypeName">ExtFileDest</property>
|
|
</properties>
|
|
<connections>
|
|
<connection
|
|
refId="Package\DFT Copy ProductCategory\FFD lakeroot_Raw.Connections[ConnectionManager]"
|
|
connectionManagerID="Package.ConnectionManagers[AzureDataLakeStorage]"
|
|
connectionManagerRefId="Package.ConnectionManagers[AzureDataLakeStorage]"
|
|
description="Connection manager name"
|
|
name="ConnectionManager" />
|
|
</connections>
|
|
<inputs>
|
|
<input
|
|
refId="Package\DFT Copy ProductCategory\FFD lakeroot_Raw.Inputs[Input]"
|
|
hasSideEffects="true"
|
|
name="Input">
|
|
<inputColumns>
|
|
<inputColumn
|
|
refId="Package\DFT Copy ProductCategory\FFD lakeroot_Raw.Inputs[Input].Columns[ProductCategoryID]"
|
|
cachedDataType="i4"
|
|
cachedName="ProductCategoryID"
|
|
externalMetadataColumnId="Package\DFT Copy ProductCategory\FFD lakeroot_Raw.Inputs[Input].ExternalColumns[ProductCategoryID]"
|
|
lineageId="Package\DFT Copy ProductCategory\OLEDB_Src ProductCategory.Outputs[OLE DB Source Output].Columns[ProductCategoryID]" />
|
|
<inputColumn
|
|
refId="Package\DFT Copy ProductCategory\FFD lakeroot_Raw.Inputs[Input].Columns[ParentProductCategoryID]"
|
|
cachedDataType="i4"
|
|
cachedName="ParentProductCategoryID"
|
|
externalMetadataColumnId="Package\DFT Copy ProductCategory\FFD lakeroot_Raw.Inputs[Input].ExternalColumns[ParentProductCategoryID]"
|
|
lineageId="Package\DFT Copy ProductCategory\OLEDB_Src ProductCategory.Outputs[OLE DB Source Output].Columns[ParentProductCategoryID]" />
|
|
<inputColumn
|
|
refId="Package\DFT Copy ProductCategory\FFD lakeroot_Raw.Inputs[Input].Columns[Name]"
|
|
cachedDataType="wstr"
|
|
cachedLength="50"
|
|
cachedName="Name"
|
|
externalMetadataColumnId="Package\DFT Copy ProductCategory\FFD lakeroot_Raw.Inputs[Input].ExternalColumns[Name]"
|
|
lineageId="Package\DFT Copy ProductCategory\OLEDB_Src ProductCategory.Outputs[OLE DB Source Output].Columns[Name]" />
|
|
<inputColumn
|
|
refId="Package\DFT Copy ProductCategory\FFD lakeroot_Raw.Inputs[Input].Columns[rowguid]"
|
|
cachedDataType="guid"
|
|
cachedName="rowguid"
|
|
externalMetadataColumnId="Package\DFT Copy ProductCategory\FFD lakeroot_Raw.Inputs[Input].ExternalColumns[rowguid]"
|
|
lineageId="Package\DFT Copy ProductCategory\OLEDB_Src ProductCategory.Outputs[OLE DB Source Output].Columns[rowguid]" />
|
|
<inputColumn
|
|
refId="Package\DFT Copy ProductCategory\FFD lakeroot_Raw.Inputs[Input].Columns[ModifiedDate]"
|
|
cachedDataType="dbTimeStamp"
|
|
cachedName="ModifiedDate"
|
|
externalMetadataColumnId="Package\DFT Copy ProductCategory\FFD lakeroot_Raw.Inputs[Input].ExternalColumns[ModifiedDate]"
|
|
lineageId="Package\DFT Copy ProductCategory\OLEDB_Src ProductCategory.Outputs[OLE DB Source Output].Columns[ModifiedDate]" />
|
|
</inputColumns>
|
|
<externalMetadataColumns
|
|
isUsed="True">
|
|
<externalMetadataColumn
|
|
refId="Package\DFT Copy ProductCategory\FFD lakeroot_Raw.Inputs[Input].ExternalColumns[ProductCategoryID]"
|
|
dataType="i4"
|
|
name="ProductCategoryID" />
|
|
<externalMetadataColumn
|
|
refId="Package\DFT Copy ProductCategory\FFD lakeroot_Raw.Inputs[Input].ExternalColumns[ParentProductCategoryID]"
|
|
dataType="i4"
|
|
name="ParentProductCategoryID" />
|
|
<externalMetadataColumn
|
|
refId="Package\DFT Copy ProductCategory\FFD lakeroot_Raw.Inputs[Input].ExternalColumns[Name]"
|
|
dataType="wstr"
|
|
length="50"
|
|
name="Name" />
|
|
<externalMetadataColumn
|
|
refId="Package\DFT Copy ProductCategory\FFD lakeroot_Raw.Inputs[Input].ExternalColumns[rowguid]"
|
|
dataType="guid"
|
|
name="rowguid" />
|
|
<externalMetadataColumn
|
|
refId="Package\DFT Copy ProductCategory\FFD lakeroot_Raw.Inputs[Input].ExternalColumns[ModifiedDate]"
|
|
dataType="dbTimeStamp"
|
|
name="ModifiedDate" />
|
|
</externalMetadataColumns>
|
|
</input>
|
|
</inputs>
|
|
</component>
|
|
<component
|
|
refId="Package\DFT Copy ProductCategory\OLEDB_Src ProductCategory"
|
|
componentClassID="Microsoft.OLEDBSource"
|
|
contactInfo="OLE DB Source;Microsoft Corporation; Microsoft SQL Server; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;7"
|
|
description="OLE DB Source"
|
|
name="OLEDB_Src ProductCategory"
|
|
usesDispositions="true"
|
|
version="7">
|
|
<properties>
|
|
<property
|
|
dataType="System.Int32"
|
|
description="The number of seconds before a command times out. A value of 0 indicates an infinite time-out."
|
|
name="CommandTimeout">0</property>
|
|
<property
|
|
dataType="System.String"
|
|
description="Specifies the name of the database object used to open a rowset."
|
|
name="OpenRowset">[SalesLT].[ProductCategory]</property>
|
|
<property
|
|
dataType="System.String"
|
|
description="Specifies the variable that contains the name of the database object used to open a rowset."
|
|
name="OpenRowsetVariable"></property>
|
|
<property
|
|
dataType="System.String"
|
|
description="The SQL command to be executed."
|
|
name="SqlCommand"
|
|
UITypeEditor="Microsoft.DataTransformationServices.Controls.ModalMultilineStringEditor, Microsoft.DataTransformationServices.Controls, Version=15.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"></property>
|
|
<property
|
|
dataType="System.String"
|
|
description="The variable that contains the SQL command to be executed."
|
|
name="SqlCommandVariable"></property>
|
|
<property
|
|
dataType="System.Int32"
|
|
description="Specifies the column code page to use when code page information is unavailable from the data source."
|
|
name="DefaultCodePage">1252</property>
|
|
<property
|
|
dataType="System.Boolean"
|
|
description="Forces the use of the DefaultCodePage property value when describing character data."
|
|
name="AlwaysUseDefaultCodePage">false</property>
|
|
<property
|
|
dataType="System.Int32"
|
|
description="Specifies the mode used to access the database."
|
|
name="AccessMode"
|
|
typeConverter="AccessMode">0</property>
|
|
<property
|
|
dataType="System.String"
|
|
description="The mappings between the parameters in the SQL command and variables."
|
|
name="ParameterMapping"></property>
|
|
</properties>
|
|
<connections>
|
|
<connection
|
|
refId="Package\DFT Copy ProductCategory\OLEDB_Src ProductCategory.Connections[OleDbConnection]"
|
|
connectionManagerID="Package.ConnectionManagers[AzureSqlDatabase]"
|
|
connectionManagerRefId="Package.ConnectionManagers[AzureSqlDatabase]"
|
|
description="The OLE DB runtime connection used to access the database."
|
|
name="OleDbConnection" />
|
|
</connections>
|
|
<outputs>
|
|
<output
|
|
refId="Package\DFT Copy ProductCategory\OLEDB_Src ProductCategory.Outputs[OLE DB Source Output]"
|
|
name="OLE DB Source Output">
|
|
<outputColumns>
|
|
<outputColumn
|
|
refId="Package\DFT Copy ProductCategory\OLEDB_Src ProductCategory.Outputs[OLE DB Source Output].Columns[ProductCategoryID]"
|
|
dataType="i4"
|
|
errorOrTruncationOperation="Conversion"
|
|
errorRowDisposition="FailComponent"
|
|
externalMetadataColumnId="Package\DFT Copy ProductCategory\OLEDB_Src ProductCategory.Outputs[OLE DB Source Output].ExternalColumns[ProductCategoryID]"
|
|
lineageId="Package\DFT Copy ProductCategory\OLEDB_Src ProductCategory.Outputs[OLE DB Source Output].Columns[ProductCategoryID]"
|
|
name="ProductCategoryID"
|
|
truncationRowDisposition="FailComponent" />
|
|
<outputColumn
|
|
refId="Package\DFT Copy ProductCategory\OLEDB_Src ProductCategory.Outputs[OLE DB Source Output].Columns[ParentProductCategoryID]"
|
|
dataType="i4"
|
|
errorOrTruncationOperation="Conversion"
|
|
errorRowDisposition="FailComponent"
|
|
externalMetadataColumnId="Package\DFT Copy ProductCategory\OLEDB_Src ProductCategory.Outputs[OLE DB Source Output].ExternalColumns[ParentProductCategoryID]"
|
|
lineageId="Package\DFT Copy ProductCategory\OLEDB_Src ProductCategory.Outputs[OLE DB Source Output].Columns[ParentProductCategoryID]"
|
|
name="ParentProductCategoryID"
|
|
truncationRowDisposition="FailComponent" />
|
|
<outputColumn
|
|
refId="Package\DFT Copy ProductCategory\OLEDB_Src ProductCategory.Outputs[OLE DB Source Output].Columns[Name]"
|
|
dataType="wstr"
|
|
errorOrTruncationOperation="Conversion"
|
|
errorRowDisposition="FailComponent"
|
|
externalMetadataColumnId="Package\DFT Copy ProductCategory\OLEDB_Src ProductCategory.Outputs[OLE DB Source Output].ExternalColumns[Name]"
|
|
length="50"
|
|
lineageId="Package\DFT Copy ProductCategory\OLEDB_Src ProductCategory.Outputs[OLE DB Source Output].Columns[Name]"
|
|
name="Name"
|
|
truncationRowDisposition="FailComponent" />
|
|
<outputColumn
|
|
refId="Package\DFT Copy ProductCategory\OLEDB_Src ProductCategory.Outputs[OLE DB Source Output].Columns[rowguid]"
|
|
dataType="guid"
|
|
errorOrTruncationOperation="Conversion"
|
|
errorRowDisposition="FailComponent"
|
|
externalMetadataColumnId="Package\DFT Copy ProductCategory\OLEDB_Src ProductCategory.Outputs[OLE DB Source Output].ExternalColumns[rowguid]"
|
|
lineageId="Package\DFT Copy ProductCategory\OLEDB_Src ProductCategory.Outputs[OLE DB Source Output].Columns[rowguid]"
|
|
name="rowguid"
|
|
truncationRowDisposition="FailComponent" />
|
|
<outputColumn
|
|
refId="Package\DFT Copy ProductCategory\OLEDB_Src ProductCategory.Outputs[OLE DB Source Output].Columns[ModifiedDate]"
|
|
dataType="dbTimeStamp"
|
|
errorOrTruncationOperation="Conversion"
|
|
errorRowDisposition="FailComponent"
|
|
externalMetadataColumnId="Package\DFT Copy ProductCategory\OLEDB_Src ProductCategory.Outputs[OLE DB Source Output].ExternalColumns[ModifiedDate]"
|
|
lineageId="Package\DFT Copy ProductCategory\OLEDB_Src ProductCategory.Outputs[OLE DB Source Output].Columns[ModifiedDate]"
|
|
name="ModifiedDate"
|
|
truncationRowDisposition="FailComponent" />
|
|
</outputColumns>
|
|
<externalMetadataColumns
|
|
isUsed="True">
|
|
<externalMetadataColumn
|
|
refId="Package\DFT Copy ProductCategory\OLEDB_Src ProductCategory.Outputs[OLE DB Source Output].ExternalColumns[ProductCategoryID]"
|
|
dataType="i4"
|
|
name="ProductCategoryID" />
|
|
<externalMetadataColumn
|
|
refId="Package\DFT Copy ProductCategory\OLEDB_Src ProductCategory.Outputs[OLE DB Source Output].ExternalColumns[ParentProductCategoryID]"
|
|
dataType="i4"
|
|
name="ParentProductCategoryID" />
|
|
<externalMetadataColumn
|
|
refId="Package\DFT Copy ProductCategory\OLEDB_Src ProductCategory.Outputs[OLE DB Source Output].ExternalColumns[Name]"
|
|
dataType="wstr"
|
|
length="50"
|
|
name="Name" />
|
|
<externalMetadataColumn
|
|
refId="Package\DFT Copy ProductCategory\OLEDB_Src ProductCategory.Outputs[OLE DB Source Output].ExternalColumns[rowguid]"
|
|
dataType="guid"
|
|
name="rowguid" />
|
|
<externalMetadataColumn
|
|
refId="Package\DFT Copy ProductCategory\OLEDB_Src ProductCategory.Outputs[OLE DB Source Output].ExternalColumns[ModifiedDate]"
|
|
dataType="dbTimeStamp"
|
|
name="ModifiedDate" />
|
|
</externalMetadataColumns>
|
|
</output>
|
|
<output
|
|
refId="Package\DFT Copy ProductCategory\OLEDB_Src ProductCategory.Outputs[OLE DB Source Error Output]"
|
|
isErrorOut="true"
|
|
name="OLE DB Source Error Output">
|
|
<outputColumns>
|
|
<outputColumn
|
|
refId="Package\DFT Copy ProductCategory\OLEDB_Src ProductCategory.Outputs[OLE DB Source Error Output].Columns[ProductCategoryID]"
|
|
dataType="i4"
|
|
lineageId="Package\DFT Copy ProductCategory\OLEDB_Src ProductCategory.Outputs[OLE DB Source Error Output].Columns[ProductCategoryID]"
|
|
name="ProductCategoryID" />
|
|
<outputColumn
|
|
refId="Package\DFT Copy ProductCategory\OLEDB_Src ProductCategory.Outputs[OLE DB Source Error Output].Columns[ParentProductCategoryID]"
|
|
dataType="i4"
|
|
lineageId="Package\DFT Copy ProductCategory\OLEDB_Src ProductCategory.Outputs[OLE DB Source Error Output].Columns[ParentProductCategoryID]"
|
|
name="ParentProductCategoryID" />
|
|
<outputColumn
|
|
refId="Package\DFT Copy ProductCategory\OLEDB_Src ProductCategory.Outputs[OLE DB Source Error Output].Columns[Name]"
|
|
dataType="wstr"
|
|
length="50"
|
|
lineageId="Package\DFT Copy ProductCategory\OLEDB_Src ProductCategory.Outputs[OLE DB Source Error Output].Columns[Name]"
|
|
name="Name" />
|
|
<outputColumn
|
|
refId="Package\DFT Copy ProductCategory\OLEDB_Src ProductCategory.Outputs[OLE DB Source Error Output].Columns[rowguid]"
|
|
dataType="guid"
|
|
lineageId="Package\DFT Copy ProductCategory\OLEDB_Src ProductCategory.Outputs[OLE DB Source Error Output].Columns[rowguid]"
|
|
name="rowguid" />
|
|
<outputColumn
|
|
refId="Package\DFT Copy ProductCategory\OLEDB_Src ProductCategory.Outputs[OLE DB Source Error Output].Columns[ModifiedDate]"
|
|
dataType="dbTimeStamp"
|
|
lineageId="Package\DFT Copy ProductCategory\OLEDB_Src ProductCategory.Outputs[OLE DB Source Error Output].Columns[ModifiedDate]"
|
|
name="ModifiedDate" />
|
|
<outputColumn
|
|
refId="Package\DFT Copy ProductCategory\OLEDB_Src ProductCategory.Outputs[OLE DB Source Error Output].Columns[ErrorCode]"
|
|
dataType="i4"
|
|
lineageId="Package\DFT Copy ProductCategory\OLEDB_Src ProductCategory.Outputs[OLE DB Source Error Output].Columns[ErrorCode]"
|
|
name="ErrorCode"
|
|
specialFlags="1" />
|
|
<outputColumn
|
|
refId="Package\DFT Copy ProductCategory\OLEDB_Src ProductCategory.Outputs[OLE DB Source Error Output].Columns[ErrorColumn]"
|
|
dataType="i4"
|
|
lineageId="Package\DFT Copy ProductCategory\OLEDB_Src ProductCategory.Outputs[OLE DB Source Error Output].Columns[ErrorColumn]"
|
|
name="ErrorColumn"
|
|
specialFlags="2" />
|
|
</outputColumns>
|
|
<externalMetadataColumns />
|
|
</output>
|
|
</outputs>
|
|
</component>
|
|
</components>
|
|
<paths>
|
|
<path
|
|
refId="Package\DFT Copy ProductCategory.Paths[OLE DB Source Output]"
|
|
endId="Package\DFT Copy ProductCategory\FFD lakeroot_Raw.Inputs[Input]"
|
|
name="OLE DB Source Output"
|
|
startId="Package\DFT Copy ProductCategory\OLEDB_Src ProductCategory.Outputs[OLE DB Source Output]" />
|
|
</paths>
|
|
</pipeline>
|
|
</DTS:ObjectData>
|
|
</DTS:Executable>
|
|
</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">
|
|
<NodeLayout
|
|
Size="214,42"
|
|
Id="Package\DFT Copy ProductCategory"
|
|
TopLeft="193,104" />
|
|
</GraphLayout>
|
|
</LayoutInfo>
|
|
</Package>
|
|
<TaskHost
|
|
design-time-name="Package\DFT Copy ProductCategory">
|
|
<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" xmlns:mssgm="clr-namespace:Microsoft.SqlServer.Graph.Model;assembly=Microsoft.SqlServer.Graph">
|
|
<NodeLayout
|
|
Size="224,42"
|
|
Id="Package\DFT Copy ProductCategory\OLEDB_Src ProductCategory"
|
|
TopLeft="401,94" />
|
|
<NodeLayout
|
|
Size="171,42"
|
|
Id="Package\DFT Copy ProductCategory\FFD lakeroot_Raw"
|
|
TopLeft="449,240" />
|
|
<EdgeLayout
|
|
Id="Package\DFT Copy ProductCategory.Paths[OLE DB Source Output]"
|
|
TopLeft="513,136">
|
|
<EdgeLayout.Curve>
|
|
<mssgle:Curve
|
|
StartConnector="{assembly:Null}"
|
|
EndConnector="21.5,104"
|
|
Start="0,0"
|
|
End="21.5,96.5">
|
|
<mssgle:Curve.Segments>
|
|
<mssgle:SegmentCollection
|
|
Capacity="5">
|
|
<mssgle:LineSegment
|
|
End="0,48" />
|
|
<mssgle:CubicBezierSegment
|
|
Point1="0,48"
|
|
Point2="0,52"
|
|
Point3="4,52" />
|
|
<mssgle:LineSegment
|
|
End="17.5,52" />
|
|
<mssgle:CubicBezierSegment
|
|
Point1="17.5,52"
|
|
Point2="21.5,52"
|
|
Point3="21.5,56" />
|
|
<mssgle:LineSegment
|
|
End="21.5,96.5" />
|
|
</mssgle:SegmentCollection>
|
|
</mssgle:Curve.Segments>
|
|
</mssgle:Curve>
|
|
</EdgeLayout.Curve>
|
|
<EdgeLayout.Labels>
|
|
<mssgm:EdgeLabel
|
|
BoundingBox="0,0,0,0"
|
|
RelativePosition="Any" />
|
|
</EdgeLayout.Labels>
|
|
</EdgeLayout>
|
|
</GraphLayout>
|
|
</LayoutInfo>
|
|
</TaskHost>
|
|
<PipelineComponentMetadata
|
|
design-time-name="Package\DFT Copy ProductCategory\FFD lakeroot_Raw">
|
|
<Properties>
|
|
<Property>
|
|
<Name>DataSourceViewID</Name>
|
|
</Property>
|
|
</Properties>
|
|
</PipelineComponentMetadata>
|
|
<PipelineComponentMetadata
|
|
design-time-name="Package\DFT Copy ProductCategory\OLEDB_Src ProductCategory">
|
|
<Properties>
|
|
<Property>
|
|
<Name>DataSourceViewID</Name>
|
|
</Property>
|
|
<Property>
|
|
<Name>TableInfoObjectType</Name>
|
|
<Value
|
|
type="q2:string">Table</Value>
|
|
</Property>
|
|
</Properties>
|
|
</PipelineComponentMetadata>
|
|
</Objects>]]></DTS:DesignTimeProperties>
|
|
</DTS:Executable> |