forked from s26450/hurtownia
880 lines
47 KiB
XML
880 lines
47 KiB
XML
<?xml version="1.0"?>
|
|
<DTS:Executable xmlns:DTS="www.microsoft.com/SqlServer/Dts"
|
|
DTS:refId="Package"
|
|
DTS:CreationDate="11/18/2018 2:33:38 PM"
|
|
DTS:CreationName="Microsoft.Package"
|
|
DTS:CreatorComputerName="PCD3O"
|
|
DTS:CreatorName="LABS\s26450"
|
|
DTS:DTSID="{87E587BC-9803-4C19-A99C-E8A52B6E204A}"
|
|
DTS:ExecutableType="Microsoft.Package"
|
|
DTS:LastModifiedProductVersion="14.0.0800.60"
|
|
DTS:LocaleID="1045"
|
|
DTS:ObjectName="dimsfacts"
|
|
DTS:PackageType="5"
|
|
DTS:VersionBuild="13"
|
|
DTS:VersionGUID="{6A206F36-0ECB-45FA-88EB-6B1397398924}">
|
|
<DTS:Property
|
|
DTS:Name="PackageFormatVersion">8</DTS:Property>
|
|
<DTS:ConnectionManagers>
|
|
<DTS:ConnectionManager
|
|
DTS:refId="Package.ConnectionManagers[Factories TSV]"
|
|
DTS:CreationName="FLATFILE"
|
|
DTS:DTSID="{C6155ACC-795D-418F-9E33-45EA91196C0B}"
|
|
DTS:ObjectName="Factories TSV">
|
|
<DTS:ObjectData>
|
|
<DTS:ConnectionManager
|
|
DTS:Format="Delimited"
|
|
DTS:LocaleID="1045"
|
|
DTS:HeaderRowDelimiter="_x000D__x000A_"
|
|
DTS:RowDelimiter=""
|
|
DTS:TextQualifier="_x003C_none_x003E_"
|
|
DTS:CodePage="65001"
|
|
DTS:ConnectionString="J:\source\repos\hurtowania_roche\Hurtowania Roche\factories.tsv">
|
|
<DTS:FlatFileColumns>
|
|
<DTS:FlatFileColumn
|
|
DTS:ColumnType="Delimited"
|
|
DTS:ColumnDelimiter="_x0009_"
|
|
DTS:MaximumWidth="50"
|
|
DTS:DataType="130"
|
|
DTS:TextQualified="True"
|
|
DTS:ObjectName="factory_code"
|
|
DTS:DTSID="{5C884CAE-112A-42D7-A861-909686C0CEE7}"
|
|
DTS:CreationName="" />
|
|
<DTS:FlatFileColumn
|
|
DTS:ColumnType="Delimited"
|
|
DTS:ColumnDelimiter="_x0009_"
|
|
DTS:MaximumWidth="50"
|
|
DTS:DataType="130"
|
|
DTS:TextQualified="True"
|
|
DTS:ObjectName="factory_name"
|
|
DTS:DTSID="{1538BE83-21A2-4E28-8354-F4917515C6D6}"
|
|
DTS:CreationName="" />
|
|
<DTS:FlatFileColumn
|
|
DTS:ColumnType="Delimited"
|
|
DTS:ColumnDelimiter="_x000A_"
|
|
DTS:MaximumWidth="50"
|
|
DTS:DataType="130"
|
|
DTS:TextQualified="True"
|
|
DTS:ObjectName="factory_country"
|
|
DTS:DTSID="{4E9F2D44-2218-4419-A35D-1A6D77879A5C}"
|
|
DTS:CreationName="" />
|
|
</DTS:FlatFileColumns>
|
|
</DTS:ConnectionManager>
|
|
</DTS:ObjectData>
|
|
</DTS:ConnectionManager>
|
|
<DTS:ConnectionManager
|
|
DTS:refId="Package.ConnectionManagers[mssql-2016.labs.wmi.amu.edu.pl.bigdata_s26450]"
|
|
DTS:CreationName="OLEDB"
|
|
DTS:DTSID="{AFA67D58-6F14-49B9-9841-94E78DE3826D}"
|
|
DTS:ObjectName="mssql-2016.labs.wmi.amu.edu.pl.bigdata_s26450">
|
|
<DTS:ObjectData>
|
|
<DTS:ConnectionManager
|
|
DTS:ConnectionString="Data Source=mssql-2016.labs.wmi.amu.edu.pl;Initial Catalog=bigdata_s26450;Provider=SQLNCLI11.1;Integrated Security=SSPI;Auto Translate=False;" />
|
|
</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="{B79BBD04-7B44-4D44-A12C-8C5804CE3E1E}"
|
|
DTS:ExecutableType="Microsoft.ExecuteSQLTask"
|
|
DTS:LocaleID="-1"
|
|
DTS:ObjectName="Execute SQL Task"
|
|
DTS:TaskContact="Execute SQL Task; Microsoft Corporation; SQL Server 2017 RC1; © 2017 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1"
|
|
DTS:ThreadHint="0">
|
|
<DTS:Variables />
|
|
<DTS:ObjectData>
|
|
<SQLTask:SqlTaskData
|
|
SQLTask:Connection="{AFA67D58-6F14-49B9-9841-94E78DE3826D}"
|
|
SQLTask:SqlStatementSource="truncate table dim_factories" xmlns:SQLTask="www.microsoft.com/sqlserver/dts/tasks/sqltask" />
|
|
</DTS:ObjectData>
|
|
</DTS:Executable>
|
|
<DTS:Executable
|
|
DTS:refId="Package\load dim_factories"
|
|
DTS:CreationName="Microsoft.Pipeline"
|
|
DTS:Description="Data Flow Task"
|
|
DTS:DTSID="{FA13E9C2-ECBD-48DE-84F7-F995258A0C2D}"
|
|
DTS:ExecutableType="Microsoft.Pipeline"
|
|
DTS:LocaleID="-1"
|
|
DTS:ObjectName="load dim_factories"
|
|
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\load dim_factories\clean code"
|
|
componentClassID="Microsoft.DerivedColumn"
|
|
contactInfo="Derived Column;Microsoft Corporation; Microsoft SQL Server; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;0"
|
|
description="Creates new column values by applying expressions to transformation input columns. Create new columns or overwrite existing ones. For example, concatenate the values from the 'first name' and 'last name' column to make a 'full name' column."
|
|
name="clean code"
|
|
usesDispositions="true">
|
|
<inputs>
|
|
<input
|
|
refId="Package\load dim_factories\clean code.Inputs[Derived Column Input]"
|
|
description="Input to the Derived Column Transformation"
|
|
name="Derived Column Input">
|
|
<inputColumns>
|
|
<inputColumn
|
|
refId="Package\load dim_factories\clean code.Inputs[Derived Column Input].Columns[factory_code]"
|
|
cachedDataType="wstr"
|
|
cachedLength="50"
|
|
cachedName="factory_code"
|
|
errorOrTruncationOperation="Computation"
|
|
errorRowDisposition="FailComponent"
|
|
lineageId="Package\load dim_factories\Load Factories File.Outputs[Flat File Source Output].Columns[factory_code]"
|
|
truncationRowDisposition="FailComponent"
|
|
usageType="readWrite">
|
|
<properties>
|
|
<property
|
|
containsID="true"
|
|
dataType="System.String"
|
|
description="Derived Column Expression"
|
|
name="Expression">[UPPER]([TRIM](#{Package\load dim_factories\Load Factories File.Outputs[Flat File Source Output].Columns[factory_code]}))</property>
|
|
<property
|
|
containsID="true"
|
|
dataType="System.String"
|
|
description="Derived Column Friendly Expression"
|
|
expressionType="Notify"
|
|
name="FriendlyExpression">UPPER(TRIM(factory_code))</property>
|
|
</properties>
|
|
</inputColumn>
|
|
</inputColumns>
|
|
<externalMetadataColumns />
|
|
</input>
|
|
</inputs>
|
|
<outputs>
|
|
<output
|
|
refId="Package\load dim_factories\clean code.Outputs[Derived Column Output]"
|
|
description="Default Output of the Derived Column Transformation"
|
|
exclusionGroup="1"
|
|
name="Derived Column Output"
|
|
synchronousInputId="Package\load dim_factories\clean code.Inputs[Derived Column Input]">
|
|
<externalMetadataColumns />
|
|
</output>
|
|
<output
|
|
refId="Package\load dim_factories\clean code.Outputs[Derived Column Error Output]"
|
|
description="Error Output of the Derived Column Transformation"
|
|
exclusionGroup="1"
|
|
isErrorOut="true"
|
|
name="Derived Column Error Output"
|
|
synchronousInputId="Package\load dim_factories\clean code.Inputs[Derived Column Input]">
|
|
<outputColumns>
|
|
<outputColumn
|
|
refId="Package\load dim_factories\clean code.Outputs[Derived Column Error Output].Columns[ErrorCode]"
|
|
dataType="i4"
|
|
lineageId="Package\load dim_factories\clean code.Outputs[Derived Column Error Output].Columns[ErrorCode]"
|
|
name="ErrorCode"
|
|
specialFlags="1" />
|
|
<outputColumn
|
|
refId="Package\load dim_factories\clean code.Outputs[Derived Column Error Output].Columns[ErrorColumn]"
|
|
dataType="i4"
|
|
lineageId="Package\load dim_factories\clean code.Outputs[Derived Column Error Output].Columns[ErrorColumn]"
|
|
name="ErrorColumn"
|
|
specialFlags="2" />
|
|
</outputColumns>
|
|
<externalMetadataColumns />
|
|
</output>
|
|
</outputs>
|
|
</component>
|
|
<component
|
|
refId="Package\load dim_factories\clean country"
|
|
componentClassID="Microsoft.DerivedColumn"
|
|
contactInfo="Derived Column;Microsoft Corporation; Microsoft SQL Server; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;0"
|
|
description="Creates new column values by applying expressions to transformation input columns. Create new columns or overwrite existing ones. For example, concatenate the values from the 'first name' and 'last name' column to make a 'full name' column."
|
|
name="clean country"
|
|
usesDispositions="true">
|
|
<inputs>
|
|
<input
|
|
refId="Package\load dim_factories\clean country.Inputs[Derived Column Input]"
|
|
description="Input to the Derived Column Transformation"
|
|
name="Derived Column Input">
|
|
<inputColumns>
|
|
<inputColumn
|
|
refId="Package\load dim_factories\clean country.Inputs[Derived Column Input].Columns[factory_country]"
|
|
cachedDataType="wstr"
|
|
cachedLength="50"
|
|
cachedName="factory_country"
|
|
errorOrTruncationOperation="Computation"
|
|
errorRowDisposition="FailComponent"
|
|
lineageId="Package\load dim_factories\Load Factories File.Outputs[Flat File Source Output].Columns[factory_country]"
|
|
truncationRowDisposition="FailComponent"
|
|
usageType="readWrite">
|
|
<properties>
|
|
<property
|
|
containsID="true"
|
|
dataType="System.String"
|
|
description="Derived Column Expression"
|
|
name="Expression">[UPPER]([TRIM](#{Package\load dim_factories\Load Factories File.Outputs[Flat File Source Output].Columns[factory_country]}))</property>
|
|
<property
|
|
containsID="true"
|
|
dataType="System.String"
|
|
description="Derived Column Friendly Expression"
|
|
expressionType="Notify"
|
|
name="FriendlyExpression">UPPER(TRIM(factory_country))</property>
|
|
</properties>
|
|
</inputColumn>
|
|
</inputColumns>
|
|
<externalMetadataColumns />
|
|
</input>
|
|
</inputs>
|
|
<outputs>
|
|
<output
|
|
refId="Package\load dim_factories\clean country.Outputs[Derived Column Output]"
|
|
description="Default Output of the Derived Column Transformation"
|
|
exclusionGroup="1"
|
|
name="Derived Column Output"
|
|
synchronousInputId="Package\load dim_factories\clean country.Inputs[Derived Column Input]">
|
|
<externalMetadataColumns />
|
|
</output>
|
|
<output
|
|
refId="Package\load dim_factories\clean country.Outputs[Derived Column Error Output]"
|
|
description="Error Output of the Derived Column Transformation"
|
|
exclusionGroup="1"
|
|
isErrorOut="true"
|
|
name="Derived Column Error Output"
|
|
synchronousInputId="Package\load dim_factories\clean country.Inputs[Derived Column Input]">
|
|
<outputColumns>
|
|
<outputColumn
|
|
refId="Package\load dim_factories\clean country.Outputs[Derived Column Error Output].Columns[ErrorCode]"
|
|
dataType="i4"
|
|
lineageId="Package\load dim_factories\clean country.Outputs[Derived Column Error Output].Columns[ErrorCode]"
|
|
name="ErrorCode"
|
|
specialFlags="1" />
|
|
<outputColumn
|
|
refId="Package\load dim_factories\clean country.Outputs[Derived Column Error Output].Columns[ErrorColumn]"
|
|
dataType="i4"
|
|
lineageId="Package\load dim_factories\clean country.Outputs[Derived Column Error Output].Columns[ErrorColumn]"
|
|
name="ErrorColumn"
|
|
specialFlags="2" />
|
|
</outputColumns>
|
|
<externalMetadataColumns />
|
|
</output>
|
|
</outputs>
|
|
</component>
|
|
<component
|
|
refId="Package\load dim_factories\clean name"
|
|
componentClassID="Microsoft.DerivedColumn"
|
|
contactInfo="Derived Column;Microsoft Corporation; Microsoft SQL Server; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;0"
|
|
description="Creates new column values by applying expressions to transformation input columns. Create new columns or overwrite existing ones. For example, concatenate the values from the 'first name' and 'last name' column to make a 'full name' column."
|
|
name="clean name"
|
|
usesDispositions="true">
|
|
<inputs>
|
|
<input
|
|
refId="Package\load dim_factories\clean name.Inputs[Derived Column Input]"
|
|
description="Input to the Derived Column Transformation"
|
|
name="Derived Column Input">
|
|
<inputColumns>
|
|
<inputColumn
|
|
refId="Package\load dim_factories\clean name.Inputs[Derived Column Input].Columns[factory_name]"
|
|
cachedDataType="wstr"
|
|
cachedLength="50"
|
|
cachedName="factory_name"
|
|
errorOrTruncationOperation="Computation"
|
|
errorRowDisposition="FailComponent"
|
|
lineageId="Package\load dim_factories\Load Factories File.Outputs[Flat File Source Output].Columns[factory_name]"
|
|
truncationRowDisposition="FailComponent"
|
|
usageType="readWrite">
|
|
<properties>
|
|
<property
|
|
containsID="true"
|
|
dataType="System.String"
|
|
description="Derived Column Expression"
|
|
name="Expression">[UPPER]([TRIM](#{Package\load dim_factories\Load Factories File.Outputs[Flat File Source Output].Columns[factory_name]}))</property>
|
|
<property
|
|
containsID="true"
|
|
dataType="System.String"
|
|
description="Derived Column Friendly Expression"
|
|
expressionType="Notify"
|
|
name="FriendlyExpression">UPPER(TRIM(factory_name))</property>
|
|
</properties>
|
|
</inputColumn>
|
|
</inputColumns>
|
|
<externalMetadataColumns />
|
|
</input>
|
|
</inputs>
|
|
<outputs>
|
|
<output
|
|
refId="Package\load dim_factories\clean name.Outputs[Derived Column Output]"
|
|
description="Default Output of the Derived Column Transformation"
|
|
exclusionGroup="1"
|
|
name="Derived Column Output"
|
|
synchronousInputId="Package\load dim_factories\clean name.Inputs[Derived Column Input]">
|
|
<externalMetadataColumns />
|
|
</output>
|
|
<output
|
|
refId="Package\load dim_factories\clean name.Outputs[Derived Column Error Output]"
|
|
description="Error Output of the Derived Column Transformation"
|
|
exclusionGroup="1"
|
|
isErrorOut="true"
|
|
name="Derived Column Error Output"
|
|
synchronousInputId="Package\load dim_factories\clean name.Inputs[Derived Column Input]">
|
|
<outputColumns>
|
|
<outputColumn
|
|
refId="Package\load dim_factories\clean name.Outputs[Derived Column Error Output].Columns[ErrorCode]"
|
|
dataType="i4"
|
|
lineageId="Package\load dim_factories\clean name.Outputs[Derived Column Error Output].Columns[ErrorCode]"
|
|
name="ErrorCode"
|
|
specialFlags="1" />
|
|
<outputColumn
|
|
refId="Package\load dim_factories\clean name.Outputs[Derived Column Error Output].Columns[ErrorColumn]"
|
|
dataType="i4"
|
|
lineageId="Package\load dim_factories\clean name.Outputs[Derived Column Error Output].Columns[ErrorColumn]"
|
|
name="ErrorColumn"
|
|
specialFlags="2" />
|
|
</outputColumns>
|
|
<externalMetadataColumns />
|
|
</output>
|
|
</outputs>
|
|
</component>
|
|
<component
|
|
refId="Package\load dim_factories\Load Factories File"
|
|
componentClassID="Microsoft.FlatFileSource"
|
|
contactInfo="Flat File Source;Microsoft Corporation; Microsoft SQL Server; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;1"
|
|
description="Flat File Source"
|
|
localeId="1045"
|
|
name="Load Factories File"
|
|
usesDispositions="true"
|
|
version="1">
|
|
<properties>
|
|
<property
|
|
dataType="System.Boolean"
|
|
description="Specifies whether zero-length columns are treated as null."
|
|
name="RetainNulls">false</property>
|
|
<property
|
|
dataType="System.String"
|
|
description="Specifies the name of an output column containing the file name. If no name is specified, no output column containing the file name will be generated."
|
|
name="FileNameColumnName"></property>
|
|
</properties>
|
|
<connections>
|
|
<connection
|
|
refId="Package\load dim_factories\Load Factories File.Connections[FlatFileConnection]"
|
|
connectionManagerID="Package.ConnectionManagers[Factories TSV]"
|
|
connectionManagerRefId="Package.ConnectionManagers[Factories TSV]"
|
|
name="FlatFileConnection" />
|
|
</connections>
|
|
<outputs>
|
|
<output
|
|
refId="Package\load dim_factories\Load Factories File.Outputs[Flat File Source Output]"
|
|
name="Flat File Source Output">
|
|
<outputColumns>
|
|
<outputColumn
|
|
refId="Package\load dim_factories\Load Factories File.Outputs[Flat File Source Output].Columns[factory_code]"
|
|
dataType="wstr"
|
|
errorOrTruncationOperation="Conversion"
|
|
errorRowDisposition="FailComponent"
|
|
externalMetadataColumnId="Package\load dim_factories\Load Factories File.Outputs[Flat File Source Output].ExternalColumns[factory_code]"
|
|
length="50"
|
|
lineageId="Package\load dim_factories\Load Factories File.Outputs[Flat File Source Output].Columns[factory_code]"
|
|
name="factory_code"
|
|
truncationRowDisposition="FailComponent">
|
|
<properties>
|
|
<property
|
|
dataType="System.Boolean"
|
|
description="Indicates whether the column uses the faster, locale-neutral parsing routines."
|
|
name="FastParse">false</property>
|
|
<property
|
|
dataType="System.Boolean"
|
|
description="Indicates whether the data is in binary format."
|
|
name="UseBinaryFormat">false</property>
|
|
</properties>
|
|
</outputColumn>
|
|
<outputColumn
|
|
refId="Package\load dim_factories\Load Factories File.Outputs[Flat File Source Output].Columns[factory_name]"
|
|
dataType="wstr"
|
|
errorOrTruncationOperation="Conversion"
|
|
errorRowDisposition="FailComponent"
|
|
externalMetadataColumnId="Package\load dim_factories\Load Factories File.Outputs[Flat File Source Output].ExternalColumns[factory_name]"
|
|
length="50"
|
|
lineageId="Package\load dim_factories\Load Factories File.Outputs[Flat File Source Output].Columns[factory_name]"
|
|
name="factory_name"
|
|
truncationRowDisposition="FailComponent">
|
|
<properties>
|
|
<property
|
|
dataType="System.Boolean"
|
|
description="Indicates whether the column uses the faster, locale-neutral parsing routines."
|
|
name="FastParse">false</property>
|
|
<property
|
|
dataType="System.Boolean"
|
|
description="Indicates whether the data is in binary format."
|
|
name="UseBinaryFormat">false</property>
|
|
</properties>
|
|
</outputColumn>
|
|
<outputColumn
|
|
refId="Package\load dim_factories\Load Factories File.Outputs[Flat File Source Output].Columns[factory_country]"
|
|
dataType="wstr"
|
|
errorOrTruncationOperation="Conversion"
|
|
errorRowDisposition="FailComponent"
|
|
externalMetadataColumnId="Package\load dim_factories\Load Factories File.Outputs[Flat File Source Output].ExternalColumns[factory_country]"
|
|
length="50"
|
|
lineageId="Package\load dim_factories\Load Factories File.Outputs[Flat File Source Output].Columns[factory_country]"
|
|
name="factory_country"
|
|
truncationRowDisposition="FailComponent">
|
|
<properties>
|
|
<property
|
|
dataType="System.Boolean"
|
|
description="Indicates whether the column uses the faster, locale-neutral parsing routines."
|
|
name="FastParse">false</property>
|
|
<property
|
|
dataType="System.Boolean"
|
|
description="Indicates whether the data is in binary format."
|
|
name="UseBinaryFormat">false</property>
|
|
</properties>
|
|
</outputColumn>
|
|
</outputColumns>
|
|
<externalMetadataColumns
|
|
isUsed="True">
|
|
<externalMetadataColumn
|
|
refId="Package\load dim_factories\Load Factories File.Outputs[Flat File Source Output].ExternalColumns[factory_code]"
|
|
dataType="wstr"
|
|
length="50"
|
|
name="factory_code" />
|
|
<externalMetadataColumn
|
|
refId="Package\load dim_factories\Load Factories File.Outputs[Flat File Source Output].ExternalColumns[factory_name]"
|
|
dataType="wstr"
|
|
length="50"
|
|
name="factory_name" />
|
|
<externalMetadataColumn
|
|
refId="Package\load dim_factories\Load Factories File.Outputs[Flat File Source Output].ExternalColumns[factory_country]"
|
|
dataType="wstr"
|
|
length="50"
|
|
name="factory_country" />
|
|
</externalMetadataColumns>
|
|
</output>
|
|
<output
|
|
refId="Package\load dim_factories\Load Factories File.Outputs[Flat File Source Error Output]"
|
|
isErrorOut="true"
|
|
name="Flat File Source Error Output">
|
|
<outputColumns>
|
|
<outputColumn
|
|
refId="Package\load dim_factories\Load Factories File.Outputs[Flat File Source Error Output].Columns[Flat File Source Error Output Column]"
|
|
codePage="65001"
|
|
dataType="text"
|
|
description="Flat File Source Error Output Column"
|
|
lineageId="Package\load dim_factories\Load Factories File.Outputs[Flat File Source Error Output].Columns[Flat File Source Error Output Column]"
|
|
name="Flat File Source Error Output Column" />
|
|
<outputColumn
|
|
refId="Package\load dim_factories\Load Factories File.Outputs[Flat File Source Error Output].Columns[ErrorCode]"
|
|
dataType="i4"
|
|
lineageId="Package\load dim_factories\Load Factories File.Outputs[Flat File Source Error Output].Columns[ErrorCode]"
|
|
name="ErrorCode"
|
|
specialFlags="1" />
|
|
<outputColumn
|
|
refId="Package\load dim_factories\Load Factories File.Outputs[Flat File Source Error Output].Columns[ErrorColumn]"
|
|
dataType="i4"
|
|
lineageId="Package\load dim_factories\Load Factories File.Outputs[Flat File Source Error Output].Columns[ErrorColumn]"
|
|
name="ErrorColumn"
|
|
specialFlags="2" />
|
|
</outputColumns>
|
|
<externalMetadataColumns />
|
|
</output>
|
|
</outputs>
|
|
</component>
|
|
<component
|
|
refId="Package\load dim_factories\Save to Dim Factories Table"
|
|
componentClassID="Microsoft.OLEDBDestination"
|
|
contactInfo="OLE DB Destination;Microsoft Corporation; Microsoft SQL Server; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;4"
|
|
description="OLE DB Destination"
|
|
name="Save to Dim Factories Table"
|
|
usesDispositions="true"
|
|
version="4">
|
|
<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">[dbo].[dim_factories]</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"></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">1250</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">3</property>
|
|
<property
|
|
dataType="System.Boolean"
|
|
description="Indicates whether the values supplied for identity columns will be copied to the destination. If false, values for identity columns will be auto-generated at the destination. Applies only if fast load is turned on."
|
|
name="FastLoadKeepIdentity">false</property>
|
|
<property
|
|
dataType="System.Boolean"
|
|
description="Indicates whether the columns containing null will have null inserted in the destination. If false, columns containing null will have their default values inserted at the destination. Applies only if fast load is turned on."
|
|
name="FastLoadKeepNulls">false</property>
|
|
<property
|
|
dataType="System.String"
|
|
description="Specifies options to be used with fast load. Applies only if fast load is turned on."
|
|
name="FastLoadOptions">TABLOCK,CHECK_CONSTRAINTS</property>
|
|
<property
|
|
dataType="System.Int32"
|
|
description="Specifies when commits are issued during data insertion. A value of 0 specifies that one commit will be issued at the end of data insertion. Applies only if fast load is turned on."
|
|
name="FastLoadMaxInsertCommitSize">2147483647</property>
|
|
</properties>
|
|
<connections>
|
|
<connection
|
|
refId="Package\load dim_factories\Save to Dim Factories Table.Connections[OleDbConnection]"
|
|
connectionManagerID="Package.ConnectionManagers[mssql-2016.labs.wmi.amu.edu.pl.bigdata_s26450]"
|
|
connectionManagerRefId="Package.ConnectionManagers[mssql-2016.labs.wmi.amu.edu.pl.bigdata_s26450]"
|
|
description="The OLE DB runtime connection used to access the database."
|
|
name="OleDbConnection" />
|
|
</connections>
|
|
<inputs>
|
|
<input
|
|
refId="Package\load dim_factories\Save to Dim Factories Table.Inputs[OLE DB Destination Input]"
|
|
errorOrTruncationOperation="Insert"
|
|
errorRowDisposition="FailComponent"
|
|
hasSideEffects="true"
|
|
name="OLE DB Destination Input">
|
|
<inputColumns>
|
|
<inputColumn
|
|
refId="Package\load dim_factories\Save to Dim Factories Table.Inputs[OLE DB Destination Input].Columns[factory_name]"
|
|
cachedDataType="wstr"
|
|
cachedLength="50"
|
|
cachedName="factory_name"
|
|
externalMetadataColumnId="Package\load dim_factories\Save to Dim Factories Table.Inputs[OLE DB Destination Input].ExternalColumns[factory_name]"
|
|
lineageId="Package\load dim_factories\Load Factories File.Outputs[Flat File Source Output].Columns[factory_name]" />
|
|
<inputColumn
|
|
refId="Package\load dim_factories\Save to Dim Factories Table.Inputs[OLE DB Destination Input].Columns[factory_country]"
|
|
cachedDataType="wstr"
|
|
cachedLength="50"
|
|
cachedName="factory_country"
|
|
externalMetadataColumnId="Package\load dim_factories\Save to Dim Factories Table.Inputs[OLE DB Destination Input].ExternalColumns[factory_country]"
|
|
lineageId="Package\load dim_factories\Load Factories File.Outputs[Flat File Source Output].Columns[factory_country]" />
|
|
<inputColumn
|
|
refId="Package\load dim_factories\Save to Dim Factories Table.Inputs[OLE DB Destination Input].Columns[factory_code]"
|
|
cachedDataType="wstr"
|
|
cachedLength="50"
|
|
cachedName="factory_code"
|
|
externalMetadataColumnId="Package\load dim_factories\Save to Dim Factories Table.Inputs[OLE DB Destination Input].ExternalColumns[factory_bk]"
|
|
lineageId="Package\load dim_factories\Load Factories File.Outputs[Flat File Source Output].Columns[factory_code]" />
|
|
</inputColumns>
|
|
<externalMetadataColumns
|
|
isUsed="True">
|
|
<externalMetadataColumn
|
|
refId="Package\load dim_factories\Save to Dim Factories Table.Inputs[OLE DB Destination Input].ExternalColumns[factory_sk]"
|
|
dataType="i4"
|
|
name="factory_sk" />
|
|
<externalMetadataColumn
|
|
refId="Package\load dim_factories\Save to Dim Factories Table.Inputs[OLE DB Destination Input].ExternalColumns[factory_bk]"
|
|
dataType="wstr"
|
|
length="100"
|
|
name="factory_bk" />
|
|
<externalMetadataColumn
|
|
refId="Package\load dim_factories\Save to Dim Factories Table.Inputs[OLE DB Destination Input].ExternalColumns[factory_name]"
|
|
dataType="wstr"
|
|
length="250"
|
|
name="factory_name" />
|
|
<externalMetadataColumn
|
|
refId="Package\load dim_factories\Save to Dim Factories Table.Inputs[OLE DB Destination Input].ExternalColumns[factory_country]"
|
|
dataType="wstr"
|
|
length="250"
|
|
name="factory_country" />
|
|
</externalMetadataColumns>
|
|
</input>
|
|
</inputs>
|
|
<outputs>
|
|
<output
|
|
refId="Package\load dim_factories\Save to Dim Factories Table.Outputs[OLE DB Destination Error Output]"
|
|
exclusionGroup="1"
|
|
isErrorOut="true"
|
|
name="OLE DB Destination Error Output"
|
|
synchronousInputId="Package\load dim_factories\Save to Dim Factories Table.Inputs[OLE DB Destination Input]">
|
|
<outputColumns>
|
|
<outputColumn
|
|
refId="Package\load dim_factories\Save to Dim Factories Table.Outputs[OLE DB Destination Error Output].Columns[ErrorCode]"
|
|
dataType="i4"
|
|
lineageId="Package\load dim_factories\Save to Dim Factories Table.Outputs[OLE DB Destination Error Output].Columns[ErrorCode]"
|
|
name="ErrorCode"
|
|
specialFlags="1" />
|
|
<outputColumn
|
|
refId="Package\load dim_factories\Save to Dim Factories Table.Outputs[OLE DB Destination Error Output].Columns[ErrorColumn]"
|
|
dataType="i4"
|
|
lineageId="Package\load dim_factories\Save to Dim Factories Table.Outputs[OLE DB Destination Error Output].Columns[ErrorColumn]"
|
|
name="ErrorColumn"
|
|
specialFlags="2" />
|
|
</outputColumns>
|
|
<externalMetadataColumns />
|
|
</output>
|
|
</outputs>
|
|
</component>
|
|
</components>
|
|
<paths>
|
|
<path
|
|
refId="Package\load dim_factories.Paths[Derived Column Output]"
|
|
endId="Package\load dim_factories\clean country.Inputs[Derived Column Input]"
|
|
name="Derived Column Output"
|
|
startId="Package\load dim_factories\clean code.Outputs[Derived Column Output]" />
|
|
<path
|
|
refId="Package\load dim_factories.Paths[Derived Column Output1]"
|
|
endId="Package\load dim_factories\clean name.Inputs[Derived Column Input]"
|
|
name="Derived Column Output"
|
|
startId="Package\load dim_factories\clean country.Outputs[Derived Column Output]" />
|
|
<path
|
|
refId="Package\load dim_factories.Paths[Derived Column Output2]"
|
|
endId="Package\load dim_factories\Save to Dim Factories Table.Inputs[OLE DB Destination Input]"
|
|
name="Derived Column Output"
|
|
startId="Package\load dim_factories\clean name.Outputs[Derived Column Output]" />
|
|
<path
|
|
refId="Package\load dim_factories.Paths[Flat File Source Output]"
|
|
endId="Package\load dim_factories\clean code.Inputs[Derived Column Input]"
|
|
name="Flat File Source Output"
|
|
startId="Package\load dim_factories\Load Factories File.Outputs[Flat File Source Output]" />
|
|
</paths>
|
|
</pipeline>
|
|
</DTS:ObjectData>
|
|
</DTS:Executable>
|
|
</DTS:Executables>
|
|
<DTS:PrecedenceConstraints>
|
|
<DTS:PrecedenceConstraint
|
|
DTS:refId="Package.PrecedenceConstraints[Constraint]"
|
|
DTS:CreationName=""
|
|
DTS:DTSID="{DC45BC7E-869D-46CB-A5B1-81547B67E8D7}"
|
|
DTS:From="Package\Execute SQL Task"
|
|
DTS:LogicalAnd="True"
|
|
DTS:ObjectName="Constraint"
|
|
DTS:To="Package\load dim_factories" />
|
|
</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="165,42"
|
|
Id="Package\load dim_factories"
|
|
TopLeft="158,128" />
|
|
<NodeLayout
|
|
Size="163,42"
|
|
Id="Package\Execute SQL Task"
|
|
TopLeft="393,64" />
|
|
<EdgeLayout
|
|
Id="Package.PrecedenceConstraints[Constraint]"
|
|
TopLeft="393,85">
|
|
<EdgeLayout.Curve>
|
|
<mssgle:Curve
|
|
StartConnector="{assembly:Null}"
|
|
EndConnector="-70,64"
|
|
Start="0,0"
|
|
End="-62.5,64">
|
|
<mssgle:Curve.Segments>
|
|
<mssgle:SegmentCollection
|
|
Capacity="5">
|
|
<mssgle:LineSegment
|
|
End="-31,0" />
|
|
<mssgle:CubicBezierSegment
|
|
Point1="-31,0"
|
|
Point2="-35,0"
|
|
Point3="-35,4" />
|
|
<mssgle:LineSegment
|
|
End="-35,60" />
|
|
<mssgle:CubicBezierSegment
|
|
Point1="-35,60"
|
|
Point2="-35,64"
|
|
Point3="-39,64" />
|
|
<mssgle:LineSegment
|
|
End="-62.5,64" />
|
|
</mssgle:SegmentCollection>
|
|
</mssgle:Curve.Segments>
|
|
</mssgle:Curve>
|
|
</EdgeLayout.Curve>
|
|
<EdgeLayout.Labels>
|
|
<EdgeLabelCollection />
|
|
</EdgeLayout.Labels>
|
|
</EdgeLayout>
|
|
</GraphLayout>
|
|
</LayoutInfo>
|
|
</Package>
|
|
<TaskHost
|
|
design-time-name="Package\load dim_factories">
|
|
<LayoutInfo>
|
|
<GraphLayout
|
|
Capacity="16" 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="211,42"
|
|
Id="Package\load dim_factories\Save to Dim Factories Table"
|
|
TopLeft="826,172" />
|
|
<NodeLayout
|
|
Size="166,42"
|
|
Id="Package\load dim_factories\Load Factories File"
|
|
TopLeft="5.5,5.5" />
|
|
<NodeLayout
|
|
Size="129,42"
|
|
Id="Package\load dim_factories\clean code"
|
|
TopLeft="356,126" />
|
|
<EdgeLayout
|
|
Id="Package\load dim_factories.Paths[Flat File Source Output]"
|
|
TopLeft="88.5,47.5">
|
|
<EdgeLayout.Curve>
|
|
<mssgle:Curve
|
|
StartConnector="{assembly:Null}"
|
|
EndConnector="332,78.5"
|
|
Start="0,0"
|
|
End="332,71">
|
|
<mssgle:Curve.Segments>
|
|
<mssgle:SegmentCollection
|
|
Capacity="5">
|
|
<mssgle:LineSegment
|
|
End="0,35.25" />
|
|
<mssgle:CubicBezierSegment
|
|
Point1="0,35.25"
|
|
Point2="0,39.25"
|
|
Point3="4,39.25" />
|
|
<mssgle:LineSegment
|
|
End="328,39.25" />
|
|
<mssgle:CubicBezierSegment
|
|
Point1="328,39.25"
|
|
Point2="332,39.25"
|
|
Point3="332,43.25" />
|
|
<mssgle:LineSegment
|
|
End="332,71" />
|
|
</mssgle:SegmentCollection>
|
|
</mssgle:Curve.Segments>
|
|
</mssgle:Curve>
|
|
</EdgeLayout.Curve>
|
|
<EdgeLayout.Labels>
|
|
<EdgeLabelCollection />
|
|
</EdgeLayout.Labels>
|
|
</EdgeLayout>
|
|
<NodeLayout
|
|
Size="142,42"
|
|
Id="Package\load dim_factories\clean country"
|
|
TopLeft="552,335" />
|
|
<NodeLayout
|
|
Size="133,42"
|
|
Id="Package\load dim_factories\clean name"
|
|
TopLeft="771.5,340" />
|
|
<EdgeLayout
|
|
Id="Package\load dim_factories.Paths[Derived Column Output]"
|
|
TopLeft="420.5,168">
|
|
<EdgeLayout.Curve>
|
|
<mssgle:Curve
|
|
StartConnector="{assembly:Null}"
|
|
EndConnector="202.5,167"
|
|
Start="0,0"
|
|
End="202.5,159.5">
|
|
<mssgle:Curve.Segments>
|
|
<mssgle:SegmentCollection
|
|
Capacity="5">
|
|
<mssgle:LineSegment
|
|
End="0,79.5" />
|
|
<mssgle:CubicBezierSegment
|
|
Point1="0,79.5"
|
|
Point2="0,83.5"
|
|
Point3="4,83.5" />
|
|
<mssgle:LineSegment
|
|
End="198.5,83.5" />
|
|
<mssgle:CubicBezierSegment
|
|
Point1="198.5,83.5"
|
|
Point2="202.5,83.5"
|
|
Point3="202.5,87.5" />
|
|
<mssgle:LineSegment
|
|
End="202.5,159.5" />
|
|
</mssgle:SegmentCollection>
|
|
</mssgle:Curve.Segments>
|
|
</mssgle:Curve>
|
|
</EdgeLayout.Curve>
|
|
<EdgeLayout.Labels>
|
|
<EdgeLabelCollection />
|
|
</EdgeLayout.Labels>
|
|
</EdgeLayout>
|
|
<EdgeLayout
|
|
Id="Package\load dim_factories.Paths[Derived Column Output1]"
|
|
TopLeft="694,358.5">
|
|
<EdgeLayout.Curve>
|
|
<mssgle:Curve
|
|
StartConnector="{assembly:Null}"
|
|
EndConnector="77.5,0"
|
|
Start="0,0"
|
|
End="70,0">
|
|
<mssgle:Curve.Segments>
|
|
<mssgle:SegmentCollection
|
|
Capacity="5">
|
|
<mssgle:LineSegment
|
|
End="70,0" />
|
|
</mssgle:SegmentCollection>
|
|
</mssgle:Curve.Segments>
|
|
</mssgle:Curve>
|
|
</EdgeLayout.Curve>
|
|
<EdgeLayout.Labels>
|
|
<EdgeLabelCollection />
|
|
</EdgeLayout.Labels>
|
|
</EdgeLayout>
|
|
<EdgeLayout
|
|
Id="Package\load dim_factories.Paths[Derived Column Output2]"
|
|
TopLeft="838,340">
|
|
<EdgeLayout.Curve>
|
|
<mssgle:Curve
|
|
StartConnector="{assembly:Null}"
|
|
EndConnector="93.5,-126"
|
|
Start="0,0"
|
|
End="93.5,-118.5">
|
|
<mssgle:Curve.Segments>
|
|
<mssgle:SegmentCollection
|
|
Capacity="5">
|
|
<mssgle:LineSegment
|
|
End="0,-59" />
|
|
<mssgle:CubicBezierSegment
|
|
Point1="0,-59"
|
|
Point2="0,-63"
|
|
Point3="4,-63" />
|
|
<mssgle:LineSegment
|
|
End="89.5,-63" />
|
|
<mssgle:CubicBezierSegment
|
|
Point1="89.5,-63"
|
|
Point2="93.5,-63"
|
|
Point3="93.5,-67" />
|
|
<mssgle:LineSegment
|
|
End="93.5,-118.5" />
|
|
</mssgle:SegmentCollection>
|
|
</mssgle:Curve.Segments>
|
|
</mssgle:Curve>
|
|
</EdgeLayout.Curve>
|
|
<EdgeLayout.Labels>
|
|
<EdgeLabelCollection />
|
|
</EdgeLayout.Labels>
|
|
</EdgeLayout>
|
|
</GraphLayout>
|
|
</LayoutInfo>
|
|
</TaskHost>
|
|
<PipelineComponentMetadata
|
|
design-time-name="Package\load dim_factories\Save to Dim Factories Table">
|
|
<Properties>
|
|
<Property>
|
|
<Name>DataSourceViewID</Name>
|
|
</Property>
|
|
<Property>
|
|
<Name>TableInfoObjectType</Name>
|
|
<Value
|
|
type="q2:string">Table</Value>
|
|
</Property>
|
|
</Properties>
|
|
</PipelineComponentMetadata>
|
|
</Objects>]]></DTS:DesignTimeProperties>
|
|
</DTS:Executable> |