3
QSPAP\jberesford
QSP131
5/19/2009 1:56:48 PM
5
1
-1
0
1
0
8
{B8A734C4-30DB-4355-A62D-586CFA083F53}
0
0
0
0
-1
AdventureWorks 2008
{301DD6E0-8585-4DBB-9F66-0CED36FDDA8D}
Note DelayValidation is set to True
OLEDB
0
Data Source=WIN-KA5FODWD12A\SQL_2K8;Initial Catalog=AdventureWorks;Provider=SQLNCLI10.1;Integrated Security=SSPI;Auto Translate=False;Application Name=SSIS-Audit Transformation Basics 2008-{301DD6E0-8585-4DBB-9F66-0CED36FDDA8D}AdventureWorks 2008;
10.0.1600.22
0
0
-1
0
0
0
1
1048576
3081
1
0
0
User
0
0
6789
Trash
{A16E639B-B691-4AB3-B74F-0460DB896762}
0
1
0
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
0
0
-1
0
0
0
1
1048576
-1
1
0
0
1
1 > Audit Transformation
{719D2F4B-C8DA-4266-9F44-726B2935428F}
Demo of the Audit Transformation
SSIS.Pipeline.2
0
0
[HumanResources].[Employee]
SELECT Title
FROM HumanResources.Employee
1252
false
2
User::Trash
0
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
0
0
-1
0
0
0
1
1048576
-1
1
0
0
1
2 > Derived Column
{303F3714-3C02-4C05-B3EA-04E65D26E7B9}
Derived Column demonstration of same behaviour as Audit Transformation
SSIS.Pipeline.2
0
User::Trash
0
SELECT Title
FROM HumanResources.Employee
1252
false
2
Audit Transformation Basics 2008
{EC490F8F-9272-4F2F-BE73-340D4E6F61A9}
SSIS.Package.2
0
<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"><dwd:DtsDataFlowDiagram><dwd:BoundingLeft>-4762</dwd:BoundingLeft><dwd:BoundingTop>-5513</dwd:BoundingTop><dwd:Layout><dds>
<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="19" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="-5762" scrolltop="-6444" gridx="150" gridy="150" marginx="1000" marginy="1000" zoom="100" x="26353" y="11695" 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}">
<font>
<ddsxmlobjectstreamwrapper binary="01000000900144420100065461686f6d61" />
</font>
<mouseicon>
<ddsxmlobjectstreamwrapper binary="6c74000000000000" />
</mouseicon>
</diagram>
<layoutmanager>
<ddsxmlobj />
</layoutmanager>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Trash Destination" left="-4458" top="-53" logicalid="7" controlid="1" masterid="0" hint1="0" hint2="0" width="5742" 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">
<control>
<ddsxmlobjectstreaminitwrapper binary="000800006e1600008c040000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{303F3714-3C02-4C05-B3EA-04E65D26E7B9}/components/14" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="A Derived Column Transformation that replicates and improves on the functionality of the Audit Trans..." left="-4458" top="-2867" logicalid="8" controlid="2" masterid="0" hint1="0" hint2="0" width="5742" 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">
<control>
<ddsxmlobjectstreaminitwrapper binary="000800006e1600008c040000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{303F3714-3C02-4C05-B3EA-04E65D26E7B9}/components/41" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="OLE DB Source" left="-4458" top="-5513" logicalid="9" controlid="3" masterid="0" hint1="0" hint2="0" width="5742" 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">
<control>
<ddsxmlobjectstreaminitwrapper binary="000800006e1600008c040000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{303F3714-3C02-4C05-B3EA-04E65D26E7B9}/components/47" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Polyline" left="-1986" top="-4748" logicalid="10" controlid="4" masterid="0" hint1="0" hint2="0" width="799" height="2381" 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">
<control>
<ddsxmlobj>
<polyline endtypedst="3" endtypesrc="1" usercolor="32768" linestyle="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" />
</ddsxmlobj>
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{303F3714-3C02-4C05-B3EA-04E65D26E7B9}/paths/80" vartype="8" />
<property name="Virtual" value="0" vartype="11" />
<property name="VisibleAP" value="0" vartype="3" />
</ddsxmlobj>
</layoutobject>
<connector lineroutestyle="Microsoft.DataWarehouse.Layout.GraphLayout100" sourceid="3" destid="2" sourceattachpoint="11" destattachpoint="10" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
<point x="-1587" y="-4349" />
<point x="-1587" y="-2867" />
</connector>
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Polyline" left="-1986" top="-2102" logicalid="11" controlid="5" masterid="0" hint1="0" hint2="0" width="799" height="2549" 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">
<control>
<ddsxmlobj>
<polyline endtypedst="3" endtypesrc="1" usercolor="32768" linestyle="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" />
</ddsxmlobj>
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{303F3714-3C02-4C05-B3EA-04E65D26E7B9}/paths/81" vartype="8" />
<property name="Virtual" value="0" vartype="11" />
<property name="VisibleAP" value="0" vartype="3" />
</ddsxmlobj>
</layoutobject>
<connector lineroutestyle="Microsoft.DataWarehouse.Layout.GraphLayout100" sourceid="2" destid="1" sourceattachpoint="11" destattachpoint="10" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
<point x="-1587" y="-1703" />
<point x="-1587" y="-53" />
</connector>
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Text" left="2424" top="-2867" logicalid="12" controlid="6" masterid="0" hint1="0" hint2="0" width="9307" height="2293" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">
<control>
<ddsxmlobjectstreaminitwrapper binary="000200005b240000f50800000300640000000500008008000080000000002a0001000000900144420100065461686f6d61f600480065007200650020007700650020007200650070006c00690063006100740065002000740068006500200077006f0072006b0020006f006600200074006800650020004100750064006900740020005400720061006e00730066006f0072006d006100740069006f006e002000610073000d000a00640065006d006f006e007300740072006100740065006400200069006e0020007300740065007000200031002c0020006200790020006300720065006100740069006e006700200063006f006c0075006d006e0073002000770068006f00730065002000760061006c0075006500730020000d000a0061007200650020007300650074002000620079002000530079007300740065006d0020007600610072006900610062006c00650073002e000d000a000d000a0041006c0073006f0020006100200063006f006c0075006d006e0020006900730020006100640064006500640020006a00750073007400200074006f002000730068006f007700200074006800650020004400650072006900760065006400200043006f006c0075006d006e0020007400720061006e00730066006f0072006d006100740069006f006e000d000a00610064006400730020006700720065006100740065007200200066006c00650078006900620069006c006900740079002e0000000000" />
</control>
<layoutobject>
<ddsxmlobj />
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
</dds></dwd:Layout><dwd:PersistedViewPortLeft>-5762</dwd:PersistedViewPortLeft><dwd:PersistedViewPortTop>-6444</dwd:PersistedViewPortTop></dwd:DtsDataFlowDiagram><dwd:DtsComponentDesignerPropertiesList><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">47 DataSourceViewID</dwd:key></dwd:DtsComponentDesignTimeProperty></dwd:DtsComponentDesignerPropertiesList></TaskHost>
dts-designer-1.0
{303F3714-3C02-4C05-B3EA-04E65D26E7B9}
{6ADC1F9B-9656-48A7-BD18-36981DA2C4DC}
<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"><dwd:SourceName>OLE DB Source Output</dwd:SourceName><dwd:DestinationName>Derived Column Input</dwd:DestinationName></PipelinePath>
dts-designer-1.0
{303F3714-3C02-4C05-B3EA-04E65D26E7B9}-80
{14ED0BE8-D9B5-4BE7-A4E9-CFBC3715C959}
<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"><dwd:SourceName>Derived Column Output</dwd:SourceName><dwd:DestinationName>Recordset Destination Input</dwd:DestinationName></PipelinePath>
dts-designer-1.0
{303F3714-3C02-4C05-B3EA-04E65D26E7B9}-81
{1F8F8BDD-55FF-4848-933B-7B2D609269A9}
<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"><dwd:DtsDataFlowDiagram><dwd:Layout><dds>
<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="18" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="0" scrolltop="947" gridx="150" gridy="150" marginx="1000" marginy="1000" zoom="100" x="26353" y="11695" 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}">
<font>
<ddsxmlobjectstreamwrapper binary="01000000900144420100065461686f6d61" />
</font>
<mouseicon>
<ddsxmlobjectstreamwrapper binary="6c74000000000000" />
</mouseicon>
</diagram>
<layoutmanager>
<ddsxmlobj />
</layoutmanager>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="OLE DB Source" left="992" top="3016" logicalid="7" controlid="1" masterid="0" hint1="0" hint2="0" width="6059" 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">
<control>
<ddsxmlobjectstreaminitwrapper binary="00080000ab1700008c040000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{719D2F4B-C8DA-4266-9F44-726B2935428F}/components/1" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Adds audit information to rows in a dataset." left="992" top="5662" logicalid="8" controlid="2" masterid="0" hint1="0" hint2="0" width="6059" 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">
<control>
<ddsxmlobjectstreaminitwrapper binary="00080000ab1700008c040000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{719D2F4B-C8DA-4266-9F44-726B2935428F}/components/79" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Trash Destination" left="992" top="8229" logicalid="9" controlid="3" masterid="0" hint1="0" hint2="0" width="6059" 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">
<control>
<ddsxmlobjectstreaminitwrapper binary="00080000ab1700008c040000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{719D2F4B-C8DA-4266-9F44-726B2935428F}/components/82" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Polyline" left="3622" top="3781" logicalid="10" controlid="4" masterid="0" hint1="0" hint2="0" width="799" height="2381" 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">
<control>
<ddsxmlobj>
<polyline endtypedst="3" endtypesrc="1" usercolor="32768" linestyle="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" />
</ddsxmlobj>
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{719D2F4B-C8DA-4266-9F44-726B2935428F}/paths/85" vartype="8" />
<property name="Virtual" value="0" vartype="11" />
<property name="VisibleAP" value="0" vartype="3" />
</ddsxmlobj>
</layoutobject>
<connector lineroutestyle="Microsoft.DataWarehouse.Layout.GraphLayout100" sourceid="1" destid="2" sourceattachpoint="11" destattachpoint="10" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
<point x="4021" y="4180" />
<point x="4021" y="5662" />
</connector>
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Polyline" left="3622" top="6427" logicalid="11" controlid="5" masterid="0" hint1="0" hint2="0" width="799" height="2302" 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">
<control>
<ddsxmlobj>
<polyline endtypedst="3" endtypesrc="1" usercolor="32768" linestyle="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" />
</ddsxmlobj>
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{719D2F4B-C8DA-4266-9F44-726B2935428F}/paths/149" vartype="8" />
<property name="Virtual" value="0" vartype="11" />
<property name="VisibleAP" value="0" vartype="3" />
</ddsxmlobj>
</layoutobject>
<connector lineroutestyle="Microsoft.DataWarehouse.Layout.GraphLayout100" sourceid="2" destid="3" sourceattachpoint="11" destattachpoint="10" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0">
<point x="4021" y="6826" />
<point x="4021" y="8229" />
</connector>
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Text" left="8955" top="5662" logicalid="12" controlid="6" masterid="0" hint1="0" hint2="0" width="9149" height="1500" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">
<control>
<ddsxmlobjectstreaminitwrapper binary="00020000bd230000dc0500000300640000000500008008000080000000002a0001000000900144420100065461686f6d61780048006500720065002000770065002000750073006500200074006800650020004100750064006900740020005400720061006e00730066006f0072006d006100740069006f006e0020000d000a0074006f00200061006400640020004100750064006900740020006d006500740061006400610074006100200074006f00200074006800650020006400610074006100200066006c006f0077002c000d000a0069006e0063006c007500640069006e00670020006400750070006c00690063006100740069006e00670020006f006e00650020006f0066002000740068006500200063006f006c0075006d006e00730000000000" />
</control>
<layoutobject>
<ddsxmlobj />
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
</dds></dwd:Layout><dwd:PersistedViewPortTop>947</dwd:PersistedViewPortTop></dwd:DtsDataFlowDiagram><dwd:DtsComponentDesignerPropertiesList><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">1 DataSourceViewID</dwd:key></dwd:DtsComponentDesignTimeProperty><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">1 TableInfoObjectType</dwd:key><dwd:value xsi:type="xsd:string">Table</dwd:value></dwd:DtsComponentDesignTimeProperty></dwd:DtsComponentDesignerPropertiesList></TaskHost>
dts-designer-1.0
{719D2F4B-C8DA-4266-9F44-726B2935428F}
{85688F06-DD2D-4213-A704-A72E08A39A48}
<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"><dwd:SourceName>Audit Output 1</dwd:SourceName><dwd:DestinationName>Recordset Destination Input</dwd:DestinationName></PipelinePath>
dts-designer-1.0
{719D2F4B-C8DA-4266-9F44-726B2935428F}-149
{7A5D963C-7547-4F2C-8429-CC5431C7DF28}
<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"><dwd:SourceName>OLE DB Source Output</dwd:SourceName><dwd:DestinationName>Audit Input 1</dwd:DestinationName></PipelinePath>
dts-designer-1.0
{719D2F4B-C8DA-4266-9F44-726B2935428F}-85
{D379DF21-A6BF-46FF-9E54-AD0ECA1C7D8C}
<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"><dwd:DtsControlFlowDiagram><dwd:BoundingLeft>1000</dwd:BoundingLeft><dwd:BoundingTop>1000</dwd:BoundingTop><dwd:Layout><dds>
<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="12" 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="26353" y="12621" 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}">
<font>
<ddsxmlobjectstreamwrapper binary="01010000900180380100065461686f6d61" />
</font>
<mouseicon>
<ddsxmlobjectstreamwrapper binary="6c74000000000000" />
</mouseicon>
</diagram>
<layoutmanager>
<ddsxmlobj />
</layoutmanager>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Demo of the Audit Transformation" left="1000" top="3906" logicalid="5" controlid="1" masterid="0" hint1="0" hint2="0" width="6005" 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">
<control>
<ddsxmlobjectstreaminitwrapper binary="00080000751700008c040000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{719D2F4B-C8DA-4266-9F44-726B2935428F}" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Derived Column demonstration of same behaviour as Audit Transformation" left="1000" top="6207" logicalid="6" controlid="2" masterid="0" hint1="0" hint2="0" width="6032" 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">
<control>
<ddsxmlobjectstreaminitwrapper binary="00080000901700008c040000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{303F3714-3C02-4C05-B3EA-04E65D26E7B9}" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Text" left="1000" top="1000" logicalid="7" controlid="3" masterid="0" hint1="0" hint2="0" width="9333" height="864" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">
<control>
<ddsxmlobjectstreaminitwrapper binary="000200007524000060030000030064000000050000800000ff00000000002a0001000000bc02a42c0200065461686f6d611b004100750064006900740020005400720061006e00730066006f0072006d006100740069006f006e00200072006500760069006500770000000000" />
</control>
<layoutobject>
<ddsxmlobj />
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Text" left="1000" top="2138" logicalid="8" controlid="4" masterid="0" hint1="0" hint2="0" width="9043" height="627" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">
<control>
<ddsxmlobjectstreaminitwrapper binary="0002000053230000730200000300640000000500008008000080000000002a0001000000900144420100065461686f6d612f00430072006500610074006500640020006200790020004a0061006d006500730020004200650072006500730066006f0072006400200066006f00720020007700770077002e00620069006d006f006e006b00650079002e0063006f006d0000000000" />
</control>
<layoutobject>
<ddsxmlobj />
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
</dds></dwd:Layout></dwd:DtsControlFlowDiagram></Package>
dts-designer-1.0
{EC490F8F-9272-4F2F-BE73-340D4E6F61A9}
{9969D331-1735-4D60-839A-9E9BAC737CDD}
<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"><dwd:DtsControlFlowDiagram><dwd:BoundingLeft>1000</dwd:BoundingLeft><dwd:BoundingTop>1000</dwd:BoundingTop><dwd:Layout><dds>
<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="12" 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="26353" y="12621" 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}">
<font>
<ddsxmlobjectstreamwrapper binary="01010000900180380100065461686f6d61" />
</font>
<mouseicon>
<ddsxmlobjectstreamwrapper binary="6c74000000000000" />
</mouseicon>
</diagram>
<layoutmanager>
<ddsxmlobj />
</layoutmanager>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Demo of the Audit Transformation" left="1000" top="3906" logicalid="5" controlid="1" masterid="0" hint1="0" hint2="0" width="6005" 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">
<control>
<ddsxmlobjectstreaminitwrapper binary="00080000751700008c040000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{719D2F4B-C8DA-4266-9F44-726B2935428F}" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Derived Column demonstration of same behaviour as Audit Transformation" left="1000" top="6207" logicalid="6" controlid="2" masterid="0" hint1="0" hint2="0" width="6032" 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">
<control>
<ddsxmlobjectstreaminitwrapper binary="00080000901700008c040000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{303F3714-3C02-4C05-B3EA-04E65D26E7B9}" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Text" left="1000" top="1000" logicalid="7" controlid="3" masterid="0" hint1="0" hint2="0" width="9333" height="864" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">
<control>
<ddsxmlobjectstreaminitwrapper binary="000200007524000060030000030064000000050000800000ff00000000002a0001000000bc02a42c0200065461686f6d611b004100750064006900740020005400720061006e00730066006f0072006d006100740069006f006e00200072006500760069006500770000000000" />
</control>
<layoutobject>
<ddsxmlobj />
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Text" left="1000" top="2138" logicalid="8" controlid="4" masterid="0" hint1="0" hint2="0" width="9043" height="627" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">
<control>
<ddsxmlobjectstreaminitwrapper binary="0002000053230000730200000300640000000500008008000080000000002a0001000000900144420100065461686f6d612f00430072006500610074006500640020006200790020004a0061006d006500730020004200650072006500730066006f0072006400200066006f00720020007700770077002e00620069006d006f006e006b00650079002e0063006f006d0000000000" />
</control>
<layoutobject>
<ddsxmlobj />
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
</dds></dwd:Layout></dwd:DtsControlFlowDiagram></Package>
dts-designer-1.0
package-diagram
{F269D6FC-8175-4D4E-9A52-02642A250659}