Skip to content

Instantly share code, notes, and snippets.

@jsnape

jsnape/DateSourceSample.dtsx

Created January 15, 2024 15:52
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jsnape/2419a66effc71cf9e7701e4fe5cc514e to your computer and use it in GitHub Desktop.
Save jsnape/2419a66effc71cf9e7701e4fe5cc514e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
DateSourceSample.dtsx
<?xml version="1.0"?><DTS:Executable xmlns:DTS="www.microsoft.com/SqlServer/Dts" DTS:ExecutableType="SSIS.Package.2">
<DTS:Property DTS:Name="PackageFormatVersion">3</DTS:Property>
<DTS:Property DTS:Name="VersionComments"></DTS:Property>
<DTS:Property DTS:Name="CreatorName">JSNAPEHOME\James</DTS:Property>
<DTS:Property DTS:Name="CreatorComputerName">JSNAPEHOME</DTS:Property>
<DTS:Property DTS:Name="CreationDate" DTS:DataType="7">4/16/2009 6:58:04 PM</DTS:Property>
<DTS:Property DTS:Name="PackageType">5</DTS:Property>
<DTS:Property DTS:Name="ProtectionLevel">1</DTS:Property>
<DTS:Property DTS:Name="MaxConcurrentExecutables">-1</DTS:Property>
<DTS:Property DTS:Name="PackagePriorityClass">0</DTS:Property>
<DTS:Property DTS:Name="VersionMajor">1</DTS:Property>
<DTS:Property DTS:Name="VersionMinor">0</DTS:Property>
<DTS:Property DTS:Name="VersionBuild">3</DTS:Property>
<DTS:Property DTS:Name="VersionGUID">{EB8A1DAD-B415-420D-A40F-E9C349EF0BDF}</DTS:Property>
<DTS:Property DTS:Name="EnableConfig">0</DTS:Property>
<DTS:Property DTS:Name="CheckpointFileName"></DTS:Property>
<DTS:Property DTS:Name="SaveCheckpoints">0</DTS:Property>
<DTS:Property DTS:Name="CheckpointUsage">0</DTS:Property>
<DTS:Property DTS:Name="SuppressConfigurationWarnings">0</DTS:Property>
<DTS:Property DTS:Name="LastModifiedProductVersion">10.0.1600.22</DTS:Property>
<DTS:Property DTS:Name="ForceExecValue">0</DTS:Property>
<DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</DTS:Property>
<DTS:Property DTS:Name="ForceExecutionResult">-1</DTS:Property>
<DTS:Property DTS:Name="Disabled">0</DTS:Property>
<DTS:Property DTS:Name="FailPackageOnFailure">0</DTS:Property>
<DTS:Property DTS:Name="FailParentOnFailure">0</DTS:Property>
<DTS:Property DTS:Name="MaxErrorCount">1</DTS:Property>
<DTS:Property DTS:Name="ISOLevel">1048576</DTS:Property>
<DTS:Property DTS:Name="LocaleID">2057</DTS:Property>
<DTS:Property DTS:Name="TransactionOption">1</DTS:Property>
<DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
<DTS:LoggingOptions>
<DTS:Property DTS:Name="LoggingMode">0</DTS:Property>
<DTS:Property DTS:Name="FilterKind">1</DTS:Property>
<DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></DTS:Property></DTS:LoggingOptions>
<DTS:Executable DTS:ExecutableType="{E3CFBEA8-1F48-40D8-91E1-2DEDC1EDDD56}">
<DTS:Property DTS:Name="ExecutionLocation">0</DTS:Property>
<DTS:Property DTS:Name="ExecutionAddress"></DTS:Property>
<DTS:Property DTS:Name="TaskContact"></DTS:Property>
<DTS:Property DTS:Name="ForceExecValue">0</DTS:Property>
<DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</DTS:Property>
<DTS:Property DTS:Name="ForceExecutionResult">-1</DTS:Property>
<DTS:Property DTS:Name="Disabled">0</DTS:Property>
<DTS:Property DTS:Name="FailPackageOnFailure">0</DTS:Property>
<DTS:Property DTS:Name="FailParentOnFailure">0</DTS:Property>
<DTS:Property DTS:Name="MaxErrorCount">1</DTS:Property>
<DTS:Property DTS:Name="ISOLevel">1048576</DTS:Property>
<DTS:Property DTS:Name="LocaleID">-1</DTS:Property>
<DTS:Property DTS:Name="TransactionOption">1</DTS:Property>
<DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
<DTS:LoggingOptions>
<DTS:Property DTS:Name="LoggingMode">0</DTS:Property>
<DTS:Property DTS:Name="FilterKind">1</DTS:Property>
<DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></DTS:Property></DTS:LoggingOptions>
<DTS:Property DTS:Name="ObjectName">Data Flow Task</DTS:Property>
<DTS:Property DTS:Name="DTSID">{31B99051-27C6-4FB1-9178-B2E06C8EB11D}</DTS:Property>
<DTS:Property DTS:Name="Description">Data Flow Task</DTS:Property>
<DTS:Property DTS:Name="CreationName">{E3CFBEA8-1F48-40D8-91E1-2DEDC1EDDD56}</DTS:Property>
<DTS:Property DTS:Name="DisableEventHandlers">0</DTS:Property><DTS:ObjectData><pipeline id="0" name="pipelineXml" description="pipelineXml" defaultBufferMaxRows="10000" engineThreads="10" defaultBufferSize="10485760" BLOBTempStoragePath="" bufferTempStoragePath="" runInOptimizedMode="true">
<components>
<component id="1" name="Date Source" componentClassID="{2E42D45B-F83C-400F-8D77-61DDE6A7DF29}" description="Executes a custom script." localeId="-1" usesDispositions="false" validateExternalMetadata="True" version="4" pipelineVersion="0" contactInfo="Executes a custom script.;Microsoft Corporation; Microsoft SqlServer v10; © 2007 Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;4">
<properties>
<property id="5" name="SourceCode" dataType="System.String" state="cdata" isArray="true" description="Stores the source code of the component" typeConverter="" UITypeEditor="" containsID="false" expressionType="None"><arrayElements arrayElementCount="18"><arrayElement dataType="System.String"><![CDATA[\main.cs]]></arrayElement><arrayElement dataType="System.String"><![CDATA[/* Microsoft SQL Server Integration Services Script Component
* Write scripts using Microsoft Visual C# 2008.
* ScriptMain is the entry point class of the script.*/
using System;
using System.Data;
using Microsoft.SqlServer.Dts.Pipeline.Wrapper;
using Microsoft.SqlServer.Dts.Runtime.Wrapper;
using System.Globalization;
[Microsoft.SqlServer.Dts.Pipeline.SSISScriptComponentEntryPointAttribute]
public class ScriptMain : UserComponent
{
private static CultureInfo EnglishCulture = CultureInfo.GetCultureInfo("en-US");
private static CultureInfo FrenchCulture = CultureInfo.GetCultureInfo("fr-FR");
private static CultureInfo SpanishCulture = CultureInfo.GetCultureInfo("es-ES");
public override void CreateNewOutputRows()
{
var output = this.DatesBuffer;
int currentYear = DateTime.Today.Year;
DateTime date = new DateTime(currentYear - 10, 1, 1);
DateTime endDate = new DateTime(currentYear + 5, 1, 1);
GregorianCalendar calendar = new GregorianCalendar();
while (date < endDate)
{
output.AddRow();
output.DateKey = date.Year * 10000 + date.Month * 100 + date.Day;
output.FullAlternateDateKey = date;
output.CalendarYear = date.Year;
output.MonthNumberOfYear = (byte)date.Month;
output.DayNumberOfMonth = (byte)date.Day;
int calendarQuarter = 1;
if (date.Month > 3)
calendarQuarter = 2;
if (date.Month > 6)
calendarQuarter = 3;
if (date.Month > 9)
calendarQuarter = 4;
int calendarSemester = date.Month < 7 ? 1 : 2;
output.CalendarQuarter = (byte)calendarQuarter;
output.CalendarSemester = (byte)calendarSemester;
output.DayNumberOfWeek = (byte)date.DayOfWeek;
output.DayNumberOfYear = (ushort)date.DayOfYear;
output.EnglishDayNameOfWeek = date.ToString("dddd", EnglishCulture);
output.EnglishMonthName = date.ToString("MMMM", EnglishCulture);
output.FrenchDayNameOfWeek = date.ToString("dddd", FrenchCulture);
output.FrenchMonthName = date.ToString("MMMM", FrenchCulture);
output.SpanishDayNameOfWeek = date.ToString("dddd", SpanishCulture);
output.SpanishMonthName = date.ToString("MMMM", SpanishCulture);
output.WeekNumberOfYear = (byte)calendar.GetWeekOfYear(date, CalendarWeekRule.FirstDay, DayOfWeek.Sunday);
int fiscalQuarter = calendarQuarter + 2;
if (fiscalQuarter > 4)
fiscalQuarter -= 4;
int fiscalSemester = calendarSemester + 1;
if (fiscalSemester > 2)
fiscalSemester -= 2;
output.FiscalQuarter = (byte)fiscalQuarter;
output.FiscalSemester = (byte)fiscalSemester;
output.FiscalYear = (short)(date.Month < 7 ? date.Year : date.Year + 1);
date = date.AddDays(1);
}
}
}
]]></arrayElement><arrayElement dataType="System.String"><![CDATA[\properties\resources.resx]]></arrayElement><arrayElement dataType="System.String"><![CDATA[<?xml version="1.0" encoding="utf-8"?>
<root>
<!--
Microsoft ResX Schema
Version 2.0
The primary goals of this format is to allow a simple XML format
that is mostly human readable. The generation and parsing of the
various data types are done through the TypeConverter classes
associated with the data types.
Example:
... ado.net/XML headers & schema ...
<resheader name="resmimetype">text/microsoft-resx</resheader>
<resheader name="version">2.0</resheader>
<resheader name="reader">System.Resources.ResXResourceReader, System.Windows.Forms, ...</resheader>
<resheader name="writer">System.Resources.ResXResourceWriter, System.Windows.Forms, ...</resheader>
<data name="Name1"><value>this is my long string</value><comment>this is a comment</comment></data>
<data name="Color1" type="System.Drawing.Color, System.Drawing">Blue</data>
<data name="Bitmap1" mimetype="application/x-microsoft.net.object.binary.base64">
<value>[base64 mime encoded serialized .NET Framework object]</value>
</data>
<data name="Icon1" type="System.Drawing.Icon, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">
<value>[base64 mime encoded string representing a byte array form of the .NET Framework object]</value>
<comment>This is a comment</comment>
</data>
There are any number of "resheader" rows that contain simple
name/value pairs.
Each data row contains a name, and value. The row also contains a
type or mimetype. Type corresponds to a .NET class that support
text/value conversion through the TypeConverter architecture.
Classes that don't support this are serialized and stored with the
mimetype set.
The mimetype is used for serialized objects, and tells the
ResXResourceReader how to depersist the object. This is currently not
extensible. For a given mimetype the value must be set accordingly:
Note - application/x-microsoft.net.object.binary.base64 is the format
that the ResXResourceWriter will generate, however the reader can
read any of the formats listed below.
mimetype: application/x-microsoft.net.object.binary.base64
value : The object must be serialized with
: System.Serialization.Formatters.Binary.BinaryFormatter
: and then encoded with base64 encoding.
mimetype: application/x-microsoft.net.object.soap.base64
value : The object must be serialized with
: System.Runtime.Serialization.Formatters.Soap.SoapFormatter
: and then encoded with base64 encoding.
mimetype: application/x-microsoft.net.object.bytearray.base64
value : The object must be serialized into a byte array
: using a System.ComponentModel.TypeConverter
: and then encoded with base64 encoding.
-->
<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>]]></arrayElement><arrayElement dataType="System.String"><![CDATA[\properties\settings.designer.cs]]></arrayElement><arrayElement dataType="System.String"><![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 = "SC_39ad330d82b24af0b44edf4169b72e16.csproj.Properties.Settings.get_Default():SC_39ad330d82b24af0b44edf4169b72e16.csproj.Properties.Sett" +
"ings")]
namespace SC_39ad330d82b24af0b44edf4169b72e16.csproj.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;
}
}
}
}
]]></arrayElement><arrayElement dataType="System.String"><![CDATA[\properties\settings.settings]]></arrayElement><arrayElement dataType="System.String"><![CDATA[<?xml version='1.0' encoding='iso-8859-1'?>
<SettingsFile xmlns="uri:settings" CurrentProfile="(Default)">
<Profiles>
<Profile Name="(Default)" />
</Profiles>
<Settings />
</SettingsFile>]]></arrayElement><arrayElement dataType="System.String"><![CDATA[\properties\assemblyinfo.cs]]></arrayElement><arrayElement dataType="System.String"><![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("SC_39ad330d82b24af0b44edf4169b72e16.csproj")]
[assembly: AssemblyDescription("")]
[assembly: AssemblyConfiguration("")]
[assembly: AssemblyCompany("Microsoft")]
[assembly: AssemblyProduct("SC_39ad330d82b24af0b44edf4169b72e16.csproj")]
[assembly: AssemblyCopyright("Copyright @ Microsoft 2009")]
[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.*")]
]]></arrayElement><arrayElement dataType="System.String"><![CDATA[\properties\resources.designer.cs]]></arrayElement><arrayElement dataType="System.String"><![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 = "SC_39ad330d82b24af0b44edf4169b72e16.csproj.Properties.Resources.get_ResourceManager():System.Resources.Resou" +
"rceManager")]
[assembly: global::System.Diagnostics.CodeAnalysis.SuppressMessageAttribute("Microsoft.Performance", "CA1811:AvoidUncalledPrivateCode", Scope = "member", Target = "SC_39ad330d82b24af0b44edf4169b72e16.csproj.Properties.Resources.get_Culture():System.Globalization.CultureIn" +
"fo")]
[assembly: global::System.Diagnostics.CodeAnalysis.SuppressMessageAttribute("Microsoft.Performance", "CA1811:AvoidUncalledPrivateCode", Scope = "member", Target = "SC_39ad330d82b24af0b44edf4169b72e16.csproj.Properties.Resources.set_Culture(System.Globalization.CultureInfo" +
"):Void")]
namespace SC_39ad330d82b24af0b44edf4169b72e16.csproj.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("SC_39ad330d82b24af0b44edf4169b72e16.csproj.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;
}
}
}
}
]]></arrayElement><arrayElement dataType="System.String"><![CDATA[\bufferwrapper.cs]]></arrayElement><arrayElement dataType="System.String"><![CDATA[/* THIS IS AUTO-GENERATED CODE THAT WILL BE OVERWRITTEN! DO NOT EDIT!
* Microsoft SQL Server Integration Services buffer wrappers
* This module defines classes for accessing data flow buffers
* THIS IS AUTO-GENERATED CODE THAT WILL BE OVERWRITTEN! DO NOT EDIT! */
using System;
using System.Data;
using Microsoft.SqlServer.Dts.Pipeline;
using Microsoft.SqlServer.Dts.Pipeline.Wrapper;
public class DatesBuffer: ScriptBuffer
{
public DatesBuffer(PipelineBuffer Buffer, int[] BufferColumnIndexes)
: base(Buffer, BufferColumnIndexes)
{
}
public Int32 FiscalYear
{
set
{
this[0] = value;
}
}
public bool FiscalYear_IsNull
{
set
{
if (value)
{
SetNull(0);
}
else
{
throw new InvalidOperationException("IsNull property cannot be set to False. Assign a value to the column instead.");
}
}
}
public Byte FiscalSemester
{
set
{
this[1] = value;
}
}
public bool FiscalSemester_IsNull
{
set
{
if (value)
{
SetNull(1);
}
else
{
throw new InvalidOperationException("IsNull property cannot be set to False. Assign a value to the column instead.");
}
}
}
public Byte FiscalQuarter
{
set
{
this[2] = value;
}
}
public bool FiscalQuarter_IsNull
{
set
{
if (value)
{
SetNull(2);
}
else
{
throw new InvalidOperationException("IsNull property cannot be set to False. Assign a value to the column instead.");
}
}
}
public Byte WeekNumberOfYear
{
set
{
this[3] = value;
}
}
public bool WeekNumberOfYear_IsNull
{
set
{
if (value)
{
SetNull(3);
}
else
{
throw new InvalidOperationException("IsNull property cannot be set to False. Assign a value to the column instead.");
}
}
}
public String SpanishMonthName
{
set
{
this[4] = value;
}
}
public bool SpanishMonthName_IsNull
{
set
{
if (value)
{
SetNull(4);
}
else
{
throw new InvalidOperationException("IsNull property cannot be set to False. Assign a value to the column instead.");
}
}
}
public String SpanishDayNameOfWeek
{
set
{
this[5] = value;
}
}
public bool SpanishDayNameOfWeek_IsNull
{
set
{
if (value)
{
SetNull(5);
}
else
{
throw new InvalidOperationException("IsNull property cannot be set to False. Assign a value to the column instead.");
}
}
}
public String FrenchMonthName
{
set
{
this[6] = value;
}
}
public bool FrenchMonthName_IsNull
{
set
{
if (value)
{
SetNull(6);
}
else
{
throw new InvalidOperationException("IsNull property cannot be set to False. Assign a value to the column instead.");
}
}
}
public String FrenchDayNameOfWeek
{
set
{
this[7] = value;
}
}
public bool FrenchDayNameOfWeek_IsNull
{
set
{
if (value)
{
SetNull(7);
}
else
{
throw new InvalidOperationException("IsNull property cannot be set to False. Assign a value to the column instead.");
}
}
}
public String EnglishMonthName
{
set
{
this[8] = value;
}
}
public bool EnglishMonthName_IsNull
{
set
{
if (value)
{
SetNull(8);
}
else
{
throw new InvalidOperationException("IsNull property cannot be set to False. Assign a value to the column instead.");
}
}
}
public String EnglishDayNameOfWeek
{
set
{
this[9] = value;
}
}
public bool EnglishDayNameOfWeek_IsNull
{
set
{
if (value)
{
SetNull(9);
}
else
{
throw new InvalidOperationException("IsNull property cannot be set to False. Assign a value to the column instead.");
}
}
}
public UInt16 DayNumberOfYear
{
set
{
this[10] = value;
}
}
public bool DayNumberOfYear_IsNull
{
set
{
if (value)
{
SetNull(10);
}
else
{
throw new InvalidOperationException("IsNull property cannot be set to False. Assign a value to the column instead.");
}
}
}
public Byte DayNumberOfWeek
{
set
{
this[11] = value;
}
}
public bool DayNumberOfWeek_IsNull
{
set
{
if (value)
{
SetNull(11);
}
else
{
throw new InvalidOperationException("IsNull property cannot be set to False. Assign a value to the column instead.");
}
}
}
public Byte CalendarSemester
{
set
{
this[12] = value;
}
}
public bool CalendarSemester_IsNull
{
set
{
if (value)
{
SetNull(12);
}
else
{
throw new InvalidOperationException("IsNull property cannot be set to False. Assign a value to the column instead.");
}
}
}
public Byte CalendarQuarter
{
set
{
this[13] = value;
}
}
public bool CalendarQuarter_IsNull
{
set
{
if (value)
{
SetNull(13);
}
else
{
throw new InvalidOperationException("IsNull property cannot be set to False. Assign a value to the column instead.");
}
}
}
public Byte DayNumberOfMonth
{
set
{
this[14] = value;
}
}
public bool DayNumberOfMonth_IsNull
{
set
{
if (value)
{
SetNull(14);
}
else
{
throw new InvalidOperationException("IsNull property cannot be set to False. Assign a value to the column instead.");
}
}
}
public Byte MonthNumberOfYear
{
set
{
this[15] = value;
}
}
public bool MonthNumberOfYear_IsNull
{
set
{
if (value)
{
SetNull(15);
}
else
{
throw new InvalidOperationException("IsNull property cannot be set to False. Assign a value to the column instead.");
}
}
}
public Int32 CalendarYear
{
set
{
this[16] = value;
}
}
public bool CalendarYear_IsNull
{
set
{
if (value)
{
SetNull(16);
}
else
{
throw new InvalidOperationException("IsNull property cannot be set to False. Assign a value to the column instead.");
}
}
}
public DateTime FullAlternateDateKey
{
set
{
this[17] = value;
}
}
public bool FullAlternateDateKey_IsNull
{
set
{
if (value)
{
SetNull(17);
}
else
{
throw new InvalidOperationException("IsNull property cannot be set to False. Assign a value to the column instead.");
}
}
}
public Int32 DateKey
{
set
{
this[18] = value;
}
}
public bool DateKey_IsNull
{
set
{
if (value)
{
SetNull(18);
}
else
{
throw new InvalidOperationException("IsNull property cannot be set to False. Assign a value to the column instead.");
}
}
}
new public void AddRow()
{
base.AddRow();
}
new public void SetEndOfRowset()
{
base.SetEndOfRowset();
}
new public bool EndOfRowset()
{
return base.EndOfRowset();
}
}
]]></arrayElement><arrayElement dataType="System.String"><![CDATA[\sc_39ad330d82b24af0b44edf4169b72e16.csproj]]></arrayElement><arrayElement dataType="System.String"><![CDATA[<Project ToolsVersion="3.5" DefaultTargets="Build" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
<!-- This section defines project-level properties.
Configuration - Specifies whether the default configuration is Release or Debug.
Platform - Specifies what CPU the output of this project can run on.
OutputType - Must be "Library" for VSTA.
NoStandardLibraries - Set to "false" for VSTA.
RootNamespace - In C#, this specifies the namespace given to new files.
In Visual Basic, all objects are wrapped in this namespace at runtime.
AssemblyName - Name of the output assembly.
-->
<PropertyGroup>
<ProjectTypeGuids>{A860303F-1F3F-4691-B57E-529FC101A107};{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}</ProjectTypeGuids>
<Configuration Condition=" '$(Configuration)' == '' ">Debug</Configuration>
<Platform Condition=" '$(Platform)' == '' ">AnyCPU</Platform>
<OutputType>Library</OutputType>
<NoStandardLibraries>false</NoStandardLibraries>
<RootNamespace>SC_39ad330d82b24af0b44edf4169b72e16.csproj</RootNamespace>
<AssemblyName>SC_39ad330d82b24af0b44edf4169b72e16.csproj</AssemblyName>
<ProjectGuid>{BF8CF23F-1B3F-4F29-89D4-E6765E0B7FFC}</ProjectGuid>
</PropertyGroup>
<!-- This section defines properties that are set when the "Debug" configuration is
selected.
DebugSymbols - If true, create symbols (.pdb). If false, do not create symbols.
Optimize - If true, optimize the build output. If false, do not optimize.
OutputPath - Output path of the project relative to the project file.
EnableUnmanagedDebugging - If true, starting the debugger will attach both managed and unmanaged debuggers.
DefineConstants - Constants defined for the preprocessor.
Warning Level - Warning level for the compiler.
-->
<PropertyGroup Condition=" '$(Configuration)' == 'Debug' ">
<DebugSymbols>true</DebugSymbols>
<Optimize>false</Optimize>
<OutputPath>.\bin\Debug\</OutputPath>
<EnableUnmanagedDebugging>false</EnableUnmanagedDebugging>
<DefineConstants>DEBUG;TRACE</DefineConstants>
<WarningLevel>4</WarningLevel>
</PropertyGroup>
<!-- This section defines properties that are set when the "Release" configuration is
selected.
DebugSymbols - If true, create symbols (.pdb). If false, do not create symbols.
Optimize - If true, optimize the build output. If false, do not optimize.
OutputPath - Output path of the project relative to the project file.
EnableUnmanagedDebugging - If true, starting the debugger will attach both managed and unmanaged debuggers.
DefineConstants - Constants defined for the preprocessor.
Warning Level - Warning level for the compiler.
-->
<PropertyGroup Condition=" '$(Configuration)' == 'Release' ">
<DebugSymbols>false</DebugSymbols>
<Optimize>true</Optimize>
<OutputPath>.\bin\Release\</OutputPath>
<EnableUnmanagedDebugging>false</EnableUnmanagedDebugging>
<DefineConstants>TRACE</DefineConstants>
<WarningLevel>4</WarningLevel>
</PropertyGroup>
<!-- This section enables pre- and post-build steps. However,
it is recommended that MSBuild tasks be used instead of these properties.
-->
<PropertyGroup>
<PreBuildEvent>
</PreBuildEvent>
<PostBuildEvent>
</PostBuildEvent>
</PropertyGroup>
<!-- This sections specifies references for the project. -->
<ItemGroup>
<Reference Include="System" />
<Reference Include="System.Data" />
<Reference Include="System.Windows.Forms" />
<Reference Include="System.Xml" />
<Reference Include="Microsoft.SqlServer.TxScript, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />
<Reference Include="Microsoft.SqlServer.DTSRuntimeWrap, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />
<Reference Include="Microsoft.SqlServer.DTSPipelineWrap, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />
<Reference Include="Microsoft.SqlServer.PipelineHost, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />
</ItemGroup>
<!-- This section defines the user source files that are part of the
project.
Compile - Specifies a source file to compile.
EmbeddedResource - Specifies a .resx file for embedded resources.
None - Specifies a file that is not to be passed to the compiler (for instance,
a text file or XML file).
AppDesigner - Specifies the directory where the application properties files can
be found.
-->
<ItemGroup>
<AppDesigner Include="Properties\" />
<Compile Include="BufferWrapper.cs" />
<Compile Include="ComponentWrapper.cs" />
<Compile Include="main.cs" />
<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>
<!-- Include the default configuration information and metadata files for the add-in.
These files are copied to the build output directory when the project is
built, and the path to the configuration file is passed to the add-in on the command
line when debugging.
-->
</ItemGroup>
<!-- Include the build rules for a C# project.-->
<Import Project="$(MSBuildBinPath)\Microsoft.CSharp.targets" />
<!-- This section defines VSTA properties that describe the host-changable project properties. -->
<ProjectExtensions>
<VisualStudio>
<FlavorProperties GUID="{A860303F-1F3F-4691-B57E-529FC101A107}">
<ProjectProperties HostName="VSTAHostName" HostPackage="{C1B21C64-9E6F-4923-A89D-9F958503C1CE}" ApplicationType="usd" Language="cs" TemplatesPath="" />
<Host Name="SSIS_ScriptComponent" IconIndex="0" />
<ProjectClient>
<HostIdentifier>SSIS_ScriptComponent</HostIdentifier>
</ProjectClient>
</FlavorProperties>
</VisualStudio>
</ProjectExtensions>
</Project>]]></arrayElement><arrayElement dataType="System.String"><![CDATA[\componentwrapper.cs]]></arrayElement><arrayElement dataType="System.String"><![CDATA[/* THIS IS AUTO-GENERATED CODE THAT WILL BE OVERWRITTEN! DO NOT EDIT!
* Microsoft SQL Server Integration Services component wrapper
* This module defines the base class for your component
* THIS IS AUTO-GENERATED CODE THAT WILL BE OVERWRITTEN! DO NOT EDIT! */
using System;
using System.Data;
using Microsoft.SqlServer.Dts.Pipeline;
using Microsoft.SqlServer.Dts.Pipeline.Wrapper;
using Microsoft.SqlServer.Dts.Runtime.Wrapper;
public class UserComponent: ScriptComponent
{
public Connections Connections;
public Variables Variables;
public UserComponent()
{
Connections = new Connections(this);
Variables = new Variables(this);
}
public DatesBuffer DatesBuffer;
public virtual void FinishOutputs()
{
}
private void MarkOutputsFinished()
{
if (null != DatesBuffer)
{
DatesBuffer.SetEndOfRowset();
DatesBuffer = null;
}
}
public override void PrimeOutput(int Outputs, int[] OutputIDs, PipelineBuffer[] Buffers)
{
for(int Idx = 0; Idx < Outputs; Idx++)
{
if(OutputIDs[Idx] == 4)
{
DatesBuffer = new DatesBuffer(Buffers[Idx], GetColumnIndexes(OutputIDs[Idx]));
}
}
CreateNewOutputRows();
FinishOutputs();
MarkOutputsFinished();
}
public virtual void CreateNewOutputRows()
{
}
}
public class Connections
{
ScriptComponent ParentComponent;
public Connections(ScriptComponent Component)
{
ParentComponent = Component;
}
}
public class Variables
{
ScriptComponent ParentComponent;
public Variables(ScriptComponent Component)
{
ParentComponent = Component;
}
}
]]></arrayElement></arrayElements></property>
<property id="6" name="BinaryCode" dataType="System.String" state="cdata" isArray="true" description="Stores the binary representation of the component" typeConverter="" UITypeEditor="" containsID="false" expressionType="None"><arrayElements arrayElementCount="2"><arrayElement dataType="System.String"><![CDATA[\bin\release\sc_39ad330d82b24af0b44edf4169b72e16.csproj.dll]]></arrayElement><arrayElement dataType="System.String"><![CDATA[TVqQAAMAAAAEAAAA//8AALgAAAAAAAAAQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAgAAAAA4fug4AtAnNIbgBTM0hVGhpcyBwcm9ncmFtIGNhbm5vdCBiZSBydW4gaW4gRE9TIG1v
ZGUuDQ0KJAAAAAAAAABQRQAATAEDAOVz50kAAAAAAAAAAOAAAiELAQgAACQAAAAIAAAAAAAA3kIA
AAAgAAAAYAAAAABAAAAgAAAAAgAABAAAAAAAAAAEAAAAAAAAAACgAAAAAgAAAAAAAAMAQIUAABAA
ABAAAAAAEAAAEAAAAAAAABAAAAAAAAAAAAAAAJBCAABLAAAAAGAAAJAEAAAAAAAAAAAAAAAAAAAA
AAAAAIAAAAwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAIAAACAAAAAAAAAAAAAAACCAAAEgAAAAAAAAAAAAAAC50ZXh0AAAA5CIAAAAgAAAAJAAAAAIA
AAAAAAAAAAAAAAAAACAAAGAucnNyYwAAAJAEAAAAYAAAAAYAAAAmAAAAAAAAAAAAAAAAAABAAABA
LnJlbG9jAAAMAAAAAIAAAAACAAAALAAAAAAAAAAAAAAAAAAAQAAAQgAAAAAAAAAAAAAAAAAAAADA
QgAAAAAAAEgAAAACAAUAYCcAADAbAAABAAAAAAAAAKgmAAC4AAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAACYCAwQoDAAACio6AhYDjBQAAAEoDQAACipaAywIAhYoDgAA
CipyAQAAcHMPAAAKejoCFwOMFgAAASgNAAAKKloDLAgCFygOAAAKKnIBAABwcw8AAAp6OgIYA4wW
AAABKA0AAAoqWgMsCAIYKA4AAAoqcgEAAHBzDwAACno6AhkDjBYAAAEoDQAACipaAywIAhkoDgAA
CipyAQAAcHMPAAAKeiYCGgMoDQAACipaAywIAhooDgAACipyAQAAcHMPAAAKeiYCGwMoDQAACipa
AywIAhsoDgAACipyAQAAcHMPAAAKeiYCHAMoDQAACipaAywIAhwoDgAACipyAQAAcHMPAAAKeiYC
HQMoDQAACipaAywIAh0oDgAACipyAQAAcHMPAAAKeiYCHgMoDQAACipaAywIAh4oDgAACipyAQAA
cHMPAAAKeioCHwkDKA0AAAoqXgMsCQIfCSgOAAAKKnIBAABwcw8AAAp6PgIfCgOMFwAAASgNAAAK
Kl4DLAkCHwooDgAACipyAQAAcHMPAAAKej4CHwsDjBYAAAEoDQAACipeAywJAh8LKA4AAAoqcgEA
AHBzDwAACno+Ah8MA4wWAAABKA0AAAoqXgMsCQIfDCgOAAAKKnIBAABwcw8AAAp6PgIfDQOMFgAA
ASgNAAAKKl4DLAkCHw0oDgAACipyAQAAcHMPAAAKej4CHw4DjBYAAAEoDQAACipeAywJAh8OKA4A
AAoqcgEAAHBzDwAACno+Ah8PA4wWAAABKA0AAAoqXgMsCQIfDygOAAAKKnIBAABwcw8AAAp6PgIf
EAOMFAAAASgNAAAKKl4DLAkCHxAoDgAACipyAQAAcHMPAAAKej4CHxEDjAYAAAEoDQAACipeAywJ
Ah8RKA4AAAoqcgEAAHBzDwAACno+Ah8SA4wUAAABKA0AAAoqXgMsCQIfEigOAAAKKnIBAABwcw8A
AAp6HgIoEAAACioeAigRAAAKKh4CKBIAAAoqfgIoEwAACgICczcAAAZ9AQAABAICczgAAAZ9AgAA
BCoGKm4CewMAAAQsEgJ7AwAABG8pAAAGAhR9AwAABCoTMAUAPAAAAAEAABEWCishBAaUGjMXAgUG
mgIEBpQoFAAACnMBAAAGfQMAAAQGF1gKBgMy2wJvLwAABgJvLAAABgIoLQAABioGKgAAEzAFABAC
AAACAAARAnsDAAAECigWAAAKEwkSCSgXAAAKCxICBx8KWRcXKBgAAAoSAwcbWBcXKBgAAApzGQAA
ChMEOMgBAAAGbygAAAYGEgIoFwAACiAQJwAAWhICKBoAAAofZFpYEgIoGwAAClhvJgAABgYIbyQA
AAYGEgIoFwAACm8iAAAGBhICKBoAAArSbyAAAAYGEgIoGwAACtJvHgAABhcTBRICKBoAAAoZMQMY
EwUSAigaAAAKHDEDGRMFEgIoGgAACh8JMQMaEwUSAigaAAAKHTIDGCsBFxMGBhEF0m8cAAAGBhEG
0m8aAAAGBhICKBwAAArSbxgAAAYGEgIoHQAACtFvFgAABgYSAnKeAABwfgQAAAQoHgAACm8UAAAG
BhICcqgAAHB+BAAABCgeAAAKbxIAAAYGEgJyngAAcH4FAAAEKB4AAApvEAAABgYSAnKoAABwfgUA
AAQoHgAACm8OAAAGBhICcp4AAHB+BgAABCgeAAAKbwwAAAYGEgJyqAAAcH4GAAAEKB4AAApvCgAA
BgYRBAgWFm8fAAAK0m8IAAAGEQUYWBMHEQcaMQYRBxpZEwcRBhdYEwgRCBgxBhEIGFkTCAYRB9Jv
BgAABgYRCNJvBAAABgYSAigaAAAKHTILEgIoFwAAChdYKwcSAigXAAAKaG8CAAAGEgIjAAAAAAAA
8D8oIAAACgwICSghAAAKOiz+//8qunKyAABwKCIAAAqABAAABHK+AABwKCIAAAqABQAABHLKAABw
KCIAAAqABgAABCoeAigrAAAGKh4CKCQAAAoqABMwAwAtAAAAAwAAEX4HAAAELSBy1gAAcNAFAAAC
KCUAAApvJgAACnMnAAAKCgaABwAABH4HAAAEKhp+CAAABCoeAoAIAAAEKjoCKCQAAAoCA30JAAAE
KjoCKCQAAAoCA30KAAAEKhp+CwAABCouczoAAAaACwAABCoeAigqAAAKKgAAAAAAAAC0AAAAzsrv
vgEAAACRAAAAbFN5c3RlbS5SZXNvdXJjZXMuUmVzb3VyY2VSZWFkZXIsIG1zY29ybGliLCBWZXJz
aW9uPTIuMC4wLjAsIEN1bHR1cmU9bmV1dHJhbCwgUHVibGljS2V5VG9rZW49Yjc3YTVjNTYxOTM0
ZTA4OSNTeXN0ZW0uUmVzb3VyY2VzLlJ1bnRpbWVSZXNvdXJjZVNldAIAAAAAAAAAAAAAAFBBRFBB
RFC0AAAAQlNKQgEAAQAAAAAADAAAAHYyLjAuNTA3MjcAAAAABQBsAAAAAAoAACN+AABsCgAAlA0A
ACNTdHJpbmdzAAAAAAAYAABYAQAAI1VTAFgZAAAQAAAAI0dVSUQAAABoGQAAyAEAACNCbG9iAAAA
AAAAAAIAAAFXFaIBCQEAAAD6ATMAFgAAAQAAACQAAAAIAAAACwAAADsAAAAuAAAAKgAAAA4AAAAD
AAAAAwAAACkAAAAqAAAAAQAAAAQAAAABAAAAAAAKAAEAAAAAAAYA+wDaAAYACAHaAAoAKAEhAQ4A
RAEvARIAfQHaAAoAxQQhAQoAkgh9CAoA2wjKCAoAxgm0CQoA3Qm0CQoA+gm0CQoAGQq0CQoAMgq0
CQoASwq0CQoAZgq0CQoAgQq0CQoAmgq0CQoA0wqzCgoA8wqzCgoAPAshAQoAUwshAQoAbQshAQoA
cgshAQYAigvaAAoAxAt9CAoA6AshAQoADgwhAQoAJwx9CAoAMAx9CAoAjAx5DAoAqQwhAQoArgwh
AQoA0gy0CQ4A/gzoDA4AFw3oDAoALA2zCgAAAAABAAAAAAABAAEAAQAQADkAAAAFAAEAAQABABAA
RQAAAAkAAQArAAEAEABTAAAADAAEADAAAAAQAF4AaAANAAcAMwABABAAngAAAA0ACQA3AAEAEACq
AAAADQAKADgAAAEQALQAaAARAAsAOQAGAJ4AWwAGAKoAXwAGADkAYwARAJ4IcQARAK0IcQARALsI
cQARAOsIdQARAPcIcQABADsJkwABADsJkwARAEsJnQBQIAAAAACGGIwBEwABAFogAAAAAIYIkgEb
AAMAaSAAAAAAhgihASAABACAIAAAAACGCLcBJQAFAI8gAAAAAIYIygEgAAYApiAAAAAAhgjkASUA
BwC1IAAAAACGCPYBIAAIAMwgAAAAAIYIDwIlAAkA2yAAAAAAhggkAiAACgDyIAAAAACGCEACKgAL
APwgAAAAAIYIVQIgAAwAEyEAAAAAhghxAioADQAdIQAAAACGCIoCIAAOADQhAAAAAIYIqgIqAA8A
PiEAAAAAhgi+AiAAEABVIQAAAACGCNkCKgARAF8hAAAAAIYI8QIgABIAdiEAAAAAhggQAyoAEwCA
IQAAAACGCCUDIAAUAJchAAAAAIYIQQMqABUAoiEAAAAAhghaAyAAFgC6IQAAAACGCHoDLwAXAMoh
AAAAAIYIjgMgABgA4iEAAAAAhgipAyUAGQDyIQAAAACGCL0DIAAaAAoiAAAAAIYI2AMlABsAGiIA
AAAAhgjtAyAAHAAyIgAAAACGCAkEJQAdAEIiAAAAAIYIHQQgAB4AWiIAAAAAhgg4BCUAHwBqIgAA
AACGCE0EIAAgAIIiAAAAAIYIaQQlACEAkiIAAAAAhgh/BCAAIgCqIgAAAACGCJwEGwAjALoiAAAA
AIYIrQQgACQA0iIAAAAAhgjOBDQAJQDiIgAAAACGCOcEIAAmAPoiAAAAAIYIBwUbACcACiMAAAAA
hggTBSAAKAAiIwAAAACGACYFOgApACojAAAAAIYALQU6ACkAMiMAAAAAhgA8BT4AKQA6IwAAAACG
GIwBOgApAFojAAAAAMYBOwg6ACkAXCMAAAAAgQBJCDoAKQB4IwAAAADGAF0IZwApAMAjAAAAAMYB
aQg6ACwAxCMAAAAAxgBpCDoALAAPJgAAAACGGIwBOgAsAOAlAAAAAJEYYwwGASwAFyYAAAAAgxiM
AToALAAgJgAAAACTCAcJeQAsAFkmAAAAAJMIGwl+ACwAYCYAAAAAkwgnCYMALABoJgAAAACGGIwB
lwAtAHcmAAAAAIYYjAGXAC4AhiYAAAAAlghbCaEALwCZJgAAAACGGIwBOgAvAI0mAAAAAJEYYwwG
AS8AAAABAG8JAAACAHYJAAABAIoJAAABAIoJAAABAIoJAAABAIoJAAABAIoJAAABAIoJAAABAIoJ
AAABAIoJAAABAIoJAAABAIoJAAABAIoJAAABAIoJAAABAIoJAAABAIoJAAABAIoJAAABAIoJAAAB
AIoJAAABAIoJAAABAIoJAAABAIoJAAABAIoJAAABAIoJAAABAIoJAAABAIoJAAABAIoJAAABAIoJ
AAABAIoJAAABAIoJAAABAIoJAAABAIoJAAABAIoJAAABAIoJAAABAIoJAAABAIoJAAABAIoJAAAB
AIoJAAABAIoJAAABAIoJAAABAJAJAAACAJgJAAADAKIJAAABAIoJAAABAKoJAAABAKoJSQCMASoA
UQCMASoAWQCMASoAYQCMASoAaQCMASoAcQCMASoAeQCMASoAgQCMASoAiQCMASoAkQCMARsAmQCM
AToACQCMARMACQBCC6sACQBLCxsAqQCMASoACQAmBToACQAtBToACQA8BT4AEQCMAToAEQB5C7EA
wQCMAToAMQCxC8AAMQC7C8UAMQCMAckAyQCMAToAMQDWC8UAMQDgC8UAMQDyC9AAMQAADMUAMQAe
DNUA4QBBDNwAMQBPDOYAMQBXDOwAOQBqDAoB8QCMAToAGQCMAToA+QDADBAB+QDbDBgBQQCMAR4B
EQGMASsBIQGMAToAIQCMAToALgATAGsBLgAbAGsBLgBbAKkBLgALADsBLgArADsBLgAjAHEBLgAz
AIABLgA7AGsBLgBTAKABgwCrALsAowAbAbsAYQFLAbsA6QRDATIBCQVDATIBtwD0ACYBAgABAAUA
JwAIACkAAABIBUIAAABTBUYAAABlBUoAAAB0BUYAAACKBUoAAACYBUYAAACtBUoAAAC+BUYAAADW
BU4AAADnBUYAAAD/BU4AAAAUBkYAAAAwBk4AAABABkYAAABXBk4AAABrBkYAAACGBk4AAACXBkYA
AACvBk4AAADEBkYAAADgBlIAAADwBkYAAAAHB0oAAAAXB0YAAAAuB0oAAAA/B0YAAABXB0oAAABn
B0YAAAB+B0oAAACPB0YAAACnB0oAAAC5B0YAAADSB0IAAADfB0YAAADzB1YAAAAICEYAAAAkCEIA
AAAsCEYAAADbCIkAAAAzCY4AAABnCaYAAQACAAMAAQADAAUAAQAEAAcAAQAFAAkAAQAGAAsAAQAH
AA0AAQAIAA8AAQAJABEAAQAKABMAAQALABUAAQAMABcAAQANABkAAQAOABsAAQAPAB0AAQAQAB8A
AQARACEAAQASACMAAQATACUAAQAUACcAAQAVACkAAQAWACsAAQAXAC0AAQAYAC8AAQAZADEAAQAa
ADMAAQAbADUAAQAcADcAAQAdADkAAQAeADsAAQAfAD0AAQAgAD8AAQAhAEEAAQAiAEMAAQAjAEUA
AQAkAEcAAQAlAEkAAQAmAEsAAQAnAE0AAgA0AE8AAgA1AFEAAQA2AFEAAgA5AFMABIAAAAEAAABB
DXJ/AAAAAAAAEQsAAAoAAAAAAAAAAAAAAAEAvQAAAAAAAgAAAAAAAAAAAAAACgAYAQAAAAACAAAA
AAAAAAAAAAAKACEBAAAAAAoAAAAAAAAAAAAAAAEAXAEAAAAAAAAAAAEAAABHDQAAAAAAAAA8TW9k
dWxlPgBTQ18zOWFkMzMwZDgyYjI0YWYwYjQ0ZWRmNDE2OWI3MmUxNi5jc3Byb2ouZGxsAERhdGVz
QnVmZmVyAFVzZXJDb21wb25lbnQAU2NyaXB0TWFpbgBSZXNvdXJjZXMAU0NfMzlhZDMzMGQ4MmIy
NGFmMGI0NGVkZjQxNjliNzJlMTYuY3Nwcm9qLlByb3BlcnRpZXMAQ29ubmVjdGlvbnMAVmFyaWFi
bGVzAFNldHRpbmdzAE1pY3Jvc29mdC5TcWxTZXJ2ZXIuVHhTY3JpcHQATWljcm9zb2Z0LlNxbFNl
cnZlci5EdHMuUGlwZWxpbmUAU2NyaXB0QnVmZmVyAFNjcmlwdENvbXBvbmVudABtc2NvcmxpYgBT
eXN0ZW0AT2JqZWN0AFN5c3RlbS5Db25maWd1cmF0aW9uAEFwcGxpY2F0aW9uU2V0dGluZ3NCYXNl
AE1pY3Jvc29mdC5TcWxTZXJ2ZXIuUGlwZWxpbmVIb3N0AFBpcGVsaW5lQnVmZmVyAC5jdG9yAHNl
dF9GaXNjYWxZZWFyAHNldF9GaXNjYWxZZWFyX0lzTnVsbABzZXRfRmlzY2FsU2VtZXN0ZXIAc2V0
X0Zpc2NhbFNlbWVzdGVyX0lzTnVsbABzZXRfRmlzY2FsUXVhcnRlcgBzZXRfRmlzY2FsUXVhcnRl
cl9Jc051bGwAc2V0X1dlZWtOdW1iZXJPZlllYXIAc2V0X1dlZWtOdW1iZXJPZlllYXJfSXNOdWxs
AHNldF9TcGFuaXNoTW9udGhOYW1lAHNldF9TcGFuaXNoTW9udGhOYW1lX0lzTnVsbABzZXRfU3Bh
bmlzaERheU5hbWVPZldlZWsAc2V0X1NwYW5pc2hEYXlOYW1lT2ZXZWVrX0lzTnVsbABzZXRfRnJl
bmNoTW9udGhOYW1lAHNldF9GcmVuY2hNb250aE5hbWVfSXNOdWxsAHNldF9GcmVuY2hEYXlOYW1l
T2ZXZWVrAHNldF9GcmVuY2hEYXlOYW1lT2ZXZWVrX0lzTnVsbABzZXRfRW5nbGlzaE1vbnRoTmFt
ZQBzZXRfRW5nbGlzaE1vbnRoTmFtZV9Jc051bGwAc2V0X0VuZ2xpc2hEYXlOYW1lT2ZXZWVrAHNl
dF9FbmdsaXNoRGF5TmFtZU9mV2Vla19Jc051bGwAc2V0X0RheU51bWJlck9mWWVhcgBzZXRfRGF5
TnVtYmVyT2ZZZWFyX0lzTnVsbABzZXRfRGF5TnVtYmVyT2ZXZWVrAHNldF9EYXlOdW1iZXJPZldl
ZWtfSXNOdWxsAHNldF9DYWxlbmRhclNlbWVzdGVyAHNldF9DYWxlbmRhclNlbWVzdGVyX0lzTnVs
bABzZXRfQ2FsZW5kYXJRdWFydGVyAHNldF9DYWxlbmRhclF1YXJ0ZXJfSXNOdWxsAHNldF9EYXlO
dW1iZXJPZk1vbnRoAHNldF9EYXlOdW1iZXJPZk1vbnRoX0lzTnVsbABzZXRfTW9udGhOdW1iZXJP
ZlllYXIAc2V0X01vbnRoTnVtYmVyT2ZZZWFyX0lzTnVsbABzZXRfQ2FsZW5kYXJZZWFyAHNldF9D
YWxlbmRhclllYXJfSXNOdWxsAERhdGVUaW1lAHNldF9GdWxsQWx0ZXJuYXRlRGF0ZUtleQBzZXRf
RnVsbEFsdGVybmF0ZURhdGVLZXlfSXNOdWxsAHNldF9EYXRlS2V5AHNldF9EYXRlS2V5X0lzTnVs
bABBZGRSb3cAU2V0RW5kT2ZSb3dzZXQARW5kT2ZSb3dzZXQARmlzY2FsWWVhcgBGaXNjYWxZZWFy
X0lzTnVsbABGaXNjYWxTZW1lc3RlcgBGaXNjYWxTZW1lc3Rlcl9Jc051bGwARmlzY2FsUXVhcnRl
cgBGaXNjYWxRdWFydGVyX0lzTnVsbABXZWVrTnVtYmVyT2ZZZWFyAFdlZWtOdW1iZXJPZlllYXJf
SXNOdWxsAFNwYW5pc2hNb250aE5hbWUAU3BhbmlzaE1vbnRoTmFtZV9Jc051bGwAU3BhbmlzaERh
eU5hbWVPZldlZWsAU3BhbmlzaERheU5hbWVPZldlZWtfSXNOdWxsAEZyZW5jaE1vbnRoTmFtZQBG
cmVuY2hNb250aE5hbWVfSXNOdWxsAEZyZW5jaERheU5hbWVPZldlZWsARnJlbmNoRGF5TmFtZU9m
V2Vla19Jc051bGwARW5nbGlzaE1vbnRoTmFtZQBFbmdsaXNoTW9udGhOYW1lX0lzTnVsbABFbmds
aXNoRGF5TmFtZU9mV2VlawBFbmdsaXNoRGF5TmFtZU9mV2Vla19Jc051bGwARGF5TnVtYmVyT2ZZ
ZWFyAERheU51bWJlck9mWWVhcl9Jc051bGwARGF5TnVtYmVyT2ZXZWVrAERheU51bWJlck9mV2Vl
a19Jc051bGwAQ2FsZW5kYXJTZW1lc3RlcgBDYWxlbmRhclNlbWVzdGVyX0lzTnVsbABDYWxlbmRh
clF1YXJ0ZXIAQ2FsZW5kYXJRdWFydGVyX0lzTnVsbABEYXlOdW1iZXJPZk1vbnRoAERheU51bWJl
ck9mTW9udGhfSXNOdWxsAE1vbnRoTnVtYmVyT2ZZZWFyAE1vbnRoTnVtYmVyT2ZZZWFyX0lzTnVs
bABDYWxlbmRhclllYXIAQ2FsZW5kYXJZZWFyX0lzTnVsbABGdWxsQWx0ZXJuYXRlRGF0ZUtleQBG
dWxsQWx0ZXJuYXRlRGF0ZUtleV9Jc051bGwARGF0ZUtleQBEYXRlS2V5X0lzTnVsbABGaW5pc2hP
dXRwdXRzAE1hcmtPdXRwdXRzRmluaXNoZWQAUHJpbWVPdXRwdXQAQ3JlYXRlTmV3T3V0cHV0Um93
cwBTeXN0ZW0uR2xvYmFsaXphdGlvbgBDdWx0dXJlSW5mbwBFbmdsaXNoQ3VsdHVyZQBGcmVuY2hD
dWx0dXJlAFNwYW5pc2hDdWx0dXJlAFN5c3RlbS5SZXNvdXJjZXMAUmVzb3VyY2VNYW5hZ2VyAHJl
c291cmNlTWFuAHJlc291cmNlQ3VsdHVyZQBnZXRfUmVzb3VyY2VNYW5hZ2VyAGdldF9DdWx0dXJl
AHNldF9DdWx0dXJlAEN1bHR1cmUAUGFyZW50Q29tcG9uZW50AGRlZmF1bHRJbnN0YW5jZQBnZXRf
RGVmYXVsdABEZWZhdWx0AEJ1ZmZlcgBCdWZmZXJDb2x1bW5JbmRleGVzAHZhbHVlAE91dHB1dHMA
T3V0cHV0SURzAEJ1ZmZlcnMAQ29tcG9uZW50AFN5c3RlbS5SZWZsZWN0aW9uAEFzc2VtYmx5VGl0
bGVBdHRyaWJ1dGUAQXNzZW1ibHlEZXNjcmlwdGlvbkF0dHJpYnV0ZQBBc3NlbWJseUNvbmZpZ3Vy
YXRpb25BdHRyaWJ1dGUAQXNzZW1ibHlDb21wYW55QXR0cmlidXRlAEFzc2VtYmx5UHJvZHVjdEF0
dHJpYnV0ZQBBc3NlbWJseUNvcHlyaWdodEF0dHJpYnV0ZQBBc3NlbWJseVRyYWRlbWFya0F0dHJp
YnV0ZQBBc3NlbWJseUN1bHR1cmVBdHRyaWJ1dGUAQXNzZW1ibHlWZXJzaW9uQXR0cmlidXRlAFN5
c3RlbS5SdW50aW1lLkNvbXBpbGVyU2VydmljZXMAQ29tcGlsYXRpb25SZWxheGF0aW9uc0F0dHJp
YnV0ZQBSdW50aW1lQ29tcGF0aWJpbGl0eUF0dHJpYnV0ZQBTQ18zOWFkMzMwZDgyYjI0YWYwYjQ0
ZWRmNDE2OWI3MmUxNi5jc3Byb2oASW50MzIAc2V0X0l0ZW0AU2V0TnVsbABJbnZhbGlkT3BlcmF0
aW9uRXhjZXB0aW9uAEJ5dGUAVUludDE2AEdldENvbHVtbkluZGV4ZXMAU1NJU1NjcmlwdENvbXBv
bmVudEVudHJ5UG9pbnRBdHRyaWJ1dGUAZ2V0X1RvZGF5AGdldF9ZZWFyAEdyZWdvcmlhbkNhbGVu
ZGFyAGdldF9Nb250aABnZXRfRGF5AERheU9mV2VlawBnZXRfRGF5T2ZXZWVrAGdldF9EYXlPZlll
YXIASUZvcm1hdFByb3ZpZGVyAFRvU3RyaW5nAENhbGVuZGFyAENhbGVuZGFyV2Vla1J1bGUAR2V0
V2Vla09mWWVhcgBBZGREYXlzAG9wX0xlc3NUaGFuAC5jY3RvcgBHZXRDdWx0dXJlSW5mbwBTeXN0
ZW0uRGlhZ25vc3RpY3MARGVidWdnZXJOb25Vc2VyQ29kZUF0dHJpYnV0ZQBUeXBlAFJ1bnRpbWVU
eXBlSGFuZGxlAEdldFR5cGVGcm9tSGFuZGxlAEFzc2VtYmx5AGdldF9Bc3NlbWJseQBTeXN0ZW0u
Q29tcG9uZW50TW9kZWwARWRpdG9yQnJvd3NhYmxlQXR0cmlidXRlAEVkaXRvckJyb3dzYWJsZVN0
YXRlAENvbXBpbGVyR2VuZXJhdGVkQXR0cmlidXRlAFNDXzM5YWQzMzBkODJiMjRhZjBiNDRlZGY0
MTY5YjcyZTE2LmNzcHJvai5Qcm9wZXJ0aWVzLlJlc291cmNlcy5yZXNvdXJjZXMAAAAAAICbSQBz
AE4AdQBsAGwAIABwAHIAbwBwAGUAcgB0AHkAIABjAGEAbgBuAG8AdAAgAGIAZQAgAHMAZQB0ACAA
dABvACAARgBhAGwAcwBlAC4AIABBAHMAcwBpAGcAbgAgAGEAIAB2AGEAbAB1AGUAIAB0AG8AIAB0
AGgAZQAgAGMAbwBsAHUAbQBuACAAaQBuAHMAdABlAGEAZAAuAAAJZABkAGQAZAAACU0ATQBNAE0A
AAtlAG4ALQBVAFMAAQtmAHIALQBGAFIAAQtlAHMALQBFAFMAAX9TAEMAXwAzADkAYQBkADMAMwAw
AGQAOAAyAGIAMgA0AGEAZgAwAGIANAA0AGUAZABmADQAMQA2ADkAYgA3ADIAZQAxADYALgBjAHMA
cAByAG8AagAuAFAAcgBvAHAAZQByAHQAaQBlAHMALgBSAGUAcwBvAHUAcgBjAGUAcwAAAAAKQRy9
zXlXTbB27LgwmaUFAAiJhF3NgIDMkQi3elxWGTTgiQcgAgESFR0IBCABAQgEIAEBAgQgAQEFBCAB
AQ4EIAEBBwUgAQERGQMgAAEDIAACAygACAMoAAIDKAAFAygADgMoAAcEKAARGQMGEhgDBhIcAwYS
CAkgAwEIHQgdEhUDBhIdAwYSIQQAABIhBAAAEh0FAAEBEh0ECAASIQQIABIdAwYSCQUgAQESCQMG
EiAEAAASIAQIABIgBSACAQgcBSABHQgIAwcBCAQBAAAABAAAERkDIAAIBiADAQgICAQgABFpBiAC
Dg4SbQkgAwgRGRF1EWkFIAERGQ0HAAICERkRGREHChIICBEZERkSZQgICAgRGQMAAAEFAAESHQ4H
AAESfRGAgQUgABKAhQcgAgEOEoCFBAcBEiEGIAEBEYCNCAEAAgAAAAAALwEAKlNDXzM5YWQzMzBk
ODJiMjRhZjBiNDRlZGY0MTY5YjcyZTE2LmNzcHJvagAABQEAAAAADgEACU1pY3Jvc29mdAAAHwEA
GkNvcHlyaWdodCBAIE1pY3Jvc29mdCAyMDA5AAAIAQAIAAAAAAAeAQABAFQCFldyYXBOb25FeGNl
cHRpb25UaHJvd3MBuEIAAAAAAAAAAAAAzkIAAAAgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAMBCAAAA
AAAAAABfQ29yRGxsTWFpbgBtc2NvcmVlLmRsbAAAAAAA/yUAIEAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEAEAAA
ABgAAIAAAAAAAAAAAAAAAAAAAAEAAQAAADAAAIAAAAAAAAAAAAAAAAAAAAEAAAAAAEgAAABYYAAA
OAQAAAAAAAAAAAAAOAQ0AAAAVgBTAF8AVgBFAFIAUwBJAE8ATgBfAEkATgBGAE8AAAAAAL0E7/4A
AAEAAAABAHJ/QQ0AAAEAcn9BDT8AAAAAAAAABAAAAAIAAAAAAAAAAAAAAAAAAABEAAAAAQBWAGEA
cgBGAGkAbABlAEkAbgBmAG8AAAAAACQABAAAAFQAcgBhAG4AcwBsAGEAdABpAG8AbgAAAAAAAACw
BJgDAAABAFMAdAByAGkAbgBnAEYAaQBsAGUASQBuAGYAbwAAAHQDAAABADAAMAAwADAAMAA0AGIA
MAAAADQACgABAEMAbwBtAHAAYQBuAHkATgBhAG0AZQAAAAAATQBpAGMAcgBvAHMAbwBmAHQAAACA
ACsAAQBGAGkAbABlAEQAZQBzAGMAcgBpAHAAdABpAG8AbgAAAAAAUwBDAF8AMwA5AGEAZAAzADMA
MABkADgAMgBiADIANABhAGYAMABiADQANABlAGQAZgA0ADEANgA5AGIANwAyAGUAMQA2AC4AYwBz
AHAAcgBvAGoAAAAAAEAADwABAEYAaQBsAGUAVgBlAHIAcwBpAG8AbgAAAAAAMQAuADAALgAzADMA
OQAzAC4AMwAyADYAMgA2AAAAAACAAC8AAQBJAG4AdABlAHIAbgBhAGwATgBhAG0AZQAAAFMAQwBf
ADMAOQBhAGQAMwAzADAAZAA4ADIAYgAyADQAYQBmADAAYgA0ADQAZQBkAGYANAAxADYAOQBiADcA
MgBlADEANgAuAGMAcwBwAHIAbwBqAC4AZABsAGwAAAAAAFwAGwABAEwAZQBnAGEAbABDAG8AcAB5
AHIAaQBnAGgAdAAAAEMAbwBwAHkAcgBpAGcAaAB0ACAAQAAgAE0AaQBjAHIAbwBzAG8AZgB0ACAA
MgAwADAAOQAAAAAAiAAvAAEATwByAGkAZwBpAG4AYQBsAEYAaQBsAGUAbgBhAG0AZQAAAFMAQwBf
ADMAOQBhAGQAMwAzADAAZAA4ADIAYgAyADQAYQBmADAAYgA0ADQAZQBkAGYANAAxADYAOQBiADcA
MgBlADEANgAuAGMAcwBwAHIAbwBqAC4AZABsAGwAAAAAAHgAKwABAFAAcgBvAGQAdQBjAHQATgBh
AG0AZQAAAAAAUwBDAF8AMwA5AGEAZAAzADMAMABkADgAMgBiADIANABhAGYAMABiADQANABlAGQA
ZgA0ADEANgA5AGIANwAyAGUAMQA2AC4AYwBzAHAAcgBvAGoAAAAAAEQADwABAFAAcgBvAGQAdQBj
AHQAVgBlAHIAcwBpAG8AbgAAADEALgAwAC4AMwAzADkAMwAuADMAMgA2ADIANgAAAAAASAAPAAEA
QQBzAHMAZQBtAGIAbAB5ACAAVgBlAHIAcwBpAG8AbgAAADEALgAwAC4AMwAzADkAMwAuADMAMgA2
ADIANgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQAAADAAAAOAyAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA==]]></arrayElement></arrayElements></property>
<property id="7" name="VSTAProjectName" dataType="System.String" state="default" isArray="false" description="Specifies the name of the Microsoft Visual Studio Tools for Applications project. Project names must be unique within a package." typeConverter="NOTBROWSABLE" UITypeEditor="" containsID="false" expressionType="None">SC_39ad330d82b24af0b44edf4169b72e16</property>
<property id="8" name="ScriptLanguage" dataType="System.String" state="default" isArray="false" description="Specifies the programming language used by the script." typeConverter="Microsoft.SqlServer.VSTAHosting.ScriptingLanguages, Microsoft.SqlServer.VSTAScriptingLib, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" UITypeEditor="" containsID="false" expressionType="None">CSharp</property>
<property id="9" name="ReadOnlyVariables" dataType="System.String" state="default" isArray="false" description="Specifies a comma-separated list of read-only variables." typeConverter="" UITypeEditor="Microsoft.SqlServer.Dts.Pipeline.ScriptUIVariablePickerDlg, Microsoft.SqlServer.TxScript, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" containsID="false" expressionType="None"></property>
<property id="10" name="ReadWriteVariables" dataType="System.String" state="default" isArray="false" description="Specifies a comma-separated list of read/write variables." typeConverter="" UITypeEditor="Microsoft.SqlServer.Dts.Pipeline.ScriptUIVariablePickerDlg, Microsoft.SqlServer.TxScript, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" containsID="false" expressionType="None"></property>
<property id="11" name="BreakpointCollection" dataType="System.String" state="default" isArray="true" description="List of breakpoints present on the script." typeConverter="NOTBROWSABLE" UITypeEditor="" containsID="false" expressionType="None"><arrayElements arrayElementCount="0"/></property>
<property id="12" name="UserComponentTypeName" dataType="System.String" state="default" isArray="false" description="" typeConverter="" UITypeEditor="" containsID="false" expressionType="None">Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost, Microsoft.SqlServer.TxScript, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91</property></properties>
<outputs>
<output id="4" name="Dates" description="" exclusionGroup="0" synchronousInputId="0" deleteOutputOnPathDetached="false" hasSideEffects="true" dangling="false" isErrorOut="false" isSorted="false" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed"><outputColumns>
<outputColumn id="31" name="FiscalYear" description="" lineageId="31" precision="0" scale="0" length="0" dataType="i4" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0" mappedColumnId="0"/>
<outputColumn id="30" name="FiscalSemester" description="" lineageId="30" precision="0" scale="0" length="0" dataType="ui1" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0" mappedColumnId="0"/>
<outputColumn id="29" name="FiscalQuarter" description="" lineageId="29" precision="0" scale="0" length="0" dataType="ui1" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0" mappedColumnId="0"/>
<outputColumn id="28" name="WeekNumberOfYear" description="" lineageId="28" precision="0" scale="0" length="0" dataType="ui1" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0" mappedColumnId="0"/>
<outputColumn id="27" name="SpanishMonthName" description="" lineageId="27" precision="0" scale="0" length="50" dataType="wstr" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0" mappedColumnId="0"/>
<outputColumn id="26" name="SpanishDayNameOfWeek" description="" lineageId="26" precision="0" scale="0" length="50" dataType="wstr" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0" mappedColumnId="0"/>
<outputColumn id="25" name="FrenchMonthName" description="" lineageId="25" precision="0" scale="0" length="50" dataType="wstr" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0" mappedColumnId="0"/>
<outputColumn id="24" name="FrenchDayNameOfWeek" description="" lineageId="24" precision="0" scale="0" length="50" dataType="wstr" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0" mappedColumnId="0"/>
<outputColumn id="23" name="EnglishMonthName" description="" lineageId="23" precision="0" scale="0" length="50" dataType="wstr" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0" mappedColumnId="0"/>
<outputColumn id="22" name="EnglishDayNameOfWeek" description="" lineageId="22" precision="0" scale="0" length="50" dataType="wstr" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0" mappedColumnId="0"/>
<outputColumn id="21" name="DayNumberOfYear" description="" lineageId="21" precision="0" scale="0" length="0" dataType="ui2" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0" mappedColumnId="0"/>
<outputColumn id="20" name="DayNumberOfWeek" description="" lineageId="20" precision="0" scale="0" length="0" dataType="ui1" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0" mappedColumnId="0"/>
<outputColumn id="19" name="CalendarSemester" description="" lineageId="19" precision="0" scale="0" length="0" dataType="ui1" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0" mappedColumnId="0"/>
<outputColumn id="18" name="CalendarQuarter" description="" lineageId="18" precision="0" scale="0" length="0" dataType="ui1" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0" mappedColumnId="0"/>
<outputColumn id="17" name="DayNumberOfMonth" description="" lineageId="17" precision="0" scale="0" length="0" dataType="ui1" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0" mappedColumnId="0"/>
<outputColumn id="16" name="MonthNumberOfYear" description="" lineageId="16" precision="0" scale="0" length="0" dataType="ui1" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0" mappedColumnId="0"/>
<outputColumn id="15" name="CalendarYear" description="" lineageId="15" precision="0" scale="0" length="0" dataType="i4" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0" mappedColumnId="0"/>
<outputColumn id="14" name="FullAlternateDateKey" description="" lineageId="14" precision="0" scale="0" length="0" dataType="dbDate" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0" mappedColumnId="0"/>
<outputColumn id="13" name="DateKey" description="" lineageId="13" precision="0" scale="0" length="0" dataType="i4" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0" mappedColumnId="0"/></outputColumns><externalMetadataColumns isUsed="False"/></output>
</outputs>
</component>
<component id="35" name="Null Destination" componentClassID="{2E42D45B-F83C-400F-8D77-61DDE6A7DF29}" description="Executes a custom script." localeId="-1" usesDispositions="false" validateExternalMetadata="True" version="4" pipelineVersion="0" contactInfo="Executes a custom script.;Microsoft Corporation; Microsoft SqlServer v10; © 2007 Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;4">
<properties>
<property id="39" name="SourceCode" dataType="System.String" state="cdata" isArray="true" description="Stores the source code of the component" typeConverter="" UITypeEditor="" containsID="false" expressionType="None"><arrayElements arrayElementCount="18"><arrayElement dataType="System.String"><![CDATA[\main.cs]]></arrayElement><arrayElement dataType="System.String"><![CDATA[/* Microsoft SQL Server Integration Services Script Component
* Write scripts using Microsoft Visual C# 2008.
* ScriptMain is the entry point class of the script.*/
using System;
using System.Data;
using Microsoft.SqlServer.Dts.Pipeline.Wrapper;
using Microsoft.SqlServer.Dts.Runtime.Wrapper;
[Microsoft.SqlServer.Dts.Pipeline.SSISScriptComponentEntryPointAttribute]
public class ScriptMain : UserComponent
{
public override void PreExecute()
{
base.PreExecute();
/*
Add your code here for preprocessing or remove if not needed
*/
}
public override void PostExecute()
{
base.PostExecute();
/*
Add your code here for postprocessing or remove if not needed
You can set read/write variables here, for example:
Variables.MyIntVar = 100
*/
}
public override void Input0_ProcessInputRow(Input0Buffer Row)
{
/*
Add your code here
*/
}
}
]]></arrayElement><arrayElement dataType="System.String"><![CDATA[\properties\resources.resx]]></arrayElement><arrayElement dataType="System.String"><![CDATA[<?xml version="1.0" encoding="utf-8"?>
<root>
<!--
Microsoft ResX Schema
Version 2.0
The primary goals of this format is to allow a simple XML format
that is mostly human readable. The generation and parsing of the
various data types are done through the TypeConverter classes
associated with the data types.
Example:
... ado.net/XML headers & schema ...
<resheader name="resmimetype">text/microsoft-resx</resheader>
<resheader name="version">2.0</resheader>
<resheader name="reader">System.Resources.ResXResourceReader, System.Windows.Forms, ...</resheader>
<resheader name="writer">System.Resources.ResXResourceWriter, System.Windows.Forms, ...</resheader>
<data name="Name1"><value>this is my long string</value><comment>this is a comment</comment></data>
<data name="Color1" type="System.Drawing.Color, System.Drawing">Blue</data>
<data name="Bitmap1" mimetype="application/x-microsoft.net.object.binary.base64">
<value>[base64 mime encoded serialized .NET Framework object]</value>
</data>
<data name="Icon1" type="System.Drawing.Icon, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">
<value>[base64 mime encoded string representing a byte array form of the .NET Framework object]</value>
<comment>This is a comment</comment>
</data>
There are any number of "resheader" rows that contain simple
name/value pairs.
Each data row contains a name, and value. The row also contains a
type or mimetype. Type corresponds to a .NET class that support
text/value conversion through the TypeConverter architecture.
Classes that don't support this are serialized and stored with the
mimetype set.
The mimetype is used for serialized objects, and tells the
ResXResourceReader how to depersist the object. This is currently not
extensible. For a given mimetype the value must be set accordingly:
Note - application/x-microsoft.net.object.binary.base64 is the format
that the ResXResourceWriter will generate, however the reader can
read any of the formats listed below.
mimetype: application/x-microsoft.net.object.binary.base64
value : The object must be serialized with
: System.Serialization.Formatters.Binary.BinaryFormatter
: and then encoded with base64 encoding.
mimetype: application/x-microsoft.net.object.soap.base64
value : The object must be serialized with
: System.Runtime.Serialization.Formatters.Soap.SoapFormatter
: and then encoded with base64 encoding.
mimetype: application/x-microsoft.net.object.bytearray.base64
value : The object must be serialized into a byte array
: using a System.ComponentModel.TypeConverter
: and then encoded with base64 encoding.
-->
<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>]]></arrayElement><arrayElement dataType="System.String"><![CDATA[\properties\settings.designer.cs]]></arrayElement><arrayElement dataType="System.String"><![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 = "SC_1ad37a2e607e4803bd0bb72cbb60a74e.csproj.Properties.Settings.get_Default():SC_1ad37a2e607e4803bd0bb72cbb60a74e.csproj.Properties.Sett" +
"ings")]
namespace SC_1ad37a2e607e4803bd0bb72cbb60a74e.csproj.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;
}
}
}
}
]]></arrayElement><arrayElement dataType="System.String"><![CDATA[\properties\settings.settings]]></arrayElement><arrayElement dataType="System.String"><![CDATA[<?xml version='1.0' encoding='iso-8859-1'?>
<SettingsFile xmlns="uri:settings" CurrentProfile="(Default)">
<Profiles>
<Profile Name="(Default)" />
</Profiles>
<Settings />
</SettingsFile>]]></arrayElement><arrayElement dataType="System.String"><![CDATA[\properties\assemblyinfo.cs]]></arrayElement><arrayElement dataType="System.String"><![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("SC_1ad37a2e607e4803bd0bb72cbb60a74e.csproj")]
[assembly: AssemblyDescription("")]
[assembly: AssemblyConfiguration("")]
[assembly: AssemblyCompany("Microsoft")]
[assembly: AssemblyProduct("SC_1ad37a2e607e4803bd0bb72cbb60a74e.csproj")]
[assembly: AssemblyCopyright("Copyright @ Microsoft 2009")]
[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.*")]
]]></arrayElement><arrayElement dataType="System.String"><![CDATA[\sc_1ad37a2e607e4803bd0bb72cbb60a74e.csproj]]></arrayElement><arrayElement dataType="System.String"><![CDATA[<Project ToolsVersion="3.5" DefaultTargets="Build" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
<!-- This section defines project-level properties.
Configuration - Specifies whether the default configuration is Release or Debug.
Platform - Specifies what CPU the output of this project can run on.
OutputType - Must be "Library" for VSTA.
NoStandardLibraries - Set to "false" for VSTA.
RootNamespace - In C#, this specifies the namespace given to new files.
In Visual Basic, all objects are wrapped in this namespace at runtime.
AssemblyName - Name of the output assembly.
-->
<PropertyGroup>
<ProjectTypeGuids>{A860303F-1F3F-4691-B57E-529FC101A107};{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}</ProjectTypeGuids>
<Configuration Condition=" '$(Configuration)' == '' ">Debug</Configuration>
<Platform Condition=" '$(Platform)' == '' ">AnyCPU</Platform>
<OutputType>Library</OutputType>
<NoStandardLibraries>false</NoStandardLibraries>
<RootNamespace>SC_1ad37a2e607e4803bd0bb72cbb60a74e.csproj</RootNamespace>
<AssemblyName>SC_1ad37a2e607e4803bd0bb72cbb60a74e.csproj</AssemblyName>
<ProjectGuid>{6F94DC22-826E-43C4-AE47-FF646B7C4C55}</ProjectGuid>
</PropertyGroup>
<!-- This section defines properties that are set when the "Debug" configuration is
selected.
DebugSymbols - If true, create symbols (.pdb). If false, do not create symbols.
Optimize - If true, optimize the build output. If false, do not optimize.
OutputPath - Output path of the project relative to the project file.
EnableUnmanagedDebugging - If true, starting the debugger will attach both managed and unmanaged debuggers.
DefineConstants - Constants defined for the preprocessor.
Warning Level - Warning level for the compiler.
-->
<PropertyGroup Condition=" '$(Configuration)' == 'Debug' ">
<DebugSymbols>true</DebugSymbols>
<Optimize>false</Optimize>
<OutputPath>.\bin\Debug\</OutputPath>
<EnableUnmanagedDebugging>false</EnableUnmanagedDebugging>
<DefineConstants>DEBUG;TRACE</DefineConstants>
<WarningLevel>4</WarningLevel>
</PropertyGroup>
<!-- This section defines properties that are set when the "Release" configuration is
selected.
DebugSymbols - If true, create symbols (.pdb). If false, do not create symbols.
Optimize - If true, optimize the build output. If false, do not optimize.
OutputPath - Output path of the project relative to the project file.
EnableUnmanagedDebugging - If true, starting the debugger will attach both managed and unmanaged debuggers.
DefineConstants - Constants defined for the preprocessor.
Warning Level - Warning level for the compiler.
-->
<PropertyGroup Condition=" '$(Configuration)' == 'Release' ">
<DebugSymbols>false</DebugSymbols>
<Optimize>true</Optimize>
<OutputPath>.\bin\Release\</OutputPath>
<EnableUnmanagedDebugging>false</EnableUnmanagedDebugging>
<DefineConstants>TRACE</DefineConstants>
<WarningLevel>4</WarningLevel>
</PropertyGroup>
<!-- This section enables pre- and post-build steps. However,
it is recommended that MSBuild tasks be used instead of these properties.
-->
<PropertyGroup>
<PreBuildEvent>
</PreBuildEvent>
<PostBuildEvent>
</PostBuildEvent>
</PropertyGroup>
<!-- This sections specifies references for the project. -->
<ItemGroup>
<Reference Include="System" />
<Reference Include="System.Data" />
<Reference Include="System.Windows.Forms" />
<Reference Include="System.Xml" />
<Reference Include="Microsoft.SqlServer.TxScript, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />
<Reference Include="Microsoft.SqlServer.DTSRuntimeWrap, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />
<Reference Include="Microsoft.SqlServer.DTSPipelineWrap, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />
<Reference Include="Microsoft.SqlServer.PipelineHost, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />
</ItemGroup>
<!-- This section defines the user source files that are part of the
project.
Compile - Specifies a source file to compile.
EmbeddedResource - Specifies a .resx file for embedded resources.
None - Specifies a file that is not to be passed to the compiler (for instance,
a text file or XML file).
AppDesigner - Specifies the directory where the application properties files can
be found.
-->
<ItemGroup>
<AppDesigner Include="Properties\" />
<Compile Include="BufferWrapper.cs" />
<Compile Include="ComponentWrapper.cs" />
<Compile Include="main.cs" />
<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>
<!-- Include the default configuration information and metadata files for the add-in.
These files are copied to the build output directory when the project is
built, and the path to the configuration file is passed to the add-in on the command
line when debugging.
-->
</ItemGroup>
<!-- Include the build rules for a C# project.-->
<Import Project="$(MSBuildBinPath)\Microsoft.CSharp.targets" />
<!-- This section defines VSTA properties that describe the host-changable project properties. -->
<ProjectExtensions>
<VisualStudio>
<FlavorProperties GUID="{A860303F-1F3F-4691-B57E-529FC101A107}">
<ProjectProperties HostName="VSTAHostName" HostPackage="{C1B21C64-9E6F-4923-A89D-9F958503C1CE}" ApplicationType="usd" Language="cs" TemplatesPath="" />
<Host Name="SSIS_ScriptComponent" IconIndex="0" />
<ProjectClient>
<HostIdentifier>SSIS_ScriptComponent</HostIdentifier>
</ProjectClient>
</FlavorProperties>
</VisualStudio>
</ProjectExtensions>
</Project>]]></arrayElement><arrayElement dataType="System.String"><![CDATA[\bufferwrapper.cs]]></arrayElement><arrayElement dataType="System.String"><![CDATA[/* THIS IS AUTO-GENERATED CODE THAT WILL BE OVERWRITTEN! DO NOT EDIT!
* Microsoft SQL Server Integration Services buffer wrappers
* This module defines classes for accessing data flow buffers
* THIS IS AUTO-GENERATED CODE THAT WILL BE OVERWRITTEN! DO NOT EDIT! */
using System;
using System.Data;
using Microsoft.SqlServer.Dts.Pipeline;
using Microsoft.SqlServer.Dts.Pipeline.Wrapper;
public class Input0Buffer: ScriptBuffer
{
public Input0Buffer(PipelineBuffer Buffer, int[] BufferColumnIndexes)
: base(Buffer, BufferColumnIndexes)
{
}
new public bool NextRow()
{
return base.NextRow();
}
new public bool EndOfRowset()
{
return base.EndOfRowset();
}
}
]]></arrayElement><arrayElement dataType="System.String"><![CDATA[\properties\resources.designer.cs]]></arrayElement><arrayElement dataType="System.String"><![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 = "SC_1ad37a2e607e4803bd0bb72cbb60a74e.csproj.Properties.Resources.get_ResourceManager():System.Resources.Resou" +
"rceManager")]
[assembly: global::System.Diagnostics.CodeAnalysis.SuppressMessageAttribute("Microsoft.Performance", "CA1811:AvoidUncalledPrivateCode", Scope = "member", Target = "SC_1ad37a2e607e4803bd0bb72cbb60a74e.csproj.Properties.Resources.get_Culture():System.Globalization.CultureIn" +
"fo")]
[assembly: global::System.Diagnostics.CodeAnalysis.SuppressMessageAttribute("Microsoft.Performance", "CA1811:AvoidUncalledPrivateCode", Scope = "member", Target = "SC_1ad37a2e607e4803bd0bb72cbb60a74e.csproj.Properties.Resources.set_Culture(System.Globalization.CultureInfo" +
"):Void")]
namespace SC_1ad37a2e607e4803bd0bb72cbb60a74e.csproj.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("SC_1ad37a2e607e4803bd0bb72cbb60a74e.csproj.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;
}
}
}
}
]]></arrayElement><arrayElement dataType="System.String"><![CDATA[\componentwrapper.cs]]></arrayElement><arrayElement dataType="System.String"><![CDATA[/* THIS IS AUTO-GENERATED CODE THAT WILL BE OVERWRITTEN! DO NOT EDIT!
* Microsoft SQL Server Integration Services component wrapper
* This module defines the base class for your component
* THIS IS AUTO-GENERATED CODE THAT WILL BE OVERWRITTEN! DO NOT EDIT! */
using System;
using System.Data;
using Microsoft.SqlServer.Dts.Pipeline;
using Microsoft.SqlServer.Dts.Pipeline.Wrapper;
using Microsoft.SqlServer.Dts.Runtime.Wrapper;
public class UserComponent: ScriptComponent
{
public Connections Connections;
public Variables Variables;
public UserComponent()
{
Connections = new Connections(this);
Variables = new Variables(this);
}
public override void ProcessInput(int InputID, PipelineBuffer Buffer)
{
if (InputID == 37)
{
Input0_ProcessInput(new Input0Buffer(Buffer, GetColumnIndexes(InputID)));
}
}
public virtual void Input0_ProcessInput(Input0Buffer Buffer)
{
while (Buffer.NextRow())
{
Input0_ProcessInputRow(Buffer);
}
}
public virtual void Input0_ProcessInputRow(Input0Buffer Row)
{
}
}
public class Connections
{
ScriptComponent ParentComponent;
public Connections(ScriptComponent Component)
{
ParentComponent = Component;
}
}
public class Variables
{
ScriptComponent ParentComponent;
public Variables(ScriptComponent Component)
{
ParentComponent = Component;
}
}
]]></arrayElement></arrayElements></property>
<property id="40" name="BinaryCode" dataType="System.String" state="cdata" isArray="true" description="Stores the binary representation of the component" typeConverter="" UITypeEditor="" containsID="false" expressionType="None"><arrayElements arrayElementCount="2"><arrayElement dataType="System.String"><![CDATA[\bin\release\sc_1ad37a2e607e4803bd0bb72cbb60a74e.csproj.dll]]></arrayElement><arrayElement dataType="System.String"><![CDATA[TVqQAAMAAAAEAAAA//8AALgAAAAAAAAAQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAgAAAAA4fug4AtAnNIbgBTM0hVGhpcyBwcm9ncmFtIGNhbm5vdCBiZSBydW4gaW4gRE9TIG1v
ZGUuDQ0KJAAAAAAAAABQRQAATAEDAA1050kAAAAAAAAAAOAAAiELAQgAABAAAAAIAAAAAAAADi8A
AAAgAAAAQAAAAABAAAAgAAAAAgAABAAAAAAAAAAEAAAAAAAAAACAAAAAAgAAAAAAAAMAQIUAABAA
ABAAAAAAEAAAEAAAAAAAABAAAAAAAAAAAAAAALQuAABXAAAAAEAAAJAEAAAAAAAAAAAAAAAAAAAA
AAAAAGAAAAwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAIAAACAAAAAAAAAAAAAAACCAAAEgAAAAAAAAAAAAAAC50ZXh0AAAAFA8AAAAgAAAAEAAAAAIA
AAAAAAAAAAAAAAAAACAAAGAucnNyYwAAAJAEAAAAQAAAAAYAAAASAAAAAAAAAAAAAAAAAABAAABA
LnJlbG9jAAAMAAAAAGAAAAACAAAAGAAAAAAAAAAAAAAAAAAAQAAAQgAAAAAAAAAAAAAAAAAAAADw
LgAAAAAAAEgAAAACAAUAGCIAAJwMAAABAAAAAAAAAGAhAAC4AAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAABp+AQAABCoucwIAAAaAAQAABCoeAigNAAAKKh4CKA8AAAoq
ABMwAwAtAAAAAQAAEX4CAAAELSByAQAAcNADAAACKBAAAApvEQAACnMSAAAKCgaAAgAABH4CAAAE
Khp+AwAABCoeAoADAAAEKn4CKBQAAAoCAnMTAAAGfQQAAAQCAnMUAAAGfQUAAAQqZgMfJTMTAgQC
AygVAAAKcxAAAAZvCgAABipKKwcCA28LAAAGA28RAAAGLfEqBioeAigXAAAKKh4CKBgAAAoqBioe
AigIAAAGKiYCAwQoGQAACioeAigaAAAKKh4CKBsAAAoqOgIoDwAACgIDfQYAAAQqOgIoDwAACgID
fQcAAAQqAAAAtAAAAM7K774BAAAAkQAAAGxTeXN0ZW0uUmVzb3VyY2VzLlJlc291cmNlUmVhZGVy
LCBtc2NvcmxpYiwgVmVyc2lvbj0yLjAuMC4wLCBDdWx0dXJlPW5ldXRyYWwsIFB1YmxpY0tleVRv
a2VuPWI3N2E1YzU2MTkzNGUwODkjU3lzdGVtLlJlc291cmNlcy5SdW50aW1lUmVzb3VyY2VTZXQC
AAAAAAAAAAAAAABQQURQQURQtAAAAEJTSkIBAAEAAAAAAAwAAAB2Mi4wLjUwNzI3AAAAAAUAbAAA
AIgEAAAjfgAA9AQAANQFAAAjU3RyaW5ncwAAAADICgAAhAAAACNVUwBMCwAAEAAAACNHVUlEAAAA
XAsAAEABAAAjQmxvYgAAAAAAAAACAAABVxWiAQkBAAAA+gEzABYAAAEAAAAaAAAACAAAAAcAAAAU
AAAACgAAABsAAAAOAAAAAQAAAAIAAAADAAAABAAAAAEAAAAEAAAAAQAAAAAACgABAAAAAAAGANoA
xQAKAPsAvgAOAEABHwEOAFABHwEKAJgBhwEKAMkBtAESADoCHwEKAAUD8wIKABwD8wIKADkD8wIK
AFgD8wIKAHED8wIKAIoD8wIKAKUD8wIKAMAD8wIKANkD8wIKABIE8gMKADIE8gMKAHsE8gMKALAE
nQQKAM0EvgAKANIEvgAKAPYE8wIGACIFDAUGADsFDAUOAGEFHwEAAAAAAQAAAAAAAQABAAABEAA5
AEIABQABAAEAAAAQAHgAQgAJAAIABAABABAAggAAAA0ABAAIAAEAEACQAAAAEAAGAAwAAQAQAJsA
AAARAAYAEAABABAAqAAAAAkABgATAAEAEAC0AAAACQAHABQAEQBdARMAEQCoASUAEQDVASkABgCo
AEcABgC0AEsAAQCsAmgAAQCsAmgAUCAAAAAAlghtARcAAQBjIAAAAACGGHkBHAABAFcgAAAAAJEY
lgSBAAEAayAAAAAAgxh5ARwAAQB0IAAAAACTCOUBLQABAK0gAAAAAJMI+QEyAAEAtCAAAAAAkwgF
AjcAAQC8IAAAAACGGHkBHAACANwgAAAAAMYASQJPAAIA9iAAAAAAxgFWAlYABAAJIQAAAADGAWoC
VgAFAAshAAAAAMYAgQIcAAYAEyEAAAAAxgCMAhwABgAbIQAAAADGAGoCVgAGAB0hAAAAAIYYeQEc
AAcAJSEAAAAAhhh5AVwABwAvIQAAAACGAJgCZAAJADchAAAAAIYAoAJkAAkAPyEAAAAAhhh5AWwA
CQBOIQAAAACGGHkBbAAKAAAAAQC8AgAAAQDCAgAAAgDKAgAAAQDKAgAAAQDRAgAAAQDRAgAAAQDK
AgAAAgDVAgAAAQDpAgAAAQDpAkEAeQFyAEkAeQFyAFEAeQFyAFkAeQFyAGEAeQFyAGkAeQFyAHEA
eQFyAHkAeQFyAIEAeQFyAIkAeQF3AJEAeQEcAJkAeQEcAAkAeQEcAKEAeQEcABEAeQEcAKkA5ASF
AKkA/wSMACkAeQGRAMEAeQGdABkAeQEcABkAUAWsANEAeQEcABkAgQIcABkAjAIcACEAeQFcACEA
mAJkACEAoAJkACEAYwB8AC4AEwDiAC4AGwDiAC4AIwDoAC4AUwAXAS4ACwCyAC4AWwAgAS4AKwCy
AC4AMwD3AC4AOwDiAEkAmwCjAGMAcwB8AGkAmwCjAKMAswB8AJgAAgABAAMAAgAAAH8BIAAAAJgB
PQAAABECQgACAAEAAwACAAUABQACAAYABwABAAcABwAEgAAAAQAAAEENhn8AAAAAAABQBAAAAgAA
AAAAAAAAAAAAAQC+AAAAAAACAAAAAAAAAAAAAAABAPIAAAAAAAoAAAAAAAAAAAAAAAoAAgEAAAAA
CgAAAAAAAAAAAAAACgAZAgAAAAAAAAAAAQAAAIgFAAAAAAAAADxNb2R1bGU+AFNDXzFhZDM3YTJl
NjA3ZTQ4MDNiZDBiYjcyY2JiNjBhNzRlLmNzcHJvai5kbGwAU2V0dGluZ3MAU0NfMWFkMzdhMmU2
MDdlNDgwM2JkMGJiNzJjYmI2MGE3NGUuY3Nwcm9qLlByb3BlcnRpZXMAUmVzb3VyY2VzAFVzZXJD
b21wb25lbnQAU2NyaXB0TWFpbgBJbnB1dDBCdWZmZXIAQ29ubmVjdGlvbnMAVmFyaWFibGVzAFN5
c3RlbQBTeXN0ZW0uQ29uZmlndXJhdGlvbgBBcHBsaWNhdGlvblNldHRpbmdzQmFzZQBtc2Nvcmxp
YgBPYmplY3QATWljcm9zb2Z0LlNxbFNlcnZlci5UeFNjcmlwdABNaWNyb3NvZnQuU3FsU2VydmVy
LkR0cy5QaXBlbGluZQBTY3JpcHRDb21wb25lbnQAU2NyaXB0QnVmZmVyAGRlZmF1bHRJbnN0YW5j
ZQBnZXRfRGVmYXVsdAAuY3RvcgBEZWZhdWx0AFN5c3RlbS5SZXNvdXJjZXMAUmVzb3VyY2VNYW5h
Z2VyAHJlc291cmNlTWFuAFN5c3RlbS5HbG9iYWxpemF0aW9uAEN1bHR1cmVJbmZvAHJlc291cmNl
Q3VsdHVyZQBnZXRfUmVzb3VyY2VNYW5hZ2VyAGdldF9DdWx0dXJlAHNldF9DdWx0dXJlAEN1bHR1
cmUATWljcm9zb2Z0LlNxbFNlcnZlci5QaXBlbGluZUhvc3QAUGlwZWxpbmVCdWZmZXIAUHJvY2Vz
c0lucHV0AElucHV0MF9Qcm9jZXNzSW5wdXQASW5wdXQwX1Byb2Nlc3NJbnB1dFJvdwBQcmVFeGVj
dXRlAFBvc3RFeGVjdXRlAE5leHRSb3cARW5kT2ZSb3dzZXQAUGFyZW50Q29tcG9uZW50AHZhbHVl
AElucHV0SUQAQnVmZmVyAFJvdwBCdWZmZXJDb2x1bW5JbmRleGVzAENvbXBvbmVudABTeXN0ZW0u
UmVmbGVjdGlvbgBBc3NlbWJseVRpdGxlQXR0cmlidXRlAEFzc2VtYmx5RGVzY3JpcHRpb25BdHRy
aWJ1dGUAQXNzZW1ibHlDb25maWd1cmF0aW9uQXR0cmlidXRlAEFzc2VtYmx5Q29tcGFueUF0dHJp
YnV0ZQBBc3NlbWJseVByb2R1Y3RBdHRyaWJ1dGUAQXNzZW1ibHlDb3B5cmlnaHRBdHRyaWJ1dGUA
QXNzZW1ibHlUcmFkZW1hcmtBdHRyaWJ1dGUAQXNzZW1ibHlDdWx0dXJlQXR0cmlidXRlAEFzc2Vt
Ymx5VmVyc2lvbkF0dHJpYnV0ZQBTeXN0ZW0uUnVudGltZS5Db21waWxlclNlcnZpY2VzAENvbXBp
bGF0aW9uUmVsYXhhdGlvbnNBdHRyaWJ1dGUAUnVudGltZUNvbXBhdGliaWxpdHlBdHRyaWJ1dGUA
U0NfMWFkMzdhMmU2MDdlNDgwM2JkMGJiNzJjYmI2MGE3NGUuY3Nwcm9qAENvbXBpbGVyR2VuZXJh
dGVkQXR0cmlidXRlAC5jY3RvcgBTeXN0ZW0uRGlhZ25vc3RpY3MARGVidWdnZXJOb25Vc2VyQ29k
ZUF0dHJpYnV0ZQBUeXBlAFJ1bnRpbWVUeXBlSGFuZGxlAEdldFR5cGVGcm9tSGFuZGxlAEFzc2Vt
Ymx5AGdldF9Bc3NlbWJseQBTeXN0ZW0uQ29tcG9uZW50TW9kZWwARWRpdG9yQnJvd3NhYmxlQXR0
cmlidXRlAEVkaXRvckJyb3dzYWJsZVN0YXRlAEdldENvbHVtbkluZGV4ZXMAU1NJU1NjcmlwdENv
bXBvbmVudEVudHJ5UG9pbnRBdHRyaWJ1dGUAU0NfMWFkMzdhMmU2MDdlNDgwM2JkMGJiNzJjYmI2
MGE3NGUuY3Nwcm9qLlByb3BlcnRpZXMuUmVzb3VyY2VzLnJlc291cmNlcwAAAAB/UwBDAF8AMQBh
AGQAMwA3AGEAMgBlADYAMAA3AGUANAA4ADAAMwBiAGQAMABiAGIANwAyAGMAYgBiADYAMABhADcA
NABlAC4AYwBzAHAAcgBvAGoALgBQAHIAbwBwAGUAcgB0AGkAZQBzAC4AUgBlAHMAbwB1AHIAYwBl
AHMAAAAAACul4LUywvJMl0otqdib1lYACLd6XFYZNOCJCImEXc2AgMyRAwYSCAQAABIIAyAAAQQI
ABIIAwYSFQMGEhkEAAASFQQAABIZBQABARIZBAgAEhUECAASGQMGEhwDBhIgBiACAQgSHQUgAQES
GAcgAgESHR0IAyAAAgMGEg0FIAEBEg0EIAEBDgQgAQEIBAEAAAADAAABBgABElURWQQgABJdBiAC
AQ4SXQQHARIVBSABARFlCAEAAgAAAAAABSABHQgILwEAKlNDXzFhZDM3YTJlNjA3ZTQ4MDNiZDBi
YjcyY2JiNjBhNzRlLmNzcHJvagAABQEAAAAADgEACU1pY3Jvc29mdAAAHwEAGkNvcHlyaWdodCBA
IE1pY3Jvc29mdCAyMDA5AAAIAQAIAAAAAAAeAQABAFQCFldyYXBOb25FeGNlcHRpb25UaHJvd3MB
ANwuAAAAAAAAAAAAAP4uAAAAIAAAAAAAAAAAAAAAAAAAAAAAAAAAAADwLgAAAAAAAAAAAAAAAAAA
AAAAAAAAX0NvckRsbE1haW4AbXNjb3JlZS5kbGwAAAAAAP8lACBAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAABABAAAAAYAACAAAAAAAAAAAAAAAAAAAABAAEAAAAwAACAAAAAAAAAAAAAAAAAAAABAAAA
AABIAAAAWEAAADgEAAAAAAAAAAAAADgENAAAAFYAUwBfAFYARQBSAFMASQBPAE4AXwBJAE4ARgBP
AAAAAAC9BO/+AAABAAAAAQCGf0ENAAABAIZ/QQ0/AAAAAAAAAAQAAAACAAAAAAAAAAAAAAAAAAAA
RAAAAAEAVgBhAHIARgBpAGwAZQBJAG4AZgBvAAAAAAAkAAQAAABUAHIAYQBuAHMAbABhAHQAaQBv
AG4AAAAAAAAAsASYAwAAAQBTAHQAcgBpAG4AZwBGAGkAbABlAEkAbgBmAG8AAAB0AwAAAQAwADAA
MAAwADAANABiADAAAAA0AAoAAQBDAG8AbQBwAGEAbgB5AE4AYQBtAGUAAAAAAE0AaQBjAHIAbwBz
AG8AZgB0AAAAgAArAAEARgBpAGwAZQBEAGUAcwBjAHIAaQBwAHQAaQBvAG4AAAAAAFMAQwBfADEA
YQBkADMANwBhADIAZQA2ADAANwBlADQAOAAwADMAYgBkADAAYgBiADcAMgBjAGIAYgA2ADAAYQA3
ADQAZQAuAGMAcwBwAHIAbwBqAAAAAABAAA8AAQBGAGkAbABlAFYAZQByAHMAaQBvAG4AAAAAADEA
LgAwAC4AMwAzADkAMwAuADMAMgA2ADQANgAAAAAAgAAvAAEASQBuAHQAZQByAG4AYQBsAE4AYQBt
AGUAAABTAEMAXwAxAGEAZAAzADcAYQAyAGUANgAwADcAZQA0ADgAMAAzAGIAZAAwAGIAYgA3ADIA
YwBiAGIANgAwAGEANwA0AGUALgBjAHMAcAByAG8AagAuAGQAbABsAAAAAABcABsAAQBMAGUAZwBh
AGwAQwBvAHAAeQByAGkAZwBoAHQAAABDAG8AcAB5AHIAaQBnAGgAdAAgAEAAIABNAGkAYwByAG8A
cwBvAGYAdAAgADIAMAAwADkAAAAAAIgALwABAE8AcgBpAGcAaQBuAGEAbABGAGkAbABlAG4AYQBt
AGUAAABTAEMAXwAxAGEAZAAzADcAYQAyAGUANgAwADcAZQA0ADgAMAAzAGIAZAAwAGIAYgA3ADIA
YwBiAGIANgAwAGEANwA0AGUALgBjAHMAcAByAG8AagAuAGQAbABsAAAAAAB4ACsAAQBQAHIAbwBk
AHUAYwB0AE4AYQBtAGUAAAAAAFMAQwBfADEAYQBkADMANwBhADIAZQA2ADAANwBlADQAOAAwADMA
YgBkADAAYgBiADcAMgBjAGIAYgA2ADAAYQA3ADQAZQAuAGMAcwBwAHIAbwBqAAAAAABEAA8AAQBQ
AHIAbwBkAHUAYwB0AFYAZQByAHMAaQBvAG4AAAAxAC4AMAAuADMAMwA5ADMALgAzADIANgA0ADYA
AAAAAEgADwABAEEAcwBzAGUAbQBiAGwAeQAgAFYAZQByAHMAaQBvAG4AAAAxAC4AMAAuADMAMwA5
ADMALgAzADIANgA0ADYAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACAAAAwAAAAQPwAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=]]></arrayElement></arrayElements></property>
<property id="41" name="VSTAProjectName" dataType="System.String" state="default" isArray="false" description="Specifies the name of the Microsoft Visual Studio Tools for Applications project. Project names must be unique within a package." typeConverter="NOTBROWSABLE" UITypeEditor="" containsID="false" expressionType="None">SC_1ad37a2e607e4803bd0bb72cbb60a74e</property>
<property id="42" name="ScriptLanguage" dataType="System.String" state="default" isArray="false" description="Specifies the programming language used by the script." typeConverter="Microsoft.SqlServer.VSTAHosting.ScriptingLanguages, Microsoft.SqlServer.VSTAScriptingLib, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" UITypeEditor="" containsID="false" expressionType="None">CSharp</property>
<property id="43" name="ReadOnlyVariables" dataType="System.String" state="default" isArray="false" description="Specifies a comma-separated list of read-only variables." typeConverter="" UITypeEditor="Microsoft.SqlServer.Dts.Pipeline.ScriptUIVariablePickerDlg, Microsoft.SqlServer.TxScript, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" containsID="false" expressionType="None"></property>
<property id="44" name="ReadWriteVariables" dataType="System.String" state="default" isArray="false" description="Specifies a comma-separated list of read/write variables." typeConverter="" UITypeEditor="Microsoft.SqlServer.Dts.Pipeline.ScriptUIVariablePickerDlg, Microsoft.SqlServer.TxScript, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" containsID="false" expressionType="None"></property>
<property id="45" name="BreakpointCollection" dataType="System.String" state="default" isArray="true" description="List of breakpoints present on the script." typeConverter="NOTBROWSABLE" UITypeEditor="" containsID="false" expressionType="None"><arrayElements arrayElementCount="0"/></property>
<property id="46" name="UserComponentTypeName" dataType="System.String" state="default" isArray="false" description="" typeConverter="" UITypeEditor="" containsID="false" expressionType="None">Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost, Microsoft.SqlServer.TxScript, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91</property></properties>
<inputs>
<input id="37" name="Input 0" description="" hasSideEffects="true" dangling="false" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed"><inputColumns>
<inputColumn id="49" name="" description="" lineageId="31" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0" mappedColumnId="0"/>
<inputColumn id="50" name="" description="" lineageId="30" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0" mappedColumnId="0"/>
<inputColumn id="51" name="" description="" lineageId="29" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0" mappedColumnId="0"/>
<inputColumn id="52" name="" description="" lineageId="28" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0" mappedColumnId="0"/>
<inputColumn id="53" name="" description="" lineageId="27" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0" mappedColumnId="0"/>
<inputColumn id="54" name="" description="" lineageId="26" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0" mappedColumnId="0"/>
<inputColumn id="55" name="" description="" lineageId="25" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0" mappedColumnId="0"/>
<inputColumn id="56" name="" description="" lineageId="24" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0" mappedColumnId="0"/>
<inputColumn id="57" name="" description="" lineageId="23" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0" mappedColumnId="0"/>
<inputColumn id="58" name="" description="" lineageId="22" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0" mappedColumnId="0"/>
<inputColumn id="59" name="" description="" lineageId="21" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0" mappedColumnId="0"/>
<inputColumn id="60" name="" description="" lineageId="20" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0" mappedColumnId="0"/>
<inputColumn id="61" name="" description="" lineageId="19" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0" mappedColumnId="0"/>
<inputColumn id="62" name="" description="" lineageId="18" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0" mappedColumnId="0"/>
<inputColumn id="63" name="" description="" lineageId="17" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0" mappedColumnId="0"/>
<inputColumn id="64" name="" description="" lineageId="16" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0" mappedColumnId="0"/>
<inputColumn id="65" name="" description="" lineageId="15" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0" mappedColumnId="0"/>
<inputColumn id="66" name="" description="" lineageId="14" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0" mappedColumnId="0"/>
<inputColumn id="67" name="" description="" lineageId="13" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0" mappedColumnId="0"/>
</inputColumns><externalMetadataColumns isUsed="False"/></input>
</inputs>
</component>
</components>
<paths>
<path id="47" name="Dates" description="" startId="4" endId="37"/>
</paths></pipeline></DTS:ObjectData></DTS:Executable>
<DTS:Property DTS:Name="ObjectName">Date Source Sample</DTS:Property>
<DTS:Property DTS:Name="DTSID">{1488397E-49CC-4BB9-9A35-BEE3EE4FEE0D}</DTS:Property>
<DTS:Property DTS:Name="Description"></DTS:Property>
<DTS:Property DTS:Name="CreationName">SSIS.Package.2</DTS:Property>
<DTS:Property DTS:Name="DisableEventHandlers">0</DTS:Property>
<DTS:PackageVariable>
<DTS:Property DTS:Name="PackageVariableValue" DTS:DataType="8">&lt;Package xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"&gt;&lt;dwd:DtsControlFlowDiagram&gt;&lt;dwd:Layout&gt;&lt;dds&gt;
&lt;diagram fontclsid="{0BE35203-8F91-11CE-9DE3-00AA004BB851}" mouseiconclsid="{0BE35204-8F91-11CE-9DE3-00AA004BB851}" defaultlayout="Microsoft.DataWarehouse.Layout.GraphLayout100" defaultlineroute="Microsoft.DataWarehouse.Layout.GraphLayout100" version="7" nextobject="5" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="0" scrolltop="0" gridx="150" gridy="150" marginx="1000" marginy="1000" zoom="100" x="35745" y="23760" backcolor="15334399" defaultpersistence="2" PrintPageNumbersMode="3" PrintMarginTop="0" PrintMarginBottom="635" PrintMarginLeft="0" PrintMarginRight="0" marqueeselectionmode="1" mousepointer="0" snaptogrid="0" autotypeannotation="1" showscrollbars="0" viewpagebreaks="0" donotforceconnectorsbehindshapes="1" backpictureclsid="{00000000-0000-0000-0000-000000000000}"&gt;
&lt;font&gt;
&lt;ddsxmlobjectstreamwrapper binary="01010000900180380100065461686f6d61" /&gt;
&lt;/font&gt;
&lt;mouseicon&gt;
&lt;ddsxmlobjectstreamwrapper binary="6c74000000000000" /&gt;
&lt;/mouseicon&gt;
&lt;/diagram&gt;
&lt;layoutmanager&gt;
&lt;ddsxmlobj /&gt;
&lt;/layoutmanager&gt;
&lt;ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Data Flow Task" left="1000" top="1000" logicalid="2" controlid="1" masterid="0" hint1="0" hint2="0" width="3598" height="1164" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"&gt;
&lt;control&gt;
&lt;ddsxmlobjectstreaminitwrapper binary="000800000e0e00008c040000" /&gt;
&lt;/control&gt;
&lt;layoutobject&gt;
&lt;ddsxmlobj&gt;
&lt;property name="LogicalObject" value="{31B99051-27C6-4FB1-9178-B2E06C8EB11D}" vartype="8" /&gt;
&lt;property name="ShowConnectorSource" value="0" vartype="2" /&gt;
&lt;/ddsxmlobj&gt;
&lt;/layoutobject&gt;
&lt;shape groupshapeid="0" groupnode="0" /&gt;
&lt;/ddscontrol&gt;
&lt;/dds&gt;&lt;/dwd:Layout&gt;&lt;/dwd:DtsControlFlowDiagram&gt;&lt;/Package&gt;</DTS:Property>
<DTS:Property DTS:Name="Namespace">dts-designer-1.0</DTS:Property>
<DTS:Property DTS:Name="ObjectName">{1488397E-49CC-4BB9-9A35-BEE3EE4FEE0D}</DTS:Property>
<DTS:Property DTS:Name="DTSID">{9B303652-11B5-4B09-9CE3-91EB63C60E96}</DTS:Property>
<DTS:Property DTS:Name="Description"></DTS:Property>
<DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:PackageVariable>
<DTS:PackageVariable>
<DTS:Property DTS:Name="PackageVariableValue" DTS:DataType="8">&lt;TaskHost xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"&gt;&lt;dwd:DtsDataFlowDiagram&gt;&lt;dwd:BoundingLeft&gt;1000&lt;/dwd:BoundingLeft&gt;&lt;dwd:BoundingTop&gt;1000&lt;/dwd:BoundingTop&gt;&lt;dwd:Layout&gt;&lt;dds&gt;
&lt;diagram fontclsid="{0BE35203-8F91-11CE-9DE3-00AA004BB851}" mouseiconclsid="{0BE35204-8F91-11CE-9DE3-00AA004BB851}" defaultlayout="Microsoft.DataWarehouse.Layout.GraphLayout100" defaultlineroute="Microsoft.DataWarehouse.Layout.GraphLayout100" version="7" nextobject="14" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="0" scrolltop="0" gridx="150" gridy="150" marginx="1000" marginy="1000" zoom="100" x="35745" y="22834" backcolor="15334399" defaultpersistence="2" PrintPageNumbersMode="3" PrintMarginTop="0" PrintMarginBottom="635" PrintMarginLeft="0" PrintMarginRight="0" marqueeselectionmode="1" mousepointer="0" snaptogrid="0" autotypeannotation="1" showscrollbars="0" viewpagebreaks="0" donotforceconnectorsbehindshapes="0" backpictureclsid="{00000000-0000-0000-0000-000000000000}"&gt;
&lt;font&gt;
&lt;ddsxmlobjectstreamwrapper binary="01010000900180380100065461686f6d61" /&gt;
&lt;/font&gt;
&lt;mouseicon&gt;
&lt;ddsxmlobjectstreamwrapper binary="6c74000000000000" /&gt;
&lt;/mouseicon&gt;
&lt;/diagram&gt;
&lt;layoutmanager&gt;
&lt;ddsxmlobj /&gt;
&lt;/layoutmanager&gt;
&lt;ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Executes a custom script." left="2209" top="3003" logicalid="5" controlid="1" masterid="0" hint1="0" hint2="0" width="3598" height="1164" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"&gt;
&lt;control&gt;
&lt;ddsxmlobjectstreaminitwrapper binary="000800000e0e00008c040000" /&gt;
&lt;/control&gt;
&lt;layoutobject&gt;
&lt;ddsxmlobj&gt;
&lt;property name="LogicalObject" value="{31B99051-27C6-4FB1-9178-B2E06C8EB11D}/components/1" vartype="8" /&gt;
&lt;property name="ShowConnectorSource" value="0" vartype="2" /&gt;
&lt;/ddsxmlobj&gt;
&lt;/layoutobject&gt;
&lt;shape groupshapeid="0" groupnode="0" /&gt;
&lt;/ddscontrol&gt;
&lt;ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Executes a custom script." left="2209" top="7660" logicalid="6" controlid="2" masterid="0" hint1="0" hint2="0" width="3598" height="1164" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"&gt;
&lt;control&gt;
&lt;ddsxmlobjectstreaminitwrapper binary="000800000e0e00008c040000" /&gt;
&lt;/control&gt;
&lt;layoutobject&gt;
&lt;ddsxmlobj&gt;
&lt;property name="LogicalObject" value="{31B99051-27C6-4FB1-9178-B2E06C8EB11D}/components/35" vartype="8" /&gt;
&lt;property name="ShowConnectorSource" value="0" vartype="2" /&gt;
&lt;/ddsxmlobj&gt;
&lt;/layoutobject&gt;
&lt;shape groupshapeid="0" groupnode="0" /&gt;
&lt;/ddscontrol&gt;
&lt;ddscontrol controlprogid="MSDDS.Polyline" left="3609" top="3768" logicalid="7" controlid="3" masterid="0" hint1="0" hint2="0" width="799" height="4392" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"&gt;
&lt;control&gt;
&lt;ddsxmlobj&gt;
&lt;polyline endtypedst="3" endtypesrc="1" usercolor="32768" linestyle="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1"&gt;
&lt;adornment percentpos="50" controlid="5" width="423" height="423" side="1" behavior="2" himetric="1746" distfromline="175" startobj="0" x="4183" y="5701" visible="1" allowoverlap="1" usepercent="1" /&gt;
&lt;/polyline&gt;
&lt;/ddsxmlobj&gt;
&lt;/control&gt;
&lt;layoutobject&gt;
&lt;ddsxmlobj&gt;
&lt;property name="LogicalObject" value="{31B99051-27C6-4FB1-9178-B2E06C8EB11D}/paths/47" vartype="8" /&gt;
&lt;property name="Virtual" value="0" vartype="11" /&gt;
&lt;property name="VisibleAP" value="0" vartype="3" /&gt;
&lt;/ddsxmlobj&gt;
&lt;/layoutobject&gt;
&lt;connector lineroutestyle="Microsoft.DataWarehouse.Layout.GraphLayout100" sourceid="1" destid="2" sourceattachpoint="7" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"&gt;
&lt;point x="4008" y="4167" /&gt;
&lt;point x="4008" y="7660" /&gt;
&lt;/connector&gt;
&lt;/ddscontrol&gt;
&lt;ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" left="4183" top="5701" logicalid="9" controlid="5" masterid="3" hint1="0" hint2="0" width="423" height="423" noresize="1" nomove="1" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="1" selectable="0" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="1" groupcollapsed="0" tabstop="0" visible="1" snaptogrid="0"&gt;
&lt;control&gt;
&lt;ddsxmlobjectstreaminitwrapper binary="00080000a7010000a7010000" /&gt;
&lt;/control&gt;
&lt;layoutobject&gt;
&lt;ddsxmlobj&gt;
&lt;property name="VisualizerAdornment" value="-1" vartype="11" /&gt;
&lt;/ddsxmlobj&gt;
&lt;/layoutobject&gt;
&lt;shape groupshapeid="0" groupnode="0" /&gt;
&lt;/ddscontrol&gt;
&lt;/dds&gt;&lt;/dwd:Layout&gt;&lt;/dwd:DtsDataFlowDiagram&gt;&lt;/TaskHost&gt;</DTS:Property>
<DTS:Property DTS:Name="Namespace">dts-designer-1.0</DTS:Property>
<DTS:Property DTS:Name="ObjectName">{31B99051-27C6-4FB1-9178-B2E06C8EB11D}</DTS:Property>
<DTS:Property DTS:Name="DTSID">{BF04574D-2792-4D41-A386-E93A2A6C818A}</DTS:Property>
<DTS:Property DTS:Name="Description"></DTS:Property>
<DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:PackageVariable>
<DTS:PackageVariable>
<DTS:Property DTS:Name="PackageVariableValue" DTS:DataType="8">&lt;PipelinePath xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"&gt;&lt;dwd:SourceName&gt;Dates&lt;/dwd:SourceName&gt;&lt;dwd:DestinationName&gt;Input 0&lt;/dwd:DestinationName&gt;&lt;/PipelinePath&gt;</DTS:Property>
<DTS:Property DTS:Name="Namespace">dts-designer-1.0</DTS:Property>
<DTS:Property DTS:Name="ObjectName">{31B99051-27C6-4FB1-9178-B2E06C8EB11D}-47</DTS:Property>
<DTS:Property DTS:Name="DTSID">{0B28AD73-36A6-4B67-AFCE-B69952A1803A}</DTS:Property>
<DTS:Property DTS:Name="Description"></DTS:Property>
<DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:PackageVariable>
<DTS:PackageVariable>
<DTS:Property DTS:Name="PackageVariableValue" DTS:DataType="8">&lt;Package xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"&gt;&lt;dwd:DtsControlFlowDiagram&gt;&lt;dwd:Layout&gt;&lt;dds&gt;
&lt;diagram fontclsid="{0BE35203-8F91-11CE-9DE3-00AA004BB851}" mouseiconclsid="{0BE35204-8F91-11CE-9DE3-00AA004BB851}" defaultlayout="Microsoft.DataWarehouse.Layout.GraphLayout100" defaultlineroute="Microsoft.DataWarehouse.Layout.GraphLayout100" version="7" nextobject="5" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="0" scrolltop="0" gridx="150" gridy="150" marginx="1000" marginy="1000" zoom="100" x="35745" y="23760" backcolor="15334399" defaultpersistence="2" PrintPageNumbersMode="3" PrintMarginTop="0" PrintMarginBottom="635" PrintMarginLeft="0" PrintMarginRight="0" marqueeselectionmode="1" mousepointer="0" snaptogrid="0" autotypeannotation="1" showscrollbars="0" viewpagebreaks="0" donotforceconnectorsbehindshapes="1" backpictureclsid="{00000000-0000-0000-0000-000000000000}"&gt;
&lt;font&gt;
&lt;ddsxmlobjectstreamwrapper binary="01010000900180380100065461686f6d61" /&gt;
&lt;/font&gt;
&lt;mouseicon&gt;
&lt;ddsxmlobjectstreamwrapper binary="6c74000000000000" /&gt;
&lt;/mouseicon&gt;
&lt;/diagram&gt;
&lt;layoutmanager&gt;
&lt;ddsxmlobj /&gt;
&lt;/layoutmanager&gt;
&lt;ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Data Flow Task" left="1000" top="1000" logicalid="2" controlid="1" masterid="0" hint1="0" hint2="0" width="3598" height="1164" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"&gt;
&lt;control&gt;
&lt;ddsxmlobjectstreaminitwrapper binary="000800000e0e00008c040000" /&gt;
&lt;/control&gt;
&lt;layoutobject&gt;
&lt;ddsxmlobj&gt;
&lt;property name="LogicalObject" value="{31B99051-27C6-4FB1-9178-B2E06C8EB11D}" vartype="8" /&gt;
&lt;property name="ShowConnectorSource" value="0" vartype="2" /&gt;
&lt;/ddsxmlobj&gt;
&lt;/layoutobject&gt;
&lt;shape groupshapeid="0" groupnode="0" /&gt;
&lt;/ddscontrol&gt;
&lt;/dds&gt;&lt;/dwd:Layout&gt;&lt;/dwd:DtsControlFlowDiagram&gt;&lt;/Package&gt;</DTS:Property>
<DTS:Property DTS:Name="Namespace">dts-designer-1.0</DTS:Property>
<DTS:Property DTS:Name="ObjectName">package-diagram</DTS:Property>
<DTS:Property DTS:Name="DTSID">{1F8E29F0-0632-4893-89ED-E9C61ABADE4A}</DTS:Property>
<DTS:Property DTS:Name="Description"></DTS:Property>
<DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:PackageVariable></DTS:Executable>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment