SamplesV2/SQLServerIntegrationServices/publicpreview/SelfHostedIRProxy/Limitations/ParameterMappingSample.dtsx

<?xml version="1.0"?> <DTS:Executable xmlns:DTS="www.microsoft.com/SqlServer/Dts" DTS:refId="Package" DTS:CreationDate="12/18/2019 2:51:26 AM" DTS:CreationName="Microsoft.Package" DTS:CreatorComputerName="xichenshvm" DTS:CreatorName="xichenshvm\xichen" DTS:DTSID="{5B70D407-816A-4593-9020-0896D52C022E}" DTS:ExecutableType="Microsoft.Package" DTS:LastModifiedProductVersion="15.0.1300.375" DTS:LocaleID="1033" DTS:ObjectName="Package" DTS:PackageType="5" DTS:ProtectionLevel="2" DTS:VersionBuild="4" DTS:VersionGUID="{3DF512C7-2DFB-4132-A98B-652BBEFB4B70}"> <DTS:Property DTS:Name="PackageFormatVersion">8</DTS:Property> <DTS:ConnectionManagers> <DTS:ConnectionManager DTS:refId="Package.ConnectionManagers[dest]" DTS:CreationName="OLEDB" DTS:DTSID="{64EB74B7-0EF3-4895-9341-A7B0C706CD3C}" DTS:ObjectName="dest"> <DTS:ObjectData> <DTS:ConnectionManager DTS:ConnectionString="Data Source=xichensqlserver2.database.windows.net;User ID=xichen;Initial Catalog=mydb1;Provider=SQLNCLI11.1;Auto Translate=False;"> <EncryptedData Type="http://www.w3.org/2001/04/xmlenc#Element" Salt="heQi9axy78M=" IV="P+r27MoAiuzbrnj27Oxozw==" xmlns="http://www.w3.org/2001/04/xmlenc#"> <EncryptionMethod Algorithm="http://www.w3.org/2001/04/xmlenc#aes256-cbc" /> <CipherData> <CipherValue>P+r27MoAiuzbrnj27Oxoz5aL6U5CjZ/L8YOmF7Y5fKAe+AmEbqn7s+9GBMAHXlhSxmRC6zpuzoPKyLCf2PzQQL4uts6BX0JA/3pf3PtaE/CMeuGNBmUAg6sOTQE8YByisntLNk+pY7gauSg2HK+Xn+sgLeTjECEJyL42OwAvcvP4SEPLWTXVf932JufTTp/h</CipherValue> </CipherData> </EncryptedData> </DTS:ConnectionManager> </DTS:ObjectData> </DTS:ConnectionManager> <DTS:ConnectionManager DTS:refId="Package.ConnectionManagers[src]" DTS:CreationName="OLEDB" DTS:DTSID="{CDAFFB25-86B1-478B-A1BE-32FC3513859C}" DTS:ObjectName="src"> <DTS:ObjectData> <DTS:ConnectionManager DTS:ConnectByProxy="True" DTS:ConnectionString="Data Source=xichensqlserver2.database.windows.net;User ID=xichen;Initial Catalog=mydb;Provider=SQLNCLI11.1;Auto Translate=False;"> <EncryptedData Type="http://www.w3.org/2001/04/xmlenc#Element" Salt="YAXBGDlOpn4=" IV="HUT27Vb8QrgKFkpR0hOY8w==" xmlns="http://www.w3.org/2001/04/xmlenc#"> <EncryptionMethod Algorithm="http://www.w3.org/2001/04/xmlenc#aes256-cbc" /> <CipherData> <CipherValue>HUT27Vb8QrgKFkpR0hOY8xtMC3RXbCTiymDBYQLG6lmMPiNjbGU16g1DU+FOEZ94ZBcR4YwkyfALGMnEX3j9uC6Ejcr2Mu77kaD1q/wIM+2Q+Uhhbzbz4uMbckBu94bfd54YOY6cqiPtrgthcFfLS6r8w9MkJvHSTzjJHaywqfIHX14SFQolGUWIk/8eSjU1</CipherValue> </CipherData> </EncryptedData> </DTS:ConnectionManager> </DTS:ObjectData> </DTS:ConnectionManager> </DTS:ConnectionManagers> <DTS:Variables> <DTS:Variable DTS:CreationName="" DTS:DTSID="{F6BF894A-8F09-4EC4-B868-8F26D2DC4082}" DTS:EvaluateAsExpression="True" DTS:Expression="@[User::sqlCmd1] + @[User::sqlVar] + @[User::sqlCmd2]" DTS:IncludeInDebugDump="2345" DTS:Namespace="User" DTS:ObjectName="sqlCmd"> <DTS:VariableValue DTS:DataType="8">select * from country where name = 'dummy' and abbr = 'us'</DTS:VariableValue> </DTS:Variable> <DTS:Variable DTS:CreationName="" DTS:DTSID="{93480CC9-A0A0-4D59-A983-F68A152CF8D7}" DTS:IncludeInDebugDump="2345" DTS:Namespace="User" DTS:ObjectName="sqlCmd1"> <DTS:VariableValue DTS:DataType="8">select * from country where name = '</DTS:VariableValue> </DTS:Variable> <DTS:Variable DTS:CreationName="" DTS:DTSID="{18D3BEEE-738F-478E-9D1B-605AE9265E05}" DTS:IncludeInDebugDump="2345" DTS:Namespace="User" DTS:ObjectName="sqlCmd2"> <DTS:VariableValue DTS:DataType="8">' and abbr = 'us'</DTS:VariableValue> </DTS:Variable> <DTS:Variable DTS:CreationName="" DTS:DTSID="{DDC570E4-B22C-48A3-A014-D3920CA5410B}" DTS:IncludeInDebugDump="2345" DTS:Namespace="User" DTS:ObjectName="sqlVar"> <DTS:VariableValue DTS:DataType="8">dummy</DTS:VariableValue> </DTS:Variable> </DTS:Variables> <DTS:Executables> <DTS:Executable DTS:refId="Package\Data Flow Task" DTS:CreationName="Microsoft.Pipeline" DTS:Description="Data Flow Task" DTS:DTSID="{D3769FA4-7647-4525-B959-7A54E27605C3}" DTS:ExecutableType="Microsoft.Pipeline" DTS:LocaleID="-1" DTS:ObjectName="Data Flow Task" 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\Data Flow Task\OLE DB Destination" 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="OLE DB Destination" 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].[country]</property> <property dataType="System.String" description="Specifies the variable that contains the name of the database object used to open a rowset." name="OpenRowsetVariable"></property> <property dataType="System.String" description="The SQL command to be executed." name="SqlCommand" UITypeEditor="Microsoft.DataTransformationServices.Controls.ModalMultilineStringEditor, Microsoft.DataTransformationServices.Controls, Version=15.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"></property> <property dataType="System.Int32" description="Specifies the column code page to use when code page information is unavailable from the data source." name="DefaultCodePage">1252</property> <property dataType="System.Boolean" description="Forces the use of the DefaultCodePage property value when describing character data." name="AlwaysUseDefaultCodePage">false</property> <property dataType="System.Int32" description="Specifies the mode used to access the database." name="AccessMode" typeConverter="AccessMode">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\Data Flow Task\OLE DB Destination.Connections[OleDbConnection]" connectionManagerID="Package.ConnectionManagers[dest]" connectionManagerRefId="Package.ConnectionManagers[dest]" description="The OLE DB runtime connection used to access the database." name="OleDbConnection" /> </connections> <inputs> <input refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input]" errorOrTruncationOperation="Insert" errorRowDisposition="FailComponent" hasSideEffects="true" name="OLE DB Destination Input"> <inputColumns> <inputColumn refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[name]" cachedDataType="wstr" cachedLength="255" cachedName="name" externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[name]" lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[name]" /> <inputColumn refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[abbr]" cachedDataType="wstr" cachedLength="10" cachedName="abbr" externalMetadataColumnId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[abbr]" lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[abbr]" /> </inputColumns> <externalMetadataColumns isUsed="True"> <externalMetadataColumn refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[name]" dataType="wstr" length="255" name="name" /> <externalMetadataColumn refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[abbr]" dataType="wstr" length="10" name="abbr" /> <externalMetadataColumn refId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[newCol]" dataType="wstr" length="10" name="newCol" /> </externalMetadataColumns> </input> </inputs> <outputs> <output refId="Package\Data Flow Task\OLE DB Destination.Outputs[OLE DB Destination Error Output]" exclusionGroup="1" isErrorOut="true" name="OLE DB Destination Error Output" synchronousInputId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input]"> <outputColumns> <outputColumn refId="Package\Data Flow Task\OLE DB Destination.Outputs[OLE DB Destination Error Output].Columns[ErrorCode]" dataType="i4" lineageId="Package\Data Flow Task\OLE DB Destination.Outputs[OLE DB Destination Error Output].Columns[ErrorCode]" name="ErrorCode" specialFlags="1" /> <outputColumn refId="Package\Data Flow Task\OLE DB Destination.Outputs[OLE DB Destination Error Output].Columns[ErrorColumn]" dataType="i4" lineageId="Package\Data Flow Task\OLE DB Destination.Outputs[OLE DB Destination Error Output].Columns[ErrorColumn]" name="ErrorColumn" specialFlags="2" /> </outputColumns> <externalMetadataColumns /> </output> </outputs> </component> <component refId="Package\Data Flow Task\OLE DB Source" componentClassID="Microsoft.OLEDBSource" contactInfo="OLE DB Source;Microsoft Corporation; Microsoft SQL Server; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;7" description="OLE DB Source" name="OLE DB Source" usesDispositions="true" version="7"> <properties> <property dataType="System.Int32" description="The number of seconds before a command times out. A value of 0 indicates an infinite time-out." name="CommandTimeout">0</property> <property dataType="System.String" description="Specifies the name of the database object used to open a rowset." name="OpenRowset"></property> <property dataType="System.String" description="Specifies the variable that contains the name of the database object used to open a rowset." name="OpenRowsetVariable"></property> <property dataType="System.String" description="The SQL command to be executed." name="SqlCommand" UITypeEditor="Microsoft.DataTransformationServices.Controls.ModalMultilineStringEditor, Microsoft.DataTransformationServices.Controls, Version=15.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"></property> <property dataType="System.String" description="The variable that contains the SQL command to be executed." name="SqlCommandVariable">User::sqlCmd</property> <property dataType="System.Int32" description="Specifies the column code page to use when code page information is unavailable from the data source." name="DefaultCodePage">1252</property> <property dataType="System.Boolean" description="Forces the use of the DefaultCodePage property value when describing character data." name="AlwaysUseDefaultCodePage">false</property> <property dataType="System.Int32" description="Specifies the mode used to access the database." name="AccessMode" typeConverter="AccessMode">3</property> <property dataType="System.String" description="The mappings between the parameters in the SQL command and variables." name="ParameterMapping"></property> </properties> <connections> <connection refId="Package\Data Flow Task\OLE DB Source.Connections[OleDbConnection]" connectionManagerID="Package.ConnectionManagers[src]" connectionManagerRefId="Package.ConnectionManagers[src]" description="The OLE DB runtime connection used to access the database." name="OleDbConnection" /> </connections> <outputs> <output refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output]" name="OLE DB Source Output"> <outputColumns> <outputColumn refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[name]" dataType="wstr" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[name]" length="255" lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[name]" name="name" truncationRowDisposition="FailComponent" /> <outputColumn refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[abbr]" dataType="wstr" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" externalMetadataColumnId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[abbr]" length="10" lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].Columns[abbr]" name="abbr" truncationRowDisposition="FailComponent" /> </outputColumns> <externalMetadataColumns isUsed="True"> <externalMetadataColumn refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[name]" dataType="wstr" length="255" name="name" /> <externalMetadataColumn refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[abbr]" dataType="wstr" length="10" name="abbr" /> </externalMetadataColumns> </output> <output refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output]" isErrorOut="true" name="OLE DB Source Error Output"> <outputColumns> <outputColumn refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[name]" dataType="wstr" length="255" lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[name]" name="name" /> <outputColumn refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[abbr]" dataType="wstr" length="10" lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[abbr]" name="abbr" /> <outputColumn refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ErrorCode]" dataType="i4" lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ErrorCode]" name="ErrorCode" specialFlags="1" /> <outputColumn refId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ErrorColumn]" dataType="i4" lineageId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Error Output].Columns[ErrorColumn]" name="ErrorColumn" specialFlags="2" /> </outputColumns> <externalMetadataColumns /> </output> </outputs> </component> </components> <paths> <path refId="Package\Data Flow Task.Paths[OLE DB Source Output]" endId="Package\Data Flow Task\OLE DB Destination.Inputs[OLE DB Destination Input]" name="OLE DB Source Output" startId="Package\Data Flow Task\OLE DB Source.Outputs[OLE DB Source Output]" /> </paths> </pipeline> </DTS:ObjectData> </DTS:Executable> <DTS:Executable DTS:refId="Package\Script Task" DTS:CreationName="Microsoft.ScriptTask" DTS:Description="Script Task" DTS:DTSID="{4C5A529B-ED8B-4635-B616-9871DD81F46B}" DTS:ExecutableType="Microsoft.ScriptTask" DTS:LocaleID="-1" DTS:ObjectName="Script Task" DTS:ThreadHint="0"> <DTS:Variables /> <DTS:ObjectData> <ScriptProject Name="ST_ca545157a0c348e1a00791792af1fd54" VSTAMajorVersion="15" VSTAMinorVersion="0" Language="CSharp" ReadWriteVariables="User::sqlVar"> <ProjectItem Name="Properties\AssemblyInfo.cs" Encoding="UTF8"><![CDATA[using System.Reflection; using System.Runtime.CompilerServices; // // General Information about an assembly is controlled through the following // set of attributes. Change these attribute values to modify the information // associated with an assembly. // [assembly: AssemblyTitle("ST_ca545157a0c348e1a00791792af1fd54")] [assembly: AssemblyDescription("")] [assembly: AssemblyConfiguration("")] [assembly: AssemblyCompany("")] [assembly: AssemblyProduct("ST_ca545157a0c348e1a00791792af1fd54")] [assembly: AssemblyCopyright("Copyright @ 2019")] [assembly: AssemblyTrademark("")] [assembly: AssemblyCulture("")] // // Version information for an assembly consists of the following four values: // // Major Version // Minor Version // Build Number // Revision // // You can specify all the values or you can default the Revision and Build Numbers // by using the '*' as shown below: [assembly: AssemblyVersion("1.0.*")]]]></ProjectItem> <ProjectItem Name="Properties\Resources.resx" Encoding="UTF8"><![CDATA[<?xml version="1.0" encoding="utf-8"?> <root>  <xsd:schema id="root" xmlns="" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"> <xsd:element name="root" msdata:IsDataSet="true"> <xsd:complexType> <xsd:choice maxOccurs="unbounded"> <xsd:element name="metadata"> <xsd:complexType> <xsd:sequence> <xsd:element name="value" type="xsd:string" minOccurs="0" /> </xsd:sequence> <xsd:attribute name="name" type="xsd:string" /> <xsd:attribute name="type" type="xsd:string" /> <xsd:attribute name="mimetype" type="xsd:string" /> </xsd:complexType> </xsd:element> <xsd:element name="assembly"> <xsd:complexType> <xsd:attribute name="alias" type="xsd:string" /> <xsd:attribute name="name" type="xsd:string" /> </xsd:complexType> </xsd:element> <xsd:element name="data"> <xsd:complexType> <xsd:sequence> <xsd:element name="value" type="xsd:string" minOccurs="0" msdata:Ordinal="1" /> <xsd:element name="comment" type="xsd:string" minOccurs="0" msdata:Ordinal="2" /> </xsd:sequence> <xsd:attribute name="name" type="xsd:string" msdata:Ordinal="1" /> <xsd:attribute name="type" type="xsd:string" msdata:Ordinal="3" /> <xsd:attribute name="mimetype" type="xsd:string" msdata:Ordinal="4" /> </xsd:complexType> </xsd:element> <xsd:element name="resheader"> <xsd:complexType> <xsd:sequence> <xsd:element name="value" type="xsd:string" minOccurs="0" msdata:Ordinal="1" /> </xsd:sequence> <xsd:attribute name="name" type="xsd:string" use="required" /> </xsd:complexType> </xsd:element> </xsd:choice> </xsd:complexType> </xsd:element> </xsd:schema> <resheader name="resmimetype"> <value>text/microsoft-resx</value> </resheader> <resheader name="version"> <value>2.0</value> </resheader> <resheader name="reader"> <value>System.Resources.ResXResourceReader, System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value> </resheader> <resheader name="writer"> <value>System.Resources.ResXResourceWriter, System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value> </resheader> </root>]]></ProjectItem> <ProjectItem Name="ST_ca545157a0c348e1a00791792af1fd54.csproj" Encoding="UTF8"><![CDATA[<?xml version="1.0" encoding="utf-8"?> <Project ToolsVersion="4.0" DefaultTargets="Build" xmlns="http://schemas.microsoft.com/developer/msbuild/2003"> <PropertyGroup> <ProjectTypeGuids>{30D016F9-3734-4E33-A861-5E7D899E18F3};{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}</ProjectTypeGuids> <Configuration Condition=" '$(Configuration)' == '' ">Debug</Configuration> <Platform Condition=" '$(Platform)' == '' ">AnyCPU</Platform> <ProductVersion>8.0.30703</ProductVersion> <SchemaVersion>2.0</SchemaVersion> <ProjectGuid>{9100f69a-2edd-4d87-a4f5-52a87fb6d4e7}</ProjectGuid> <OutputType>Library</OutputType> <AppDesignerFolder>Properties</AppDesignerFolder> <RootNamespace>ST_ca545157a0c348e1a00791792af1fd54</RootNamespace> <AssemblyName>ST_ca545157a0c348e1a00791792af1fd54</AssemblyName> <TargetFrameworkVersion>v4.5</TargetFrameworkVersion> <FileAlignment>512</FileAlignment> <ResolveAssemblyReferenceIgnoreTargetFrameworkAttributeVersionMismatch>true</ResolveAssemblyReferenceIgnoreTargetFrameworkAttributeVersionMismatch> <TargetFrameworkProfile></TargetFrameworkProfile> </PropertyGroup> <PropertyGroup Condition=" '$(Configuration)' == 'Debug' "> <DebugSymbols>true</DebugSymbols> <DebugType>full</DebugType> <Optimize>false</Optimize> <OutputPath>.\bin\Debug\</OutputPath> <EnableUnmanagedDebugging>false</EnableUnmanagedDebugging> <DefineConstants>DEBUG;TRACE</DefineConstants> <ErrorReport>prompt</ErrorReport> <WarningLevel>4</WarningLevel> </PropertyGroup> <PropertyGroup Condition=" '$(Configuration)' == 'Release' "> <DebugSymbols>false</DebugSymbols> <Optimize>true</Optimize> <OutputPath>.\bin\Release\</OutputPath> <EnableUnmanagedDebugging>false</EnableUnmanagedDebugging> <DefineConstants>TRACE</DefineConstants> <ErrorReport>prompt</ErrorReport> <WarningLevel>4</WarningLevel> </PropertyGroup> <ItemGroup> <Reference Include="System" /> <Reference Include="System.Data" /> <Reference Include="System.Windows.Forms" /> <Reference Include="System.Xml" /> <Reference Include="Microsoft.SqlServer.ManagedDTS, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" /> <Reference Include="Microsoft.SqlServer.ScriptTask, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" /> </ItemGroup> <ItemGroup> <AppDesigner Include="Properties\" /> <Compile Include="Properties\AssemblyInfo.cs"> <SubType>Code</SubType> </Compile> <EmbeddedResource Include="Properties\Resources.resx"> <Generator>ResXFileCodeGenerator</Generator> <LastGenOutput>Resources.Designer.cs</LastGenOutput> </EmbeddedResource> <Compile Include="Properties\Resources.Designer.cs"> <AutoGen>True</AutoGen> <DependentUpon>Resources.resx</DependentUpon> </Compile> <None Include="Properties\Settings.settings"> <Generator>SettingsSingleFileGenerator</Generator> <LastGenOutput>Settings.Designer.cs</LastGenOutput> </None> <Compile Include="Properties\Settings.Designer.cs"> <AutoGen>True</AutoGen> <DependentUpon>Settings.settings</DependentUpon> </Compile> <Compile Include="ScriptMain.cs"> <SubType>Code</SubType> </Compile> </ItemGroup>  <Import Project="$(MSBuildBinPath)\Microsoft.CSharp.targets" /> <ProjectExtensions> <VisualStudio> <FlavorProperties GUID="{30D016F9-3734-4E33-A861-5E7D899E18F3}"> <ProjectProperties HostName="ScriptTask" HostPackage="{B3A685AA-7EAF-4BC6-9940-57959FA5AC07}" ApplicationType="usd" Language="cs" TemplatesPath="" DebugInfoCommandLine="" DebugInfoWorkingDir="" IconImageList="" /> <Host Name="ScriptTask" GeneratedNamespace="$safeprojectname" IconIndex=""></Host> <ProjectClient> <HostIdentifier>SSIS_ST140</HostIdentifier> </ProjectClient> </FlavorProperties> </VisualStudio> </ProjectExtensions> </Project>]]></ProjectItem> <ProjectItem Name="ScriptMain.cs" Encoding="UTF8"><![CDATA[#region Help: Introduction to the script task /* The Script Task allows you to perform virtually any operation that can be accomplished in * a .Net application within the context of an Integration Services control flow. * * Expand the other regions which have "Help" prefixes for examples of specific ways to use * Integration Services features within this script task. */ #endregion #region Namespaces using System; using System.Data; using Microsoft.SqlServer.Dts.Runtime; using System.Windows.Forms; #endregion namespace ST_ca545157a0c348e1a00791792af1fd54 { /// <summary> /// ScriptMain is the entry point class of the script. Do not change the name, attributes, /// or parent of this class. /// </summary> [Microsoft.SqlServer.Dts.Tasks.ScriptTask.SSISScriptTaskEntryPointAttribute] public partial class ScriptMain : Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTARTScriptObjectModelBase { #region Help: Using Integration Services variables and parameters in a script /* To use a variable in this script, first ensure that the variable has been added to * either the list contained in the ReadOnlyVariables property or the list contained in * the ReadWriteVariables property of this script task, according to whether or not your * code needs to write to the variable. To add the variable, save this script, close this instance of * Visual Studio, and update the ReadOnlyVariables and * ReadWriteVariables properties in the Script Transformation Editor window. * To use a parameter in this script, follow the same steps. Parameters are always read-only. * * Example of reading from a variable: * DateTime startTime = (DateTime) Dts.Variables["System::StartTime"].Value; * * Example of writing to a variable: * Dts.Variables["User::myStringVariable"].Value = "new value"; * * Example of reading from a package parameter: * int batchId = (int) Dts.Variables["$Package::batchId"].Value; * * Example of reading from a project parameter: * int batchId = (int) Dts.Variables["$Project::batchId"].Value; * * Example of reading from a sensitive project parameter: * int batchId = (int) Dts.Variables["$Project::batchId"].GetSensitiveValue(); * */ #endregion #region Help: Firing Integration Services events from a script /* This script task can fire events for logging purposes. * * Example of firing an error event: * Dts.Events.FireError(18, "Process Values", "Bad value", "", 0); * * Example of firing an information event: * Dts.Events.FireInformation(3, "Process Values", "Processing has started", "", 0, ref fireAgain) * * Example of firing a warning event: * Dts.Events.FireWarning(14, "Process Values", "No values received for input", "", 0); * */ #endregion #region Help: Using Integration Services connection managers in a script /* Some types of connection managers can be used in this script task. See the topic * "Working with Connection Managers Programatically" for details. * * Example of using an ADO.Net connection manager: * object rawConnection = Dts.Connections["Sales DB"].AcquireConnection(Dts.Transaction); * SqlConnection myADONETConnection = (SqlConnection)rawConnection; * //Use the connection in some code here, then release the connection * Dts.Connections["Sales DB"].ReleaseConnection(rawConnection); * * Example of using a File connection manager * object rawConnection = Dts.Connections["Prices.zip"].AcquireConnection(Dts.Transaction); * string filePath = (string)rawConnection; * //Use the connection in some code here, then release the connection * Dts.Connections["Prices.zip"].ReleaseConnection(rawConnection); * */ #endregion /// <summary> /// This method is called when this script task executes in the control flow. /// Before returning from this method, set the value of Dts.TaskResult to indicate success or failure. /// To open Help, press F1. /// </summary> public void Main() { // TODO: Add your code here Dts.Variables["User::sqlVar"].Value = "america"; Dts.TaskResult = (int)ScriptResults.Success; } #region ScriptResults declaration /// <summary> /// This enum provides a convenient shorthand within the scope of this class for setting the /// result of the script. /// /// This code was generated automatically. /// </summary> enum ScriptResults { Success = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Success, Failure = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Failure }; #endregion } }]]></ProjectItem> <ProjectItem Name="Project" Encoding="UTF16LE"><![CDATA[<?xml version="1.0" encoding="UTF-16" standalone="yes"?> <c:Project xmlns:c="http://schemas.microsoft.com/codeprojectml/2010/08/main" xmlns:msb="http://schemas.microsoft.com/developer/msbuild/2003" runtimeVersion="4.0" schemaVersion="1.0"> <msb:PropertyGroup> <msb:CodeName>ST_ca545157a0c348e1a00791792af1fd54</msb:CodeName> <msb:Language>msBuild</msb:Language> <msb:DisplayName>ST_ca545157a0c348e1a00791792af1fd54</msb:DisplayName> <msb:ProjectId>{0E4F2483-113B-4BA7-8344-1E8119DA42DB}</msb:ProjectId> </msb:PropertyGroup> <msb:ItemGroup> <msb:Project Include="ST_ca545157a0c348e1a00791792af1fd54.csproj" /> <msb:File Include="Properties\Settings.Designer.cs" /> <msb:File Include="Properties\Settings.settings" /> <msb:File Include="Properties\AssemblyInfo.cs" /> <msb:File Include="Properties\Resources.resx" /> <msb:File Include="Properties\Resources.Designer.cs" /> <msb:File Include="ScriptMain.cs" /> </msb:ItemGroup> </c:Project>]]></ProjectItem> <ProjectItem Name="Properties\Settings.Designer.cs" Encoding="UTF8"><![CDATA[//------------------------------------------------------------------------------ // <auto-generated> // This code was generated by a tool. // // Changes to this file may cause incorrect behavior and will be lost if // the code is regenerated. // </auto-generated> //------------------------------------------------------------------------------ [assembly: global::System.Diagnostics.CodeAnalysis.SuppressMessageAttribute("Microsoft.Performance", "CA1811:AvoidUncalledPrivateCode", Scope="member", Target="ST_ca545157a0c348e1a00791792af1fd54.Properties.Settings.get_Default():ST_ca545157a0c348e1a00791792af1fd54.Properties.Sett" + "ings")] namespace ST_ca545157a0c348e1a00791792af1fd54.Properties { internal sealed partial class Settings : global::System.Configuration.ApplicationSettingsBase { [global::System.Runtime.CompilerServices.CompilerGeneratedAttribute()] private static Settings defaultInstance = new Settings(); public static Settings Default { get { return defaultInstance; } } } }]]></ProjectItem> <ProjectItem Name="Properties\Settings.settings" Encoding="UTF8"><![CDATA[<?xml version='1.0' encoding='iso-8859-1'?> <SettingsFile xmlns="uri:settings" CurrentProfile="(Default)"> <Profiles> <Profile Name="(Default)" /> </Profiles> <Settings /> </SettingsFile>]]></ProjectItem> <ProjectItem Name="Properties\Resources.Designer.cs" Encoding="UTF8"><![CDATA[//------------------------------------------------------------------------------ // <auto-generated> // This code was generated by a tool. // // Changes to this file may cause incorrect behavior and will be lost if // the code is regenerated. // </auto-generated> //------------------------------------------------------------------------------ [assembly: global::System.Diagnostics.CodeAnalysis.SuppressMessageAttribute("Microsoft.Performance", "CA1811:AvoidUncalledPrivateCode", Scope="member", Target="ST_ca545157a0c348e1a00791792af1fd54.Properties.Resources.get_ResourceManager():System.Resources.Resou" + "rceManager")] [assembly: global::System.Diagnostics.CodeAnalysis.SuppressMessageAttribute("Microsoft.Performance", "CA1811:AvoidUncalledPrivateCode", Scope="member", Target="ST_ca545157a0c348e1a00791792af1fd54.Properties.Resources.get_Culture():System.Globalization.CultureIn" + "fo")] [assembly: global::System.Diagnostics.CodeAnalysis.SuppressMessageAttribute("Microsoft.Performance", "CA1811:AvoidUncalledPrivateCode", Scope="member", Target="ST_ca545157a0c348e1a00791792af1fd54.Properties.Resources.set_Culture(System.Globalization.CultureInfo" + "):Void")] namespace ST_ca545157a0c348e1a00791792af1fd54.Properties { /// <summary> /// A strongly-typed resource class, for looking up localized strings, etc. /// </summary> // This class was auto-generated by the StronglyTypedResourceBuilder // class via a tool like ResGen or Visual Studio. // To add or remove a member, edit your .ResX file then rerun ResGen // with the /str option, or rebuild your VS project. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] internal class Resources { private static global::System.Resources.ResourceManager resourceMan; private static global::System.Globalization.CultureInfo resourceCulture; [global::System.Diagnostics.CodeAnalysis.SuppressMessageAttribute("Microsoft.Performance", "CA1811:AvoidUncalledPrivateCode")] internal Resources() { } /// <summary> /// Returns the cached ResourceManager instance used by this class. /// </summary> [global::System.ComponentModel.EditorBrowsableAttribute(System.ComponentModel.EditorBrowsableState.Advanced)] internal static global::System.Resources.ResourceManager ResourceManager { get { if ((resourceMan == null)) { global::System.Resources.ResourceManager temp = new global::System.Resources.ResourceManager("ST_ca545157a0c348e1a00791792af1fd54.Properties.Resources", typeof(Resources).Assembly); resourceMan = temp; } return resourceMan; } } /// <summary> /// Overrides the current thread's CurrentUICulture property for all /// resource lookups using this strongly typed resource class. /// </summary> [global::System.ComponentModel.EditorBrowsableAttribute(System.ComponentModel.EditorBrowsableState.Advanced)] internal static global::System.Globalization.CultureInfo Culture { get { return resourceCulture; } set { resourceCulture = value; } } } }]]></ProjectItem> <BinaryItem Name="ST_ca545157a0c348e1a00791792af1fd54.dll">TVqQAAMAAAAEAAAA//8AALgAAAAAAAAAQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAgAAAAA4fug4AtAnNIbgBTM0hVGhpcyBwcm9ncmFtIGNhbm5vdCBiZSBydW4gaW4gRE9TIG1v ZGUuDQ0KJAAAAAAAAABQRQAATAEDADea+V0AAAAAAAAAAOAAIiALATAAAA4AAAAIAAAAAAAAai0A AAAgAAAAQAAAAAAAEAAgAAAAAgAABAAAAAAAAAAGAAAAAAAAAACAAAAAAgAAAAAAAAMAYIUAABAA ABAAAAAAEAAAEAAAAAAAABAAAAAAAAAAAAAAABgtAABPAAAAAEAAAGwEAAAAAAAAAAAAAAAAAAAA AAAAAGAAAAwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAIAAACAAAAAAAAAAAAAAACCAAAEgAAAAAAAAAAAAAAC50ZXh0AAAAcA0AAAAgAAAADgAAAAIA AAAAAAAAAAAAAAAAACAAAGAucnNyYwAAAGwEAAAAQAAAAAYAAAAQAAAAAAAAAAAAAAAAAABAAABA LnJlbG9jAAAMAAAAAGAAAAACAAAAFgAAAAAAAAAAAAAAAAAAQAAAQgAAAAAAAAAAAAAAAAAAAABM LQAAAAAAAEgAAAACAAUA5CAAAHwLAAABAAAAAAAAAGAsAAC4AAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAALICKBAAAApvEQAACnIBAABwbxIAAApyGwAAcG8TAAAKAigQ AAAKFm8UAAAKKh4CKBUAAAoqHgIoFgAACiqufgEAAAQtHnIrAABw0AMAAAIoFwAACm8YAAAKcxkA AAqAAQAABH4BAAAEKhp+AgAABCoeAoACAAAEKhp+AwAABCoeAigaAAAKKi5zCAAABoADAAAEKgBC U0pCAQABAAAAAAAMAAAAdjQuMC4zMDMxOQAAAAAFAGwAAACwAwAAI34AABwEAABUBQAAI1N0cmlu Z3MAAAAAcAkAAKAAAAAjVVMAEAoAABAAAAAjR1VJRAAAACAKAABcAQAAI0Jsb2IAAAAAAAAAAgAA AVcdoAEJAwAAAPoBMwAWAAABAAAAHQAAAAUAAAAGAAAACQAAAAEAAAAaAAAAAgAAABAAAAACAAAA AwAAAAQAAAABAAAABAAAAAEAAAABAAAAAABsAwEAAAAAAAYAJQI8BAYAtAI8BAYAcQEpBA8AsAQA AAYAngHqAwYACALqAwYA6QHqAwYAmwLqAwYARQLqAwYAXgLqAwYAtQHqAwYA0AHiAgoAeQIbAwoA 8AAbAwYApAOdAwYAVAEpBAYAIwWdAwYADARcBAYA/APVAw4AJAFWAw4AhQFWAw4ADAHAAwYAOQE8 BAoARAMbAxIA8gSbABIAbgCbAAYAuwCdAwYAdwCdAwYASQXqAwAAAAAlAAAAAAABAAEAAQAQALUD AQA5AAEAAQAAABAAYwS/BEUAAQADAAABEAD8BL8EWQADAAcAAwEAABUFAAA9AAQACgARAKkDXwAR AOAAYwARAF4AZwAGBk0AawBWgAUFbgBWgMAAbgBQIAAAAACGALsDBgABAH0gAAAAAIYYHAQGAAEA hSAAAAAAgxgcBAYAAQCNIAAAAACTCAgEcgABALkgAAAAAJMIyAB3AAEAwCAAAAAAkwjUAHwAAQDI IAAAAACWCCoFggACAM8gAAAAAIYYHAQGAAIA1yAAAAAAkRgiBIcAAgAAAAEA3AIJABwEAQARABwE BgAZABwECgApABwEEAAxABwEEAA5ABwEEABBABwEEABJABwEEABRABwEEABZABwEEABhABwEEABp ABwEBgCBABwEBgCpABwEFQC5ABwEBgBxAA0FGwDBAO4EIADJAJQDJQDRANICKwDBADYFAQBxABwE BgCJABwEBgDZAIkAMADZAEUFNwCRABwEPACxABwEBgAIABQAVQAIABgAWgApAHMAwgAuAAsAmgAu ABMAowAuABsAwgAuACMAywAuACsA9AAuADMA9AAuADsA9AAuAEMAywAuAEsA+gAuAFMA9AAuAFsA EQFDAGMAWgBJAHMAwgBhAHsAWgBjAGsAWgADAAEABAADAAAADASLAAAA6ACQAAAALgWVAAIABAAD AAIABQAFAAEABgAFAAIABwAHAASAAAABAAAAexwbFwAAAAAAAAEAAAAEAAAAAAAAAAAAAABDAFUA AAAAAA4AAAAAAAAAAAAAAEwA/AIAAAAABAAAAAAAAAAAAAAAQwCdAwAAAAAOAAAAAAAAAAAAAABM AC4AAAAAAAAAAAABAAAAbQQAAAUAAgAAAABTVF9jYTU0NTE1N2EwYzM0OGUxYTAwNzkxNzkyYWYx ZmQ1NAA8TW9kdWxlPgBNaWNyb3NvZnQuU3FsU2VydmVyLk1hbmFnZWREVFMAdmFsdWVfXwBtc2Nv cmxpYgBkZWZhdWx0SW5zdGFuY2UAVmFyaWFibGUAUnVudGltZVR5cGVIYW5kbGUAR2V0VHlwZUZy b21IYW5kbGUATWljcm9zb2Z0LlNxbFNlcnZlci5EdHMuUnVudGltZQBUeXBlAEZhaWx1cmUAZ2V0 X0N1bHR1cmUAc2V0X0N1bHR1cmUAcmVzb3VyY2VDdWx0dXJlAFZTVEFSVFNjcmlwdE9iamVjdE1v ZGVsQmFzZQBBcHBsaWNhdGlvblNldHRpbmdzQmFzZQBFZGl0b3JCcm93c2FibGVTdGF0ZQBDb21w aWxlckdlbmVyYXRlZEF0dHJpYnV0ZQBEZWJ1Z2dlck5vblVzZXJDb2RlQXR0cmlidXRlAERlYnVn Z2FibGVBdHRyaWJ1dGUARWRpdG9yQnJvd3NhYmxlQXR0cmlidXRlAEFzc2VtYmx5VGl0bGVBdHRy aWJ1dGUAQXNzZW1ibHlUcmFkZW1hcmtBdHRyaWJ1dGUAVGFyZ2V0RnJhbWV3b3JrQXR0cmlidXRl AEFzc2VtYmx5Q29uZmlndXJhdGlvbkF0dHJpYnV0ZQBBc3NlbWJseURlc2NyaXB0aW9uQXR0cmli dXRlAENvbXBpbGF0aW9uUmVsYXhhdGlvbnNBdHRyaWJ1dGUAQXNzZW1ibHlQcm9kdWN0QXR0cmli dXRlAEFzc2VtYmx5Q29weXJpZ2h0QXR0cmlidXRlAFNTSVNTY3JpcHRUYXNrRW50cnlQb2ludEF0 dHJpYnV0ZQBBc3NlbWJseUNvbXBhbnlBdHRyaWJ1dGUAUnVudGltZUNvbXBhdGliaWxpdHlBdHRy aWJ1dGUAc2V0X1ZhbHVlAHZhbHVlAFN5c3RlbS5SdW50aW1lLlZlcnNpb25pbmcATWljcm9zb2Z0 LlNxbFNlcnZlci5TY3JpcHRUYXNrAE1pY3Jvc29mdC5TcWxTZXJ2ZXIuRHRzLlRhc2tzLlNjcmlw dFRhc2sAU2NyaXB0T2JqZWN0TW9kZWwAU3lzdGVtLkNvbXBvbmVudE1vZGVsAFNUX2NhNTQ1MTU3 YTBjMzQ4ZTFhMDA3OTE3OTJhZjFmZDU0LmRsbABnZXRfSXRlbQBTeXN0ZW0ARW51bQByZXNvdXJj ZU1hbgBTY3JpcHRNYWluAFN5c3RlbS5Db25maWd1cmF0aW9uAFN5c3RlbS5HbG9iYWxpemF0aW9u AFN5c3RlbS5SZWZsZWN0aW9uAEN1bHR1cmVJbmZvAGdldF9SZXNvdXJjZU1hbmFnZXIALmN0b3IA LmNjdG9yAFN5c3RlbS5EaWFnbm9zdGljcwBTeXN0ZW0uUnVudGltZS5Db21waWxlclNlcnZpY2Vz AFN5c3RlbS5SZXNvdXJjZXMAU1RfY2E1NDUxNTdhMGMzNDhlMWEwMDc5MTc5MmFmMWZkNTQuUHJv cGVydGllcy5SZXNvdXJjZXMucmVzb3VyY2VzAERlYnVnZ2luZ01vZGVzAFNUX2NhNTQ1MTU3YTBj MzQ4ZTFhMDA3OTE3OTJhZjFmZDU0LlByb3BlcnRpZXMAZ2V0X1ZhcmlhYmxlcwBTZXR0aW5ncwBT dWNjZXNzAGdldF9EdHMAU2NyaXB0UmVzdWx0cwBPYmplY3QAZ2V0X0RlZmF1bHQAc2V0X1Rhc2tS ZXN1bHQAZ2V0X0Fzc2VtYmx5AAAAABlVAHMAZQByADoAOgBzAHEAbABWAGEAcgAAD2EAbQBlAHIA aQBjAGEAAHFTAFQAXwBjAGEANQA0ADUAMQA1ADcAYQAwAGMAMwA0ADgAZQAxAGEAMAAwADcAOQAx ADcAOQAyAGEAZgAxAGYAZAA1ADQALgBQAHIAbwBwAGUAcgB0AGkAZQBzAC4AUgBlAHMAbwB1AHIA YwBlAHMAAAAAANd4nBYdA7BDj40dKO4SFGMABCABAQgDIAABBSABARERBCABAQ4FIAEBEVEEIAAS YQQgABJlBSABEmkcBCABARwGAAESbRFxBCAAEnUGIAIBDhJ1CLd6XFYZNOCJCImEXc2AgMyRBAAA AAAEAQAAAAMGEkkDBhJNAwYSEAIGCAMGERQEAAASSQQAABJNBQABARJNBAAAEhADAAABBAgAEkkE CAASTQQIABIQCAEACAAAAAAAHgEAAQBUAhZXcmFwTm9uRXhjZXB0aW9uVGhyb3dzAQgBAAIAAAAA ACgBACNTVF9jYTU0NTE1N2EwYzM0OGUxYTAwNzkxNzkyYWYxZmQ1NAAABQEAAAAAFgEAEUNvcHly aWdodCBAICAyMDE5AABJAQAaLk5FVEZyYW1ld29yayxWZXJzaW9uPXY0LjUBAFQOFEZyYW1ld29y a0Rpc3BsYXlOYW1lEi5ORVQgRnJhbWV3b3JrIDQuNQC0AAAAzsrvvgEAAACRAAAAbFN5c3RlbS5S ZXNvdXJjZXMuUmVzb3VyY2VSZWFkZXIsIG1zY29ybGliLCBWZXJzaW9uPTQuMC4wLjAsIEN1bHR1 cmU9bmV1dHJhbCwgUHVibGljS2V5VG9rZW49Yjc3YTVjNTYxOTM0ZTA4OSNTeXN0ZW0uUmVzb3Vy Y2VzLlJ1bnRpbWVSZXNvdXJjZVNldAIAAAAAAAAAAAAAAFBBRFBBRFC0AAAAQC0AAAAAAAAAAAAA Wi0AAAAgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEwtAAAAAAAAAAAAAAAAX0NvckRsbE1haW4AbXNj b3JlZS5kbGwAAAAAAP8lACAAEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAQAQAAAAGAAAgAAAAAAAAAAAAAAAAAAAAQABAAAAMAAAgAAAAAAAAAAAAAAAAAAAAQAA AAAASAAAAFhAAAAQBAAAAAAAAAAAAAAQBDQAAABWAFMAXwBWAEUAUgBTAEkATwBOAF8ASQBOAEYA TwAAAAAAvQTv/gAAAQAAAAEAGxd7HAAAAQAbF3scPwAAAAAAAAAEAAAAAgAAAAAAAAAAAAAAAAAA AEQAAAABAFYAYQByAEYAaQBsAGUASQBuAGYAbwAAAAAAJAAEAAAAVAByAGEAbgBzAGwAYQB0AGkA bwBuAAAAAAAAALAEcAMAAAEAUwB0AHIAaQBuAGcARgBpAGwAZQBJAG4AZgBvAAAATAMAAAEAMAAw ADAAMAAwADQAYgAwAAAAGgABAAEAQwBvAG0AbQBlAG4AdABzAAAAAAAAACIAAQABAEMAbwBtAHAA YQBuAHkATgBhAG0AZQAAAAAAAAAAAHAAJAABAEYAaQBsAGUARABlAHMAYwByAGkAcAB0AGkAbwBu AAAAAABTAFQAXwBjAGEANQA0ADUAMQA1ADcAYQAwAGMAMwA0ADgAZQAxAGEAMAAwADcAOQAxADcA OQAyAGEAZgAxAGYAZAA1ADQAAAA8AA4AAQBGAGkAbABlAFYAZQByAHMAaQBvAG4AAAAAADEALgAw AC4ANwAyADkAMQAuADUAOQAxADUAAABwACgAAQBJAG4AdABlAHIAbgBhAGwATgBhAG0AZQAAAFMA VABfAGMAYQA1ADQANQAxADUANwBhADAAYwAzADQAOABlADEAYQAwADAANwA5ADEANwA5ADIAYQBm ADEAZgBkADUANAAuAGQAbABsAAAASAASAAEATABlAGcAYQBsAEMAbwBwAHkAcgBpAGcAaAB0AAAA QwBvAHAAeQByAGkAZwBoAHQAIABAACAAIAAyADAAMQA5AAAAKgABAAEATABlAGcAYQBsAFQAcgBh AGQAZQBtAGEAcgBrAHMAAAAAAAAAAAB4ACgAAQBPAHIAaQBnAGkAbgBhAGwARgBpAGwAZQBuAGEA bQBlAAAAUwBUAF8AYwBhADUANAA1ADEANQA3AGEAMABjADMANAA4AGUAMQBhADAAMAA3ADkAMQA3 ADkAMgBhAGYAMQBmAGQANQA0AC4AZABsAGwAAABoACQAAQBQAHIAbwBkAHUAYwB0AE4AYQBtAGUA AAAAAFMAVABfAGMAYQA1ADQANQAxADUANwBhADAAYwAzADQAOABlADEAYQAwADAANwA5ADEANwA5 ADIAYQBmADEAZgBkADUANAAAAEAADgABAFAAcgBvAGQAdQBjAHQAVgBlAHIAcwBpAG8AbgAAADEA LgAwAC4ANwAyADkAMQAuADUAOQAxADUAAABEAA4AAQBBAHMAcwBlAG0AYgBsAHkAIABWAGUAcgBz AGkAbwBuAAAAMQAuADAALgA3ADIAOQAxAC4ANQA5ADEANQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAgAAAMAAAAbD0A AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA</BinaryItem> </ScriptProject> </DTS:ObjectData> </DTS:Executable> </DTS:Executables> <DTS:PrecedenceConstraints> <DTS:PrecedenceConstraint DTS:refId="Package.PrecedenceConstraints[Constraint]" DTS:CreationName="" DTS:DTSID="{1472C513-41A6-4B39-8343-607F31261EEB}" DTS:From="Package\Script Task" DTS:LogicalAnd="True" DTS:ObjectName="Constraint" DTS:To="Package\Data Flow Task" /> </DTS:PrecedenceConstraints> <DTS:DesignTimeProperties><![CDATA[<?xml version="1.0"?>    <Objects Version="8">  <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="155,42" Id="Package\Data Flow Task" TopLeft="537,301" /> <NodeLayout Size="134,42" Id="Package\Script Task" TopLeft="249,198" /> <EdgeLayout Id="Package.PrecedenceConstraints[Constraint]" TopLeft="316,240"> <EdgeLayout.Curve> <mssgle:Curve StartConnector="{assembly:Null}" EndConnector="298.5,61" Start="0,0" End="298.5,53.5"> <mssgle:Curve.Segments> <mssgle:SegmentCollection Capacity="5"> <mssgle:LineSegment End="0,26.5" /> <mssgle:CubicBezierSegment Point1="0,26.5" Point2="0,30.5" Point3="4,30.5" /> <mssgle:LineSegment End="294.5,30.5" /> <mssgle:CubicBezierSegment Point1="294.5,30.5" Point2="298.5,30.5" Point3="298.5,34.5" /> <mssgle:LineSegment End="298.5,53.5" /> </mssgle:SegmentCollection> </mssgle:Curve.Segments> </mssgle:Curve> </EdgeLayout.Curve> <EdgeLayout.Labels> <EdgeLabelCollection /> </EdgeLayout.Labels> </EdgeLayout> </GraphLayout> </LayoutInfo> </Package> <TaskHost design-time-name="Package\Data Flow Task"> <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="157,42" Id="Package\Data Flow Task\OLE DB Source" TopLeft="283.5,223.5" /> <NodeLayout Size="177,42" Id="Package\Data Flow Task\OLE DB Destination" TopLeft="779.5,198.5" /> <EdgeLayout Id="Package\Data Flow Task.Paths[OLE DB Source Output]" TopLeft="440.5,244.5"> <EdgeLayout.Curve> <mssgle:Curve StartConnector="{assembly:Null}" EndConnector="339,-25" Start="0,0" End="331.5,-25"> <mssgle:Curve.Segments> <mssgle:SegmentCollection Capacity="5"> <mssgle:LineSegment End="165.5,0" /> <mssgle:CubicBezierSegment Point1="165.5,0" Point2="169.5,0" Point3="169.5,-4" /> <mssgle:LineSegment End="169.5,-21" /> <mssgle:CubicBezierSegment Point1="169.5,-21" Point2="169.5,-25" Point3="173.5,-25" /> <mssgle:LineSegment End="331.5,-25" /> </mssgle:SegmentCollection> </mssgle:Curve.Segments> </mssgle:Curve> </EdgeLayout.Curve> <EdgeLayout.Labels> <EdgeLabelCollection /> </EdgeLayout.Labels> </EdgeLayout> </GraphLayout> </LayoutInfo> </TaskHost> <PipelineComponentMetadata design-time-name="Package\Data Flow Task\OLE DB Source"> <Properties> <Property> <Name>DataSourceViewID</Name> </Property> </Properties> </PipelineComponentMetadata> <PipelineComponentMetadata design-time-name="Package\Data Flow Task\OLE DB Destination"> <Properties> <Property> <Name>DataSourceViewID</Name> </Property> <Property> <Name>TableInfoObjectType</Name> <Value type="q2:string">Table</Value> </Property> </Properties> </PipelineComponentMetadata> </Objects>]]></DTS:DesignTimeProperties> </DTS:Executable>

SamplesV2/SQLServerIntegrationServices/publicpreview/SelfHostedIRProxy/Limitations/ParameterMappingSample.dtsx (1,099 lines of code) (raw):