SamplesV2/SQLServerIntegrationServices/publicpreview/CustomSetupScript/UserScenarios/STORAGE/PowerShell.dtsx (131 lines of code) (raw):
<?xml version="1.0"?>
<DTS:Executable xmlns:DTS="www.microsoft.com/SqlServer/Dts"
DTS:refId="Package"
DTS:CreationDate="12/4/2017 4:35:03 PM"
DTS:CreationName="Microsoft.Package"
DTS:CreatorComputerName="CN-SAWINARK-P4"
DTS:CreatorName="EUROPE\sawinark"
DTS:DTSID="{B7E42E48-6E40-4FBE-BBF9-D68FE4D99867}"
DTS:ExecutableType="Microsoft.Package"
DTS:LastModifiedProductVersion="14.0.0800.98"
DTS:LocaleID="1033"
DTS:ObjectName="PowerShell"
DTS:PackageType="5"
DTS:VersionBuild="8"
DTS:VersionGUID="{1C481E94-C893-4D2D-93AB-D3EE69FA9555}">
<DTS:Property
DTS:Name="PackageFormatVersion">8</DTS:Property>
<DTS:ConnectionManagers>
<DTS:ConnectionManager
DTS:refId="Package.ConnectionManagers[mystorage]"
DTS:CreationName="AzureStorage"
DTS:DTSID="{28C13B6A-3A57-4659-886B-3B0A94C45960}"
DTS:ObjectName="mystorage">
<DTS:ObjectData>
<AzureStorageConnectionManager
ConnectionString="DefaultEndpointsProtocol=https;AccountName=mystorage;EndpointSuffix=core.windows.net">
<AccountKey
Sensitive="1"
Encrypted="1">AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAvIDoulfFtkybf4ckNNB/bgAAAAAIAAAARABUAFMAAAADZgAAwAAAABAAAADcD74XbfOsCaSAcYzgrPmPAAAAAASAAACgAAAAEAAAACaPWwsXmCgY/Y1Wv2s4eqEYAAAARPpMi8JnWuRhaDY3W2++gs+dOFrCjeBAFAAAANyoQt2GoHCL/30gniFuDkDm9oR5</AccountKey>
</AzureStorageConnectionManager>
</DTS:ObjectData>
</DTS:ConnectionManager>
</DTS:ConnectionManagers>
<DTS:Variables />
<DTS:Executables>
<DTS:Executable
DTS:refId="Package\Azure Blob Download Task"
DTS:CreationName="CopyFromBlobTask"
DTS:Description="Azure Blob Download Task"
DTS:DTSID="{D60B4476-0EB0-40D6-B10E-887E6850CD65}"
DTS:ExecutableType="CopyFromBlobTask"
DTS:LocaleID="-1"
DTS:ObjectName="Azure Blob Download Task"
DTS:TaskContact="Azure Blob Download Task; (C) Microsoft Corporation; All Rights Reserved"
DTS:ThreadHint="0">
<DTS:Variables />
<DTS:ObjectData>
<CopyFromBlobTask
ConnectionId="{28C13B6A-3A57-4659-886B-3B0A94C45960}"
BlobContainer="mycontainer"
LocalDirectory="."
FileNameFilter="storage.ps1"
TimeRangeFrom="1/1/1900 12:00:00 AM +08:00"
TimeRangeTo="12/31/2200 12:00:00 AM +08:00" />
</DTS:ObjectData>
</DTS:Executable>
<DTS:Executable
DTS:refId="Package\Execute Process Task"
DTS:CreationName="Microsoft.ExecuteProcess"
DTS:Description="Execute Process Task"
DTS:DTSID="{672360CC-DD6C-49F6-A990-99121CE9A4F0}"
DTS:ExecutableType="Microsoft.ExecuteProcess"
DTS:LocaleID="-1"
DTS:ObjectName="Execute Process Task"
DTS:TaskContact="Execute Process 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>
<ExecuteProcessData
Executable="Powershell.exe"
Arguments="-F .\storage.ps1" />
</DTS:ObjectData>
</DTS:Executable>
</DTS:Executables>
<DTS:PrecedenceConstraints>
<DTS:PrecedenceConstraint
DTS:refId="Package.PrecedenceConstraints[Constraint]"
DTS:CreationName=""
DTS:DTSID="{7D7EC474-0DE3-45C1-9494-91A2B05685F2}"
DTS:From="Package\Azure Blob Download Task"
DTS:LogicalAnd="True"
DTS:ObjectName="Constraint"
DTS:To="Package\Execute Process Task" />
</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="204.5,42"
Id="Package\Azure Blob Download Task"
TopLeft="95.75,80" />
<NodeLayout
Size="180,42"
Id="Package\Execute Process Task"
TopLeft="107.5,181.5" />
<EdgeLayout
Id="Package.PrecedenceConstraints[Constraint]"
TopLeft="197.75,122">
<EdgeLayout.Curve>
<mssgle:Curve
StartConnector="{assembly:Null}"
EndConnector="0,59.5"
Start="0,0"
End="0,52">
<mssgle:Curve.Segments>
<mssgle:SegmentCollection
Capacity="5">
<mssgle:LineSegment
End="0,52" />
</mssgle:SegmentCollection>
</mssgle:Curve.Segments>
</mssgle:Curve>
</EdgeLayout.Curve>
<EdgeLayout.Labels>
<EdgeLabelCollection />
</EdgeLayout.Labels>
</EdgeLayout>
</GraphLayout>
</LayoutInfo>
</Package>
</Objects>]]></DTS:DesignTimeProperties>
</DTS:Executable>