<?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>