﻿<?xml version="1.0"?>
<DTS:Executable xmlns:DTS="www.microsoft.com/SqlServer/Dts"
  DTS:refId="Package"
  DTS:CreationDate="1/12/2018 3:41:54 PM"
  DTS:CreationName="SSIS.Package.3"
  DTS:DTSID="{56850043-8837-4F00-AA2E-7F3EF299CF15}"
  DTS:ExecutableType="SSIS.Package.3"
  DTS:LastModifiedProductVersion="14.0.1000.169"
  DTS:LocaleID="1063"
  DTS:ObjectName="Ticket 78974"
  DTS:PackageType="5"
  DTS:VersionBuild="13"
  DTS:VersionGUID="{EC88B5E8-7DCD-41B0-A8D0-214294CDC73B}">
  <DTS:Property
    DTS:Name="PackageFormatVersion">6</DTS:Property>
  <DTS:ConnectionManagers>
    <DTS:ConnectionManager
      DTS:refId="Package.ConnectionManagers[(localdb)\default.tempdb]"
      DTS:CreationName="OLEDB"
      DTS:DTSID="{F0942F6E-73FF-47E6-95BB-25B584BA7143}"
      DTS:ObjectName="(localdb)\default.tempdb">
      <DTS:ObjectData>
        <DTS:ConnectionManager
          DTS:ConnectionString="Data Source=(localdb)\default;Initial Catalog=tempdb;Provider=SQLNCLI11.1;Integrated Security=SSPI;Auto Translate=False;" />
      </DTS:ObjectData>
    </DTS:ConnectionManager>
    <DTS:ConnectionManager
      DTS:refId="Package.ConnectionManagers[HTTP 1]"
      DTS:CreationName="ZS-HTTP"
      DTS:DTSID="{EE428DDF-6D0E-40F4-B8DA-C2DA5C6C0364}"
      DTS:ObjectName="HTTP 1">
      <DTS:ObjectData>
        <ConnectionManager
          ConnectionString="Url=http://www.httpbin.org/status/500;CredentialType=Notset;UserName=;Timeout=100000;UseProxy=False;ProxyUrl=;UseProxyCreds=False;ProxyUserName=;DoNotUseDefaultProxy=False;UseClientCertificate=False;CertificatePath=;CertificateStorageType=CurrentUser;CertificateStoreName=My;CertificateThumbprint=;RetryMode=None;RetryCountMax=3;RetryWaitTimeMs=2000;RetryMultiplyWaitTime=False;RetryMessageList=;RetryStatusCodeList=" />
      </DTS:ObjectData>
    </DTS:ConnectionManager>
    <DTS:ConnectionManager
      DTS:refId="Package.ConnectionManagers[Secure FTP 1]"
      DTS:CreationName="ZS-SFTP"
      DTS:DTSID="{D4AACAD5-F692-46FB-B95D-6B6C7F9233F8}"
      DTS:ObjectName="Secure FTP 1">
      <DTS:ObjectData>
        <ConnectionManager
          ConnectionString="Protocol=Sftp;ServerName=localhost;Port=22;LogonType=Normal;UserName=zstest;Domain=;EncryptionMode=TlsSslExplicit;KeyFilePath=;ClientCertFilePath=;Account=;VerifyChecksum=False;IgnoreCertErrors=False;MinSslTlsVersion=Any;MaxSslTlsVersion=Any;ProxyType=None;ProxyAuthMode=Basic;ProxyServer=;ProxyPort=1080;ProxyUserName=;ProxyDomain=;TransferMode=Binary;TrustedFingerprints=;MaxUploadSpeedKbps=0;MaxDownloadSpeedKbps=0;UseActiveMode=False;EnableCompression=False;EnableRestoreDateTime=False;Timeout=60;DefaultDirectory=;TreatUnknownItemsAsFiles=False;DisableSftp4=False;DisableTransferQueue=False;UseSmallPackets=False;WaitForServerWelcomeMessage=False;KeyExchangeAlgorithms=;HostKeyAlgorithms=;MacAlgorithms=;EncryptionAlgorithms=;DoNotSendSignals=False;DoNotSendAbort=False;KeepAliveDuringTransfer=False;PauseBeforeUploadClose=False;SslDoNotInsertEmptyFragment=False;RetainSameConnection=False">
          <Password
            Sensitive="1"
            Encrypted="1">AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAvfyGfgO2QUWceuEC7yMouQAAAAAIAAAARABUAFMAAAAQZgAAAAEAACAAAAD4twNH6o5hXKT7f435nqRUNN8OXl+gNQzzCxpvom/4PAAAAAAOgAAAAAIAACAAAADNfMZQ4XK9+tXSdddVIJIvbUijQJ0QtR5g1N2qSZRHFSAAAADQeEFKiyohS8dOH1T6olFu2ugvf0c15pkieWlmN/sqrkAAAADxyk6bxzcbyXRubo+tE14u58QbD/HCUjG1zJIV0EYdI4r/lzADYxaE9rZ2KY1ezYm+NQWhJH/h1Dd8E7EGOtPf</Password>
        </ConnectionManager>
      </DTS:ObjectData>
    </DTS:ConnectionManager>
  </DTS:ConnectionManagers>
  <DTS:Variables>
    <DTS:Variable
      DTS:CreationName=""
      DTS:DTSID="{80D79311-AD00-406E-8210-7CC07F4B2F79}"
      DTS:IncludeInDebugDump="6789"
      DTS:Namespace="User"
      DTS:ObjectName="DataTable">
      <DTS:VariableValue
        DTS:DataSubType="ManagedSerializable"
        DTS:DataType="13">
        <SOAP-ENV:Envelope xmlns:clr="http://schemas.microsoft.com/soap/encoding/clr/1.0" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
          SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
          <SOAP-ENV:Body>
            <xsd:anyType
              id="ref-1"></xsd:anyType>
          </SOAP-ENV:Body>
        </SOAP-ENV:Envelope>
      </DTS:VariableValue>
    </DTS:Variable>
    <DTS:Variable
      DTS:CreationName=""
      DTS:DTSID="{5BABCCF0-67A2-44B1-8E68-BC58920C5F6B}"
      DTS:IncludeInDebugDump="2345"
      DTS:Namespace="User"
      DTS:ObjectName="DateCreated">
      <DTS:VariableValue
        DTS:DataType="7">1/15/2018 3:42:42 PM</DTS:VariableValue>
    </DTS:Variable>
  </DTS:Variables>
  <DTS:Executables>
    <DTS:Executable
      DTS:refId="Package\Foreach Loop Container"
      DTS:CreationName="STOCK:FOREACHLOOP"
      DTS:Description="Foreach Loop Container"
      DTS:DTSID="{72582F17-B4F9-4063-8B52-ABAE41033A51}"
      DTS:ExecutableType="STOCK:FOREACHLOOP"
      DTS:LocaleID="-1"
      DTS:ObjectName="Foreach Loop Container">
      <DTS:ForEachEnumerator
        DTS:CreationName="Microsoft.SqlServer.Dts.Runtime.Enumerators.ADO.ForEachADOEnumerator, Microsoft.SqlServer.ForEachADOEnumerator, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"
        DTS:DTSID="{76BBFA67-333A-4173-A4F1-51849E49CB3D}"
        DTS:ObjectName="{76BBFA67-333A-4173-A4F1-51849E49CB3D}">
        <DTS:ObjectData>
          <FEEADO
            EnumType="EnumerateRowsInFirstTable"
            VarName="User::DataTable" />
        </DTS:ObjectData>
      </DTS:ForEachEnumerator>
      <DTS:Variables />
      <DTS:Executables>
        <DTS:Executable
          DTS:refId="Package\Foreach Loop Container\ZS Logging Task"
          DTS:CreationName="ZappySys.PowerPack.Task.LoggingTask.LoggingTask, ZappySys.PowerPack110, Version=1.0.0.0, Culture=neutral, PublicKeyToken=1903265a93eae502"
          DTS:Description="ZS Logging Task"
          DTS:DTSID="{24540145-1B6D-4E04-AC01-27670469ECA0}"
          DTS:ExecutableType="ZappySys.PowerPack.Task.LoggingTask.LoggingTask, ZappySys.PowerPack110, Version=1.0.0.0, Culture=neutral, PublicKeyToken=1903265a93eae502"
          DTS:LocaleID="-1"
          DTS:ObjectName="ZS Logging Task"
          DTS:ThreadHint="0">
          <DTS:Variables />
          <DTS:ObjectData>
            <LoggingTask
              Message="{{User::DateCreated}}"
              LogVariableName=""
              MessageType="Information"
              LogMode="ExecutionLog"
              LogFilePath=""
              LogFileAppend="True"
              LogDateTime="True"
              DateTimeFormat="HH:mm:ss"
              LogLevel="Normal"
              PrefixTimestamp="False" />
          </DTS:ObjectData>
        </DTS:Executable>
      </DTS:Executables>
      <DTS:ForEachVariableMappings>
        <DTS:ForEachVariableMapping
          DTS:CreationName=""
          DTS:DTSID="{126107BF-699B-4881-AF25-E6AC98D77A03}"
          DTS:ObjectName="{126107BF-699B-4881-AF25-E6AC98D77A03}"
          DTS:ValueIndex="5"
          DTS:VariableName="User::DateCreated" />
      </DTS:ForEachVariableMappings>
    </DTS:Executable>
    <DTS:Executable
      DTS:refId="Package\ZS Logging Task"
      DTS:CreationName="ZappySys.PowerPack.Task.LoggingTask.LoggingTask, ZappySys.PowerPack110, Version=1.0.0.0, Culture=neutral, PublicKeyToken=1903265a93eae502"
      DTS:Description="ZS Logging Task"
      DTS:DTSID="{A1507A96-C2C2-4A39-AEA3-C754F531847F}"
      DTS:ExecutableType="ZappySys.PowerPack.Task.LoggingTask.LoggingTask, ZappySys.PowerPack110, Version=1.0.0.0, Culture=neutral, PublicKeyToken=1903265a93eae502"
      DTS:LocaleID="-1"
      DTS:ObjectName="ZS Logging Task"
      DTS:ThreadHint="0">
      <DTS:Variables />
      <DTS:ObjectData>
        <LoggingTask
          Message="{{User::DataTable}}"
          LogVariableName=""
          MessageType="Information"
          LogMode="ExecutionLog"
          LogFilePath=""
          LogFileAppend="True"
          LogDateTime="True"
          DateTimeFormat="HH:mm:ss"
          LogLevel="Normal"
          PrefixTimestamp="False" />
      </DTS:ObjectData>
    </DTS:Executable>
    <DTS:Executable
      DTS:refId="Package\ZS Secure FTP Task"
      DTS:CreationName="ZappySys.PowerPack.Task.SecureFtpTask.SecureFtpTask, ZappySys.PowerPack110, Version=1.0.0.0, Culture=neutral, PublicKeyToken=1903265a93eae502"
      DTS:Description="ZS Secure FTP Task"
      DTS:DTSID="{7F51277E-2AA4-4F46-BCC7-EBEFE6BE9D20}"
      DTS:ExecutableType="ZappySys.PowerPack.Task.SecureFtpTask.SecureFtpTask, ZappySys.PowerPack110, Version=1.0.0.0, Culture=neutral, PublicKeyToken=1903265a93eae502"
      DTS:LocaleID="-1"
      DTS:ObjectName="ZS Secure FTP Task"
      DTS:ThreadHint="0">
      <DTS:Variables />
      <DTS:ObjectData>
        <SecureFtpTask
          StorageAction="GetFtpFileListAsADONETDataTable"
          FileOverwriteAction="ThrowException"
          ContinueOnError="False"
          ThrowErrorIfSourceNotFound="True"
          DeleteSourceWhenDone="False"
          SourceStorageConnection="Secure FTP 1"
          SourcePathAccessMode="Direct"
          SourcePathValue="/binaryworldtest/cloudfile1.csv"
          SourcePathConnection=""
          SourcePathVariable=""
          Recursive="False"
          ResultVariable="User::DataTable"
          TargetStorageConnection=""
          TargetPathAccessMode="Direct"
          TargetPathValue=""
          TargetPathConnection=""
          TargetPathVariable=""
          CreateMissingTargetFolder="True"
          ExcludeRegXPattern=""
          IncludeRegXPattern=""
          SortBy="Size"
          SortDirection="Asc"
          WhereClause=""
          EnableSort="False"
          MaxItems="0"
          LogLevel="Normal"
          PrefixTimestamp="False" />
      </DTS:ObjectData>
    </DTS:Executable>
  </DTS:Executables>
  <DTS:PrecedenceConstraints>
    <DTS:PrecedenceConstraint
      DTS:refId="Package.PrecedenceConstraints[Constraint]"
      DTS:CreationName=""
      DTS:DTSID="{767FC639-7F79-457F-993F-8C1DACFD55DD}"
      DTS:From="Package\ZS Secure FTP Task"
      DTS:LogicalAnd="True"
      DTS:ObjectName="Constraint"
      DTS:To="Package\ZS Logging Task" />
    <DTS:PrecedenceConstraint
      DTS:refId="Package.PrecedenceConstraints[Constraint 1]"
      DTS:CreationName=""
      DTS:DTSID="{1AA4F918-121F-4369-8D36-414EF8F29F08}"
      DTS:From="Package\ZS Logging Task"
      DTS:LogicalAnd="True"
      DTS:ObjectName="Constraint 1"
      DTS:To="Package\Foreach Loop Container" />
  </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="sql11">
  <!--Each node below will contain properties that do not affect runtime behavior.-->
  <Package
    design-time-name="Package">
    <LayoutInfo>
      <GraphLayout
        Capacity="8" 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="162,42"
          Id="Package\Foreach Loop Container\ZS Logging Task"
          TopLeft="67,39" />
        <ContainerLayout
          HeaderHeight="43"
          IsExpanded="True"
          PanelSize="311,133"
          Size="311,176"
          Id="Package\Foreach Loop Container"
          TopLeft="98,381" />
        <NodeLayout
          Size="162,42"
          Id="Package\ZS Logging Task"
          TopLeft="176,254" />
        <NodeLayout
          Size="181,42"
          Id="Package\ZS Secure FTP Task"
          TopLeft="166,139" />
        <EdgeLayout
          Id="Package.PrecedenceConstraints[Constraint]"
          TopLeft="256.75,181">
          <EdgeLayout.Curve>
            <mssgle:Curve
              StartConnector="{assembly:Null}"
              EndConnector="0,73"
              Start="0,0"
              End="0,65.5">
              <mssgle:Curve.Segments>
                <mssgle:SegmentCollection
                  Capacity="5">
                  <mssgle:LineSegment
                    End="0,65.5" />
                </mssgle:SegmentCollection>
              </mssgle:Curve.Segments>
            </mssgle:Curve>
          </EdgeLayout.Curve>
          <EdgeLayout.Labels>
            <EdgeLabelCollection />
          </EdgeLayout.Labels>
        </EdgeLayout>
        <EdgeLayout
          Id="Package.PrecedenceConstraints[Constraint 1]"
          TopLeft="255.25,296">
          <EdgeLayout.Curve>
            <mssgle:Curve
              StartConnector="{assembly:Null}"
              EndConnector="0,85"
              Start="0,0"
              End="0,77.5">
              <mssgle:Curve.Segments>
                <mssgle:SegmentCollection
                  Capacity="5">
                  <mssgle:LineSegment
                    End="0,77.5" />
                </mssgle:SegmentCollection>
              </mssgle:Curve.Segments>
            </mssgle:Curve>
          </EdgeLayout.Curve>
          <EdgeLayout.Labels>
            <EdgeLabelCollection />
          </EdgeLayout.Labels>
        </EdgeLayout>
      </GraphLayout>
    </LayoutInfo>
  </Package>
</Objects>]]></DTS:DesignTimeProperties>
</DTS:Executable>