I am trying to determine a way to pull documentation from a SSIS package.
The SSIS files are stored in a XML file. Below is how the Annotation is
stored in the file.
<AnnotationLayout
Text="This is a test of the Annotation function"
ParentId="Package\Extract Sample Currency Data"
FontInfo="{assembly:Null}"
Size="238,60"
Id="4e65a215-af3e-47ec-be51-666d2b1ef08e"
TopLeft="270,116" />
I have also attached the SSIS file so it is easier to review the
information included.
I would love to be able to include more than just the Annotation from the
dtsx file.
Any advice, hints or links would be greatly appreciated.
--
You received this message because you are subscribed to the Google Groups
"sphinx-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/sphinx-users/71a729b9-dd07-4aea-82cd-4a8d85ddb037n%40googlegroups.com.
<?xml version="1.0"?>
<DTS:Executable xmlns:DTS="www.microsoft.com/SqlServer/Dts"
DTS:refId="Package"
DTS:CreationDate="8/29/2005 1:15:48 PM"
DTS:CreationName="Microsoft.Package"
DTS:CreatorComputerName="ComputerName"
DTS:CreatorName="Domain\UserName"
DTS:DTSID="{25AA47FF-062F-45E6-B8BB-CE1508B24783}"
DTS:ExecutableType="Microsoft.Package"
DTS:LastModifiedProductVersion="16.0.845.0"
DTS:LocaleID="1033"
DTS:ObjectName="Lesson 1"
DTS:PackageType="5"
DTS:ProtectionLevel="0"
DTS:VersionBuild="24"
DTS:VersionGUID="{E671F67F-5EAA-43DD-8CA1-8E525D140A74}">
<DTS:Property
DTS:Name="PackageFormatVersion">8</DTS:Property>
<DTS:ConnectionManagers>
<DTS:ConnectionManager
DTS:refId="Package.ConnectionManagers[(local).AdventureWorksDW]"
DTS:CreationName="OLEDB"
DTS:DTSID="{213571C6-6A27-4571-A3DA-C853F6BC2B90}"
DTS:ObjectName="(local).AdventureWorksDW">
<DTS:ObjectData>
<DTS:ConnectionManager
DTS:ConnectRetryCount="1"
DTS:ConnectRetryInterval="5"
DTS:ConnectionString="Data Source=(local);Initial Catalog=AdventureWorksDW;Provider=SQLNCLI11;Integrated Security=SSPI;Auto Translate=False;" />
</DTS:ObjectData>
</DTS:ConnectionManager>
<DTS:ConnectionManager
DTS:refId="Package.ConnectionManagers[Sample Flat File Source Data]"
DTS:CreationName="FLATFILE"
DTS:DTSID="{EA76C836-FF8B-4E34-B273-81D4F67FCB3D}"
DTS:ObjectName="Sample Flat File Source Data">
<DTS:ObjectData>
<DTS:ConnectionManager
DTS:Format="Delimited"
DTS:LocaleID="1033"
DTS:HeaderRowDelimiter="_x000D__x000A_"
DTS:RowDelimiter=""
DTS:TextQualifier="_x003C_none_x003E_"
DTS:CodePage="1252"
DTS:ConnectionString="C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Tutorial\Creating a Simple ETL Package\Sample Data\SampleCurrencyData.txt">
<DTS:FlatFileColumns>
<DTS:FlatFileColumn
DTS:ColumnType="Delimited"
DTS:ColumnDelimiter="_x0009_"
DTS:DataType="4"
DTS:TextQualified="True"
DTS:ObjectName="AverageRate"
DTS:DTSID="{870A1FE4-9C7F-451A-8DCD-8860CF87287F}"
DTS:CreationName="" />
<DTS:FlatFileColumn
DTS:ColumnType="Delimited"
DTS:ColumnDelimiter="_x0009_"
DTS:MaximumWidth="3"
DTS:DataType="130"
DTS:TextQualified="True"
DTS:ObjectName="CurrencyID"
DTS:DTSID="{D1DE8F09-A37D-4B8D-ACE9-73C0EBD1A858}"
DTS:CreationName="" />
<DTS:FlatFileColumn
DTS:ColumnType="Delimited"
DTS:ColumnDelimiter="_x0009_"
DTS:DataType="135"
DTS:TextQualified="True"
DTS:ObjectName="CurrencyDate"
DTS:DTSID="{3AA5BD44-ACCE-4C1E-88F1-2FEFB570B5BC}"
DTS:CreationName="" />
<DTS:FlatFileColumn
DTS:ColumnType="Delimited"
DTS:ColumnDelimiter="_x000D__x000A_"
DTS:DataType="4"
DTS:TextQualified="True"
DTS:ObjectName="EndOfDayRate"
DTS:DTSID="{27D2671D-F333-40CB-B6CC-A3B8F8D58BAA}"
DTS:CreationName="" />
</DTS:FlatFileColumns>
</DTS:ConnectionManager>
</DTS:ObjectData>
</DTS:ConnectionManager>
</DTS:ConnectionManagers>
<DTS:Variables />
<DTS:Executables>
<DTS:Executable
DTS:refId="Package\Extract Sample Currency Data"
DTS:CreationName="Microsoft.Pipeline"
DTS:Description="Data Flow Task"
DTS:DTSID="{D415AC55-75EF-464D-84D1-4AA0A14A0A0B}"
DTS:ExecutableType="Microsoft.Pipeline"
DTS:LocaleID="-1"
DTS:ObjectName="Extract Sample Currency Data"
DTS:TaskContact="Performs high-performance data extraction, transformation and loading;Microsoft Corporation; Microsoft SQL Server v9; (C) 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1";>
<DTS:Variables />
<DTS:ObjectData>
<pipeline
BLOBTempStoragePath=""
bufferTempStoragePath=""
engineThreads="5"
version="1">
<components>
<component
refId="Package\Extract Sample Currency Data\Extract Sample Currency Data"
componentClassID="Microsoft.FlatFileSource"
contactInfo="Flat File Source;Microsoft Corporation;Microsoft SqlServer v9; (C) 2005 Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;1";
description="Flat File Source"
localeId="1033"
name="Extract Sample Currency Data"
usesDispositions="true"
version="1">
<properties>
<property
dataType="System.Boolean"
description="Specifies whether zero-length columns are treated as null."
name="RetainNulls">false</property>
<property
dataType="System.String"
description="Specifies the name of an output column containing the file name. If no name is specified, no output column containing the file name will be generated."
name="FileNameColumnName"></property>
</properties>
<connections>
<connection
refId="Package\Extract Sample Currency Data\Extract Sample Currency Data.Connections[FlatFileConnection]"
connectionManagerID="Package.ConnectionManagers[Sample Flat File Source Data]"
connectionManagerRefId="Package.ConnectionManagers[Sample Flat File Source Data]"
name="FlatFileConnection" />
</connections>
<outputs>
<output
refId="Package\Extract Sample Currency Data\Extract Sample Currency Data.Outputs[Flat File Source Output]"
name="Flat File Source Output">
<outputColumns>
<outputColumn
refId="Package\Extract Sample Currency Data\Extract Sample Currency Data.Outputs[Flat File Source Output].Columns[AverageRate]"
dataType="r4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Extract Sample Currency Data\Extract Sample Currency Data.Outputs[Flat File Source Output].ExternalColumns[AverageRate]"
lineageId="Package\Extract Sample Currency Data\Extract Sample Currency Data.Outputs[Flat File Source Output].Columns[AverageRate]"
name="AverageRate"
truncationRowDisposition="FailComponent">
<properties>
<property
dataType="System.Boolean"
description="Indicates whether the column uses the faster, locale-neutral parsing routines."
name="FastParse">false</property>
</properties>
</outputColumn>
<outputColumn
refId="Package\Extract Sample Currency Data\Extract Sample Currency Data.Outputs[Flat File Source Output].Columns[CurrencyID]"
dataType="wstr"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Extract Sample Currency Data\Extract Sample Currency Data.Outputs[Flat File Source Output].ExternalColumns[CurrencyID]"
length="3"
lineageId="Package\Extract Sample Currency Data\Extract Sample Currency Data.Outputs[Flat File Source Output].Columns[CurrencyID]"
name="CurrencyID"
truncationRowDisposition="FailComponent">
<properties>
<property
dataType="System.Boolean"
description="Indicates whether the column uses the faster, locale-neutral parsing routines."
name="FastParse">false</property>
</properties>
</outputColumn>
<outputColumn
refId="Package\Extract Sample Currency Data\Extract Sample Currency Data.Outputs[Flat File Source Output].Columns[CurrencyDate]"
dataType="dbTimeStamp"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Extract Sample Currency Data\Extract Sample Currency Data.Outputs[Flat File Source Output].ExternalColumns[CurrencyDate]"
lineageId="Package\Extract Sample Currency Data\Extract Sample Currency Data.Outputs[Flat File Source Output].Columns[CurrencyDate]"
name="CurrencyDate"
truncationRowDisposition="FailComponent">
<properties>
<property
dataType="System.Boolean"
description="Indicates whether the column uses the faster, locale-neutral parsing routines."
name="FastParse">false</property>
</properties>
</outputColumn>
<outputColumn
refId="Package\Extract Sample Currency Data\Extract Sample Currency Data.Outputs[Flat File Source Output].Columns[EndOfDayRate]"
dataType="r4"
errorOrTruncationOperation="Conversion"
errorRowDisposition="FailComponent"
externalMetadataColumnId="Package\Extract Sample Currency Data\Extract Sample Currency Data.Outputs[Flat File Source Output].ExternalColumns[EndOfDayRate]"
lineageId="Package\Extract Sample Currency Data\Extract Sample Currency Data.Outputs[Flat File Source Output].Columns[EndOfDayRate]"
name="EndOfDayRate"
truncationRowDisposition="FailComponent">
<properties>
<property
dataType="System.Boolean"
description="Indicates whether the column uses the faster, locale-neutral parsing routines."
name="FastParse">false</property>
</properties>
</outputColumn>
</outputColumns>
<externalMetadataColumns
isUsed="True">
<externalMetadataColumn
refId="Package\Extract Sample Currency Data\Extract Sample Currency Data.Outputs[Flat File Source Output].ExternalColumns[AverageRate]"
dataType="r4"
name="AverageRate" />
<externalMetadataColumn
refId="Package\Extract Sample Currency Data\Extract Sample Currency Data.Outputs[Flat File Source Output].ExternalColumns[CurrencyID]"
dataType="wstr"
length="3"
name="CurrencyID" />
<externalMetadataColumn
refId="Package\Extract Sample Currency Data\Extract Sample Currency Data.Outputs[Flat File Source Output].ExternalColumns[CurrencyDate]"
dataType="dbTimeStamp"
name="CurrencyDate" />
<externalMetadataColumn
refId="Package\Extract Sample Currency Data\Extract Sample Currency Data.Outputs[Flat File Source Output].ExternalColumns[EndOfDayRate]"
dataType="r4"
name="EndOfDayRate" />
</externalMetadataColumns>
</output>
<output
refId="Package\Extract Sample Currency Data\Extract Sample Currency Data.Outputs[Flat File Source Error Output]"
isErrorOut="true"
name="Flat File Source Error Output">
<outputColumns>
<outputColumn
refId="Package\Extract Sample Currency Data\Extract Sample Currency Data.Outputs[Flat File Source Error Output].Columns[Flat File Source Error Output Column]"
codePage="1252"
dataType="text"
description="Flat File Source Error Output Column"
lineageId="Package\Extract Sample Currency Data\Extract Sample Currency Data.Outputs[Flat File Source Error Output].Columns[Flat File Source Error Output Column]"
name="Flat File Source Error Output Column" />
<outputColumn
refId="Package\Extract Sample Currency Data\Extract Sample Currency Data.Outputs[Flat File Source Error Output].Columns[ErrorCode]"
dataType="i4"
lineageId="Package\Extract Sample Currency Data\Extract Sample Currency Data.Outputs[Flat File Source Error Output].Columns[ErrorCode]"
name="ErrorCode"
specialFlags="1" />
<outputColumn
refId="Package\Extract Sample Currency Data\Extract Sample Currency Data.Outputs[Flat File Source Error Output].Columns[ErrorColumn]"
dataType="i4"
lineageId="Package\Extract Sample Currency Data\Extract Sample Currency Data.Outputs[Flat File Source Error Output].Columns[ErrorColumn]"
name="ErrorColumn"
specialFlags="2" />
</outputColumns>
<externalMetadataColumns />
</output>
</outputs>
</component>
<component
refId="Package\Extract Sample Currency Data\Lookup CurrencyKey"
componentClassID="Microsoft.Lookup"
contactInfo="Lookup;Microsoft Corporation;Microsoft SqlServer v9; (C) 2005 Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;4";
description="Looks up values in a reference dataset by using exact matching."
name="Lookup CurrencyKey"
usesDispositions="true"
version="6">
<properties>
<property
dataType="System.String"
description="Specifies the SQL statement that generates the lookup table."
expressionType="Notify"
name="SqlCommand"
UITypeEditor="Microsoft.DataTransformationServices.Controls.ModalMultilineStringEditor">select * from (select * from [dbo].[DimCurrency]) as refTable
where [refTable].[CurrencyAlternateKey] = 'ARS'
OR
[refTable].[CurrencyAlternateKey] = 'AUD'
OR
[refTable].[CurrencyAlternateKey] = 'BRL'
OR
[refTable].[CurrencyAlternateKey] = 'CAD'
OR
[refTable].[CurrencyAlternateKey] = 'CNY'
OR
[refTable].[CurrencyAlternateKey] = 'DEM'
OR
[refTable].[CurrencyAlternateKey] = 'EUR'
OR
[refTable].[CurrencyAlternateKey] = 'FRF'
OR
[refTable].[CurrencyAlternateKey] = 'GBP'
OR
[refTable].[CurrencyAlternateKey] = 'JPY'
OR
[refTable].[CurrencyAlternateKey] = 'MXN'
OR
[refTable].[CurrencyAlternateKey] = 'SAR'
OR
[refTable].[CurrencyAlternateKey] = 'USD'
OR
[refTable].[CurrencyAlternateKey] = 'VEB'</property>
<property
dataType="System.String"
description="Specifies a SQL statement that uses parameters to generate the lookup table."
expressionType="Notify"
name="SqlCommandParam"
UITypeEditor="Microsoft.DataTransformationServices.Controls.ModalMultilineStringEditor">select * from (select * from [dbo].[DimCurrency]) as refTable
where [refTable].[CurrencyAlternateKey] = ?</property>
<property
dataType="System.Int32"
description="Specifies the cache type of the lookup table."
name="CacheType"
typeConverter="CacheType">0</property>
<property
dataType="System.Int32"
description="Maximum Memory Usage for Reference Cache on a 32 bit platform."
name="MaxMemoryUsage">25</property>
<property
dataType="System.Int64"
description="Maximum Memory Usage for Reference Cache on a 64 bit platform."
name="MaxMemoryUsage64">25</property>
<property
dataType="System.String"
description="Indicates whether to reference metadata in an XML format."
name="ReferenceMetadataXml"><referenceMetadata><referenceColumns><referenceColumn name="CurrencyKey" dataType="DT_I4" length="0" precision="0" scale="0" codePage="0"/><referenceColumn name="CurrencyAlternateKey" dataType="DT_WSTR" length="3" precision="0" scale="0" codePage="0"/><referenceColumn name="CurrencyName" dataType="DT_WSTR" length="50" precision="0" scale="0" codePage="0"/></referenceColumns></referenceMetadata></property>
<property
containsID="true"
dataType="System.String"
description="Specifies the list of lineage identifiers that map to the parameters that the SQL statement in the SQLCommand property uses. Entries in the list are separated by semicolons."
name="ParameterMap">#{Package\Extract Sample Currency Data\Extract Sample Currency Data.Outputs[Flat File Source Output].Columns[CurrencyID]};</property>
<property
dataType="System.Int32"
description="Specifies the column code page to use when code page information is unavailable from the data source."
name="DefaultCodePage">1252</property>
<property
dataType="System.Int32"
description="Specifies the type of connection used to access the reference dataset."
name="ConnectionType"
typeConverter="LookupConnectionType">0</property>
<property
dataType="System.Int32"
description="Specifies how the Lookup transformation handles rows without matching entries in the reference data set."
name="NoMatchBehavior"
typeConverter="LookupNoMatchBehavior">0</property>
<property
dataType="System.Int32"
description="Specifies the percentage of the cache that is allocated for rows with no matching entries in the reference dataset."
name="NoMatchCachePercentage">0</property>
<property
dataType="System.Boolean"
description="Determines whether duplicate keys in the reference data should be treated as errors when full cache mode is used."
name="TreatDuplicateKeysAsError">false</property>
</properties>
<connections>
<connection
refId="Package\Extract Sample Currency Data\Lookup CurrencyKey.Connections[OleDbConnection]"
connectionManagerID="Package.ConnectionManagers[(local).AdventureWorksDW]"
connectionManagerRefId="Package.ConnectionManagers[(local).AdventureWorksDW]"
description="Connection manager used to access lookup data."
name="OleDbConnection" />
</connections>
<inputs>
<input
refId="Package\Extract Sample Currency Data\Lookup CurrencyKey.Inputs[Lookup Input]"
name="Lookup Input">
<inputColumns>
<inputColumn
refId="Package\Extract Sample Currency Data\Lookup CurrencyKey.Inputs[Lookup Input].Columns[CurrencyID]"
cachedDataType="wstr"
cachedLength="3"
cachedName="CurrencyID"
lineageId="Package\Extract Sample Currency Data\Extract Sample Currency Data.Outputs[Flat File Source Output].Columns[CurrencyID]">
<properties>
<property
dataType="System.String"
description="Specifies the column in the reference table that a column joins."
name="JoinToReferenceColumn">CurrencyAlternateKey</property>
<property
dataType="System.Null"
description="Specifies the column in the reference table from which a column is copied."
name="CopyFromReferenceColumn" />
</properties>
</inputColumn>
</inputColumns>
<externalMetadataColumns />
</input>
</inputs>
<outputs>
<output
refId="Package\Extract Sample Currency Data\Lookup CurrencyKey.Outputs[Lookup Match Output]"
errorOrTruncationOperation="Lookup"
errorRowDisposition="FailComponent"
exclusionGroup="1"
name="Lookup Match Output"
synchronousInputId="Package\Extract Sample Currency Data\Lookup CurrencyKey.Inputs[Lookup Input]">
<outputColumns>
<outputColumn
refId="Package\Extract Sample Currency Data\Lookup CurrencyKey.Outputs[Lookup Match Output].Columns[CurrencyKey]"
dataType="i4"
errorOrTruncationOperation="Copy Column"
lineageId="Package\Extract Sample Currency Data\Lookup CurrencyKey.Outputs[Lookup Match Output].Columns[CurrencyKey]"
name="CurrencyKey"
truncationRowDisposition="FailComponent">
<properties>
<property
dataType="System.String"
description="Specifies the column in the reference table from which a column is copied."
name="CopyFromReferenceColumn">CurrencyKey</property>
</properties>
</outputColumn>
</outputColumns>
<externalMetadataColumns />
</output>
<output
refId="Package\Extract Sample Currency Data\Lookup CurrencyKey.Outputs[Lookup No Match Output]"
description="The Lookup output that handles rows with no matching entries in the reference dataset. Use this output when the NoMatchBehavior property is set to "Send rows with no matching entries to the no match output.""
exclusionGroup="1"
name="Lookup No Match Output"
synchronousInputId="Package\Extract Sample Currency Data\Lookup CurrencyKey.Inputs[Lookup Input]">
<externalMetadataColumns />
</output>
<output
refId="Package\Extract Sample Currency Data\Lookup CurrencyKey.Outputs[Lookup Error Output]"
exclusionGroup="1"
isErrorOut="true"
name="Lookup Error Output"
synchronousInputId="Package\Extract Sample Currency Data\Lookup CurrencyKey.Inputs[Lookup Input]">
<outputColumns>
<outputColumn
refId="Package\Extract Sample Currency Data\Lookup CurrencyKey.Outputs[Lookup Error Output].Columns[ErrorCode]"
dataType="i4"
lineageId="Package\Extract Sample Currency Data\Lookup CurrencyKey.Outputs[Lookup Error Output].Columns[ErrorCode]"
name="ErrorCode"
specialFlags="1" />
<outputColumn
refId="Package\Extract Sample Currency Data\Lookup CurrencyKey.Outputs[Lookup Error Output].Columns[ErrorColumn]"
dataType="i4"
lineageId="Package\Extract Sample Currency Data\Lookup CurrencyKey.Outputs[Lookup Error Output].Columns[ErrorColumn]"
name="ErrorColumn"
specialFlags="2" />
</outputColumns>
<externalMetadataColumns />
</output>
</outputs>
</component>
<component
refId="Package\Extract Sample Currency Data\Lookup DateKey"
componentClassID="Microsoft.Lookup"
contactInfo="Lookup;Microsoft Corporation;Microsoft SqlServer v9; (C) 2005 Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;4";
description="Looks up values in a reference dataset by using exact matching."
name="Lookup DateKey"
usesDispositions="true"
version="6">
<properties>
<property
dataType="System.String"
description="Specifies the SQL statement that generates the lookup table."
expressionType="Notify"
name="SqlCommand"
UITypeEditor="Microsoft.DataTransformationServices.Controls.ModalMultilineStringEditor">select * from [dbo].[DimTime]</property>
<property
dataType="System.String"
description="Specifies a SQL statement that uses parameters to generate the lookup table."
expressionType="Notify"
name="SqlCommandParam"
UITypeEditor="Microsoft.DataTransformationServices.Controls.ModalMultilineStringEditor">select * from (select * from [dbo].[DimTime]) as refTable
where [refTable].[FullDateAlternateKey] = ?</property>
<property
dataType="System.Int32"
description="Specifies the cache type of the lookup table."
name="CacheType"
typeConverter="CacheType">1</property>
<property
dataType="System.Int32"
description="Maximum Memory Usage for Reference Cache on a 32 bit platform."
name="MaxMemoryUsage">25</property>
<property
dataType="System.Int64"
description="Maximum Memory Usage for Reference Cache on a 64 bit platform."
name="MaxMemoryUsage64">25</property>
<property
dataType="System.String"
description="Indicates whether to reference metadata in an XML format."
name="ReferenceMetadataXml"><referenceMetadata><referenceColumns><referenceColumn name="TimeKey" dataType="DT_I4" length="0" precision="0" scale="0" codePage="0"/><referenceColumn name="FullDateAlternateKey" dataType="DT_DBTIMESTAMP" length="0" precision="0" scale="0" codePage="0"/><referenceColumn name="DayNumberOfWeek" dataType="DT_UI1" length="0" precision="0" scale="0" codePage="0"/><referenceColumn name="EnglishDayNameOfWeek" dataType="DT_WSTR" length="10" precision="0" scale="0" codePage="0"/><referenceColumn name="SpanishDayNameOfWeek" dataType="DT_WSTR" length="10" precision="0" scale="0" codePage="0"/><referenceColumn name="FrenchDayNameOfWeek" dataType="DT_WSTR" length="10" precision="0" scale="0" codePage="0"/><referenceColumn name="DayNumberOfMonth" dataType="DT_UI1" length="0" precision="0" scale="0" codePage="0"/><referenceColumn name="DayNumberOfYear" dataType="DT_I2" length="0" precision="0" scale="0" codePage="0"/><referenceColumn name="WeekNumberOfYear" dataType="DT_UI1" length="0" precision="0" scale="0" codePage="0"/><referenceColumn name="EnglishMonthName" dataType="DT_WSTR" length="10" precision="0" scale="0" codePage="0"/><referenceColumn name="SpanishMonthName" dataType="DT_WSTR" length="10" precision="0" scale="0" codePage="0"/><referenceColumn name="FrenchMonthName" dataType="DT_WSTR" length="10" precision="0" scale="0" codePage="0"/><referenceColumn name="MonthNumberOfYear" dataType="DT_UI1" length="0" precision="0" scale="0" codePage="0"/><referenceColumn name="CalendarQuarter" dataType="DT_UI1" length="0" precision="0" scale="0" codePage="0"/><referenceColumn name="CalendarYear" dataType="DT_STR" length="4" precision="0" scale="0" codePage="1252"/><referenceColumn name="CalendarSemester" dataType="DT_UI1" length="0" precision="0" scale="0" codePage="0"/><referenceColumn name="FiscalQuarter" dataType="DT_UI1" length="0" precision="0" scale="0" codePage="0"/><referenceColumn name="FiscalYear" dataType="DT_STR" length="4" precision="0" scale="0" codePage="1252"/><referenceColumn name="FiscalSemester" dataType="DT_UI1" length="0" precision="0" scale="0" codePage="0"/></referenceColumns></referenceMetadata></property>
<property
containsID="true"
dataType="System.String"
description="Specifies the list of lineage identifiers that map to the parameters that the SQL statement in the SQLCommand property uses. Entries in the list are separated by semicolons."
name="ParameterMap">#{Package\Extract Sample Currency Data\Extract Sample Currency Data.Outputs[Flat File Source Output].Columns[CurrencyDate]};</property>
<property
dataType="System.Int32"
description="Specifies the column code page to use when code page information is unavailable from the data source."
name="DefaultCodePage">1252</property>
<property
dataType="System.Int32"
description="Specifies the type of connection used to access the reference dataset."
name="ConnectionType"
typeConverter="LookupConnectionType">0</property>
<property
dataType="System.Int32"
description="Specifies how the Lookup transformation handles rows without matching entries in the reference data set."
name="NoMatchBehavior"
typeConverter="LookupNoMatchBehavior">0</property>
<property
dataType="System.Int32"
description="Specifies the percentage of the cache that is allocated for rows with no matching entries in the reference dataset."
name="NoMatchCachePercentage">0</property>
<property
dataType="System.Boolean"
description="Determines whether duplicate keys in the reference data should be treated as errors when full cache mode is used."
name="TreatDuplicateKeysAsError">false</property>
</properties>
<connections>
<connection
refId="Package\Extract Sample Currency Data\Lookup DateKey.Connections[OleDbConnection]"
connectionManagerID="Package.ConnectionManagers[(local).AdventureWorksDW]"
connectionManagerRefId="Package.ConnectionManagers[(local).AdventureWorksDW]"
description="Connection manager used to access lookup data."
name="OleDbConnection" />
</connections>
<inputs>
<input
refId="Package\Extract Sample Currency Data\Lookup DateKey.Inputs[Lookup Input]"
name="Lookup Input">
<inputColumns>
<inputColumn
refId="Package\Extract Sample Currency Data\Lookup DateKey.Inputs[Lookup Input].Columns[CurrencyDate]"
cachedDataType="dbTimeStamp"
cachedName="CurrencyDate"
lineageId="Package\Extract Sample Currency Data\Extract Sample Currency Data.Outputs[Flat File Source Output].Columns[CurrencyDate]">
<properties>
<property
dataType="System.String"
description="Specifies the column in the reference table that a column joins."
name="JoinToReferenceColumn">FullDateAlternateKey</property>
<property
dataType="System.Null"
description="Specifies the column in the reference table from which a column is copied."
name="CopyFromReferenceColumn" />
</properties>
</inputColumn>
</inputColumns>
<externalMetadataColumns />
</input>
</inputs>
<outputs>
<output
refId="Package\Extract Sample Currency Data\Lookup DateKey.Outputs[Lookup Match Output]"
errorOrTruncationOperation="Lookup"
errorRowDisposition="FailComponent"
exclusionGroup="1"
name="Lookup Match Output"
synchronousInputId="Package\Extract Sample Currency Data\Lookup DateKey.Inputs[Lookup Input]">
<outputColumns>
<outputColumn
refId="Package\Extract Sample Currency Data\Lookup DateKey.Outputs[Lookup Match Output].Columns[TimeKey]"
dataType="i4"
errorOrTruncationOperation="Copy Column"
lineageId="Package\Extract Sample Currency Data\Lookup DateKey.Outputs[Lookup Match Output].Columns[TimeKey]"
name="TimeKey"
truncationRowDisposition="FailComponent">
<properties>
<property
dataType="System.String"
description="Specifies the column in the reference table from which a column is copied."
name="CopyFromReferenceColumn">TimeKey</property>
</properties>
</outputColumn>
</outputColumns>
<externalMetadataColumns />
</output>
<output
refId="Package\Extract Sample Currency Data\Lookup DateKey.Outputs[Lookup No Match Output]"
description="The Lookup output that handles rows with no matching entries in the reference dataset. Use this output when the NoMatchBehavior property is set to "Send rows with no matching entries to the no match output.""
exclusionGroup="1"
name="Lookup No Match Output"
synchronousInputId="Package\Extract Sample Currency Data\Lookup DateKey.Inputs[Lookup Input]">
<externalMetadataColumns />
</output>
<output
refId="Package\Extract Sample Currency Data\Lookup DateKey.Outputs[Lookup Error Output]"
exclusionGroup="1"
isErrorOut="true"
name="Lookup Error Output"
synchronousInputId="Package\Extract Sample Currency Data\Lookup DateKey.Inputs[Lookup Input]">
<outputColumns>
<outputColumn
refId="Package\Extract Sample Currency Data\Lookup DateKey.Outputs[Lookup Error Output].Columns[ErrorCode]"
dataType="i4"
lineageId="Package\Extract Sample Currency Data\Lookup DateKey.Outputs[Lookup Error Output].Columns[ErrorCode]"
name="ErrorCode"
specialFlags="1" />
<outputColumn
refId="Package\Extract Sample Currency Data\Lookup DateKey.Outputs[Lookup Error Output].Columns[ErrorColumn]"
dataType="i4"
lineageId="Package\Extract Sample Currency Data\Lookup DateKey.Outputs[Lookup Error Output].Columns[ErrorColumn]"
name="ErrorColumn"
specialFlags="2" />
</outputColumns>
<externalMetadataColumns />
</output>
</outputs>
</component>
<component
refId="Package\Extract Sample Currency Data\Sample OLE DB Destination"
componentClassID="Microsoft.OLEDBDestination"
contactInfo="OLE DB Destination;Microsoft Corporation;Microsoft SqlServer v9; (C) 2005 Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;4";
description="OLE DB Destination"
name="Sample OLE DB Destination"
usesDispositions="true"
version="4">
<properties>
<property
dataType="System.Int32"
description="The number of seconds before a command times out. A value of 0 indicates an infinite time-out."
name="CommandTimeout">0</property>
<property
dataType="System.String"
description="Specifies the name of the database object used to open a rowset."
name="OpenRowset">[dbo].[FactCurrencyRate]</property>
<property
dataType="System.String"
description="Specifies the variable that contains the name of the database object used to open a rowset."
name="OpenRowsetVariable"></property>
<property
dataType="System.String"
description="The SQL command to be executed."
name="SqlCommand"
UITypeEditor="Microsoft.DataTransformationServices.Controls.ModalMultilineStringEditor"></property>
<property
dataType="System.Int32"
description="Specifies the column code page to use when code page information is unavailable from the data source."
name="DefaultCodePage">1252</property>
<property
dataType="System.Boolean"
description="Forces the use of the DefaultCodePage property value when describing character data."
name="AlwaysUseDefaultCodePage">false</property>
<property
dataType="System.Int32"
description="Specifies the mode used to access the database."
name="AccessMode"
typeConverter="AccessMode">3</property>
<property
dataType="System.Boolean"
description="Indicates whether the values supplied for identity columns will be copied to the destination. If false, values for identity columns will be auto-generated at the destination. Applies only if fast load is turned on."
name="FastLoadKeepIdentity">false</property>
<property
dataType="System.Boolean"
description="Indicates whether the columns containing null will have null inserted in the destination. If false, columns containing null will have their default values inserted at the destinaton. Applies only if fast load is turned on."
name="FastLoadKeepNulls">false</property>
<property
dataType="System.String"
description="Specifies options to be used with fast load. Applies only if fast load is turned on."
name="FastLoadOptions">TABLOCK,CHECK_CONSTRAINTS</property>
<property
dataType="System.Int32"
description="Specifies when commits are issued during data insertion. A value of 0 specifies that one commit will be issued at the end of data insertion. Applies only if fast load is turned on."
name="FastLoadMaxInsertCommitSize">0</property>
</properties>
<connections>
<connection
refId="Package\Extract Sample Currency Data\Sample OLE DB Destination.Connections[OleDbConnection]"
connectionManagerID="Package.ConnectionManagers[(local).AdventureWorksDW]"
connectionManagerRefId="Package.ConnectionManagers[(local).AdventureWorksDW]"
description="The OLE DB runtime connection used to access the database."
name="OleDbConnection" />
</connections>
<inputs>
<input
refId="Package\Extract Sample Currency Data\Sample OLE DB Destination.Inputs[OLE DB Destination Input]"
errorOrTruncationOperation="Insert"
errorRowDisposition="FailComponent"
hasSideEffects="true"
name="OLE DB Destination Input">
<inputColumns>
<inputColumn
refId="Package\Extract Sample Currency Data\Sample OLE DB Destination.Inputs[OLE DB Destination Input].Columns[AverageRate]"
cachedDataType="r4"
cachedName="AverageRate"
externalMetadataColumnId="Package\Extract Sample Currency Data\Sample OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[AverageRate]"
lineageId="Package\Extract Sample Currency Data\Extract Sample Currency Data.Outputs[Flat File Source Output].Columns[AverageRate]" />
<inputColumn
refId="Package\Extract Sample Currency Data\Sample OLE DB Destination.Inputs[OLE DB Destination Input].Columns[EndOfDayRate]"
cachedDataType="r4"
cachedName="EndOfDayRate"
externalMetadataColumnId="Package\Extract Sample Currency Data\Sample OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[EndOfDayRate]"
lineageId="Package\Extract Sample Currency Data\Extract Sample Currency Data.Outputs[Flat File Source Output].Columns[EndOfDayRate]" />
<inputColumn
refId="Package\Extract Sample Currency Data\Sample OLE DB Destination.Inputs[OLE DB Destination Input].Columns[CurrencyKey]"
cachedDataType="i4"
cachedName="CurrencyKey"
externalMetadataColumnId="Package\Extract Sample Currency Data\Sample OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[CurrencyKey]"
lineageId="Package\Extract Sample Currency Data\Lookup CurrencyKey.Outputs[Lookup Match Output].Columns[CurrencyKey]" />
<inputColumn
refId="Package\Extract Sample Currency Data\Sample OLE DB Destination.Inputs[OLE DB Destination Input].Columns[TimeKey]"
cachedDataType="i4"
cachedName="TimeKey"
externalMetadataColumnId="Package\Extract Sample Currency Data\Sample OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[TimeKey]"
lineageId="Package\Extract Sample Currency Data\Lookup DateKey.Outputs[Lookup Match Output].Columns[TimeKey]" />
</inputColumns>
<externalMetadataColumns
isUsed="True">
<externalMetadataColumn
refId="Package\Extract Sample Currency Data\Sample OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[CurrencyKey]"
dataType="i4"
name="CurrencyKey" />
<externalMetadataColumn
refId="Package\Extract Sample Currency Data\Sample OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[TimeKey]"
dataType="i4"
name="TimeKey" />
<externalMetadataColumn
refId="Package\Extract Sample Currency Data\Sample OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[AverageRate]"
dataType="r8"
name="AverageRate" />
<externalMetadataColumn
refId="Package\Extract Sample Currency Data\Sample OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[EndOfDayRate]"
dataType="r8"
name="EndOfDayRate" />
</externalMetadataColumns>
</input>
</inputs>
<outputs>
<output
refId="Package\Extract Sample Currency Data\Sample OLE DB Destination.Outputs[OLE DB Destination Error Output]"
exclusionGroup="1"
isErrorOut="true"
name="OLE DB Destination Error Output"
synchronousInputId="Package\Extract Sample Currency Data\Sample OLE DB Destination.Inputs[OLE DB Destination Input]">
<outputColumns>
<outputColumn
refId="Package\Extract Sample Currency Data\Sample OLE DB Destination.Outputs[OLE DB Destination Error Output].Columns[ErrorCode]"
dataType="i4"
lineageId="Package\Extract Sample Currency Data\Sample OLE DB Destination.Outputs[OLE DB Destination Error Output].Columns[ErrorCode]"
name="ErrorCode"
specialFlags="1" />
<outputColumn
refId="Package\Extract Sample Currency Data\Sample OLE DB Destination.Outputs[OLE DB Destination Error Output].Columns[ErrorColumn]"
dataType="i4"
lineageId="Package\Extract Sample Currency Data\Sample OLE DB Destination.Outputs[OLE DB Destination Error Output].Columns[ErrorColumn]"
name="ErrorColumn"
specialFlags="2" />
</outputColumns>
<externalMetadataColumns />
</output>
</outputs>
</component>
</components>
<paths>
<path
refId="Package\Extract Sample Currency Data.Paths[Flat File Source Output]"
endId="Package\Extract Sample Currency Data\Lookup CurrencyKey.Inputs[Lookup Input]"
name="Flat File Source Output"
startId="Package\Extract Sample Currency Data\Extract Sample Currency Data.Outputs[Flat File Source Output]" />
<path
refId="Package\Extract Sample Currency Data.Paths[Lookup Output]"
endId="Package\Extract Sample Currency Data\Lookup DateKey.Inputs[Lookup Input]"
name="Lookup Output"
startId="Package\Extract Sample Currency Data\Lookup CurrencyKey.Outputs[Lookup Match Output]" />
<path
refId="Package\Extract Sample Currency Data.Paths[Lookup Output1]"
endId="Package\Extract Sample Currency Data\Sample OLE DB Destination.Inputs[OLE DB Destination Input]"
name="Lookup Output"
startId="Package\Extract Sample Currency Data\Lookup DateKey.Outputs[Lookup Match Output]" />
</paths>
</pipeline>
</DTS:ObjectData>
</DTS:Executable>
</DTS:Executables>
<DTS:DesignTimeProperties><![CDATA[<?xml version="1.0"?>
<!--This CDATA section contains the layout information of the package. The section includes information such as (x,y) coordinates, width, and height.-->
<!--If you manually edit this section and make a mistake, you can delete it. -->
<!--The package will still be able to load normally but the previous layout information will be lost and the designer will automatically re-arrange the elements on the design surface.-->
<Objects
Version="8">
<!--Each node below will contain properties that do not affect runtime behavior.-->
<Package
design-time-name="Package">
<LayoutInfo>
<GraphLayout
Capacity="4" xmlns="clr-namespace:Microsoft.SqlServer.IntegrationServices.Designer.Model.Serialization;assembly=Microsoft.SqlServer.IntegrationServices.Graph">
<NodeLayout
Size="136,101"
Id="Package\Extract Sample Currency Data"
TopLeft="5.5,5.5" />
</GraphLayout>
</LayoutInfo>
</Package>
<TaskHost
design-time-name="Package\Extract Sample Currency Data">
<LayoutInfo>
<GraphLayout
Capacity="8" xmlns="clr-namespace:Microsoft.SqlServer.IntegrationServices.Designer.Model.Serialization;assembly=Microsoft.SqlServer.IntegrationServices.Graph" xmlns:mssgle="clr-namespace:Microsoft.SqlServer.Graph.LayoutEngine;assembly=Microsoft.SqlServer.Graph" xmlns:assembly="http://schemas.microsoft.com/winfx/2006/xaml"; xmlns:mssgm="clr-namespace:Microsoft.SqlServer.Graph.Model;assembly=Microsoft.SqlServer.Graph">
<NodeLayout
Size="136,44"
Id="Package\Extract Sample Currency Data\Sample OLE DB Destination"
TopLeft="5.5,232.141509433962" />
<NodeLayout
Size="136,44"
Id="Package\Extract Sample Currency Data\Lookup DateKey"
TopLeft="5.5,155.27358490566" />
<NodeLayout
Size="136,44"
Id="Package\Extract Sample Currency Data\Lookup CurrencyKey"
TopLeft="5.5,81.3867924528302" />
<NodeLayout
Size="136,44"
Id="Package\Extract Sample Currency Data\Extract Sample Currency Data"
TopLeft="5.5,5.5" />
<EdgeLayout
Id="Package\Extract Sample Currency Data.Paths[Lookup Output1]"
TopLeft="73.3867924528302,199.198113207547">
<EdgeLayout.Curve>
<mssgle:Curve
StartConnector="{assembly:Null}"
EndConnector="0,32.9433962264151"
Start="0,0"
End="0,25.4433962264151">
<mssgle:Curve.Segments>
<mssgle:SegmentCollection
Capacity="5">
<mssgle:LineSegment
End="0,25.4433962264151" />
</mssgle:SegmentCollection>
</mssgle:Curve.Segments>
</mssgle:Curve>
</EdgeLayout.Curve>
<EdgeLayout.Labels>
<mssgm:EdgeLabel
BoundingBox="-48.19138671875,6.91701061320754,96.3827734375,11.609375"
RelativePosition="Any" />
</EdgeLayout.Labels>
</EdgeLayout>
<EdgeLayout
Id="Package\Extract Sample Currency Data.Paths[Lookup Output]"
TopLeft="73.3867924528302,125.311320754717">
<EdgeLayout.Curve>
<mssgle:Curve
StartConnector="{assembly:Null}"
EndConnector="0,29.9622641509434"
Start="0,0"
End="0,22.4622641509434">
<mssgle:Curve.Segments>
<mssgle:SegmentCollection
Capacity="5">
<mssgle:LineSegment
End="0,22.4622641509434" />
</mssgle:SegmentCollection>
</mssgle:Curve.Segments>
</mssgle:Curve>
</EdgeLayout.Curve>
<EdgeLayout.Labels>
<mssgm:EdgeLabel
BoundingBox="-48.19138671875,5.42644457547169,96.3827734375,11.609375"
RelativePosition="Any" />
</EdgeLayout.Labels>
</EdgeLayout>
<EdgeLayout
Id="Package\Extract Sample Currency Data.Paths[Flat File Source Output]"
TopLeft="73.3867924528302,49.4245283018868">
<EdgeLayout.Curve>
<mssgle:Curve
StartConnector="{assembly:Null}"
EndConnector="0,31.9622641509434"
Start="0,0"
End="0,24.4622641509434">
<mssgle:Curve.Segments>
<mssgle:SegmentCollection
Capacity="5">
<mssgle:LineSegment
End="0,24.4622641509434" />
</mssgle:SegmentCollection>
</mssgle:Curve.Segments>
</mssgle:Curve>
</EdgeLayout.Curve>
<EdgeLayout.Labels>
<EdgeLabelCollection />
</EdgeLayout.Labels>
</EdgeLayout>
<AnnotationLayout
Text="This is a test of the Annotation function"
ParentId="Package\Extract Sample Currency Data"
FontInfo="{assembly:Null}"
Size="238,60"
Id="4e65a215-af3e-47ec-be51-666d2b1ef08e"
TopLeft="270,116" />
</GraphLayout>
</LayoutInfo>
</TaskHost>
</Objects>]]></DTS:DesignTimeProperties>
</DTS:Executable>
