3 WIN-KA5FODWD12A\Administrator WIN-KA5FODWD12A 4/29/2009 8:34:03 AM 5 0 -1 0 1 0 15 {191E6AD1-1CEE-4E3F-A89B-8FA6B1077604} 0 0 0 0 0 ADO .NET AdventureWorks2008 {1EDCB480-97FE-44EB-B2FB-F7671550411F} ADO.NET:System.Data.SqlClient.SqlConnection, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 0 Data Source=WIN-KA5FODWD12A\SQL_2K8;Initial Catalog=AdventureWorks2008;Integrated Security=True;Application Name=SSIS-Package1-{1EDCB480-97FE-44EB-B2FB-F7671550411F}WIN-KA5FODWD12A\SQL_2K8.AdventureWorks20081; 0 OLE DB AdventureWorks2008 {E882180D-F298-4541-A4B2-D353F2211F52} OLEDB 0 Data Source=WIN-KA5FODWD12A\SQL_2K8;Initial Catalog=AdventureWorks2008;Provider=SQLNCLI10.1;Integrated Security=SSPI;Application Name=SSIS-ADO NET Source Component Basics-{E882180D-F298-4541-A4B2-D353F2211F52}WIN-KA5FODWD12A\SQL_2K8.AdventureWorks2008;Auto Translate=False; 10.0.1600.22 0 0 -1 0 0 0 1 1048576 3081 1 0 0 1 0 Performs high-performance data extraction, transformation and loading;Microsoft Corporation; Microsoft SQL Server v10; (C) 2007 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 OLE DB vs ADO NET performance comparison - ADO NET {C11B3B41-4952-4BE0-9171-81429A73C055} Moving records from a SQL Server source using ADO NET source SSIS.Pipeline.2 0 30 true "Sales"."SalesOrderDetail" 0 Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter, Microsoft.SqlServer.ADONETSrc, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91

0 C:\BIMonkeySamples\rawfile 0 0 0 0 -1 0 0 0 1 1048576 -1 1 0 0 1 Use Script Task to query a database {684C4F22-12A5-4753-93E6-10E284622785} This Script Task uses an ADO .NET connection to execute a query against a relational database Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTask, Microsoft.SqlServer.ScriptTask, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 0 'The following GUID is for the ID of the typelib if this project is exposed to COM ' 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 Build and Revision Numbers ' by using the '*' as shown below: ' ]]> ]]> ' This code was generated by a tool. ' ' Changes to this file may cause incorrect behavior and will be lost if ' the code is regenerated. ' '------------------------------------------------------------------------------ Option Strict Off Option Explicit On Namespace My.Resources '''

''' A strongly-typed resource class, for looking up localized strings, etc. '''

'This class was auto-generated by the Strongly Typed Resource Builder 'class via a tool like ResGen or Visual Studio.NET. 'To add or remove a member, edit your .ResX file then rerun ResGen 'with the /str option, or rebuild your VS project. Class MyResources Private Shared _resMgr As System.Resources.ResourceManager Private Shared _resCulture As System.Globalization.CultureInfo Friend Sub New() MyBase.New End Sub '''

''' Returns the cached ResourceManager instance used by this class. '''

_ Public Shared ReadOnly Property ResourceManager() As System.Resources.ResourceManager Get If (_resMgr Is Nothing) Then Dim temp As System.Resources.ResourceManager = New System.Resources.ResourceManager("My.Resources.MyResources", GetType(MyResources).Assembly) _resMgr = temp End If Return _resMgr End Get End Property '''

''' Overrides the current thread's CurrentUICulture property for all ''' resource lookups using this strongly typed resource class. '''

_ Public Shared Property Culture() As System.Globalization.CultureInfo Get Return _resCulture End Get Set _resCulture = value End Set End Property End Class End Namespace]]> _ _ Partial Public Class ScriptMain Inherits Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTARTScriptObjectModelBase Enum ScriptResults Success = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Success Failure = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Failure End Enum Dim sqlConn As SqlClient.SqlConnection ' Object to hold connection Dim sqlCmd As SqlCommand ' SQL Command object Dim rdrReader As SqlDataReader ' Data reader to hold output of command Dim sqlCmdText As String ' SQL Command text Public Sub Main() ' Opening the connection manager for use - for more detail see MSDN at: ' http://msdn.microsoft.com/en-us/library/ms136018.aspx sqlConn = DirectCast(Dts.Connections("ADO .NET AdventureWorks2008").AcquireConnection(Dts.Transaction), SqlClient.SqlConnection) ' Set the command text sqlCmdText = "SELECT COUNT(*) FROM [Person].[Address]" ' Execute the command and put the results into the data reader sqlCmd = New SqlCommand(sqlCmdText, sqlConn) rdrReader = sqlCmd.ExecuteReader() ' Take the data item in the reader and show it in a message box rdrReader.Read() MsgBox(rdrReader.Item(0), , "The [Person].[Address] table contains this many rows:") rdrReader.Close() Dts.TaskResult = ScriptResults.Success End Sub End Class]]> text/microsoft-resx 2.0 System.Resources.ResXResourceReader, System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.Resources.ResXResourceWriter, System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 ]]> ' This code was generated by a tool. ' ' Changes to this file may cause incorrect behavior and will be lost if ' the code is regenerated. ' '------------------------------------------------------------------------------ Option Strict Off Option Explicit On Partial Friend NotInheritable Class MySettings Inherits System.Configuration.ApplicationSettingsBase Private Shared m_Value As MySettings Private Shared m_SyncObject As Object = New Object _ Public Shared ReadOnly Property Value() As MySettings Get If (MySettings.m_Value Is Nothing) Then System.Threading.Monitor.Enter(MySettings.m_SyncObject) If (MySettings.m_Value Is Nothing) Then Try MySettings.m_Value = New MySettings Finally System.Threading.Monitor.Exit(MySettings.m_SyncObject) End Try End If End If Return MySettings.m_Value End Get End Property End Class]]> {A860303F-1F3F-4691-B57E-529FC101A107};{F184B08F-C81C-45F6-A57F-5ABD9991F28F} Debug AnyCPU Library ST_bbeefab75b6744c29d483ca8bf579ae6.vbproj ST_bbeefab75b6744c29d483ca8bf579ae6.vbproj On Binary Off On {9236AEF6-9319-42BD-A9BC-F2CDA8D178E3} true true true false bin\ false false 42016,42017,42018,42019,42032 false true false true bin\ false false 42016,42017,42018,42019,42032 Code VbMyResourcesResXFileCodeGenerator Resources.Designer.vb My.Resources True True Resources.resx Code SettingsSingleFileGenerator Settings.Designer.vb True Settings.settings Code Code SSIS_ScriptTask ]]>TVqQAAMAAAAEAAAA//8AALgAAAAAAAAAQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAgAAAAA4fug4AtAnNIbgBTM0hVGhpcyBwcm9ncmFtIGNhbm5vdCBiZSBydW4gaW4gRE9TIG1v ZGUuDQ0KJAAAAAAAAABQRQAATAEDABC//0kAAAAAAAAAAOAAAiELAQgAABwAAAAMAAAAAAAA7jsA AAAgAAAAQAAAAABAAAAgAAAAAgAABAAAAAAAAAAEAAAAAAAAAACAAAAAAgAAAAAAAAIAQIUAABAA ABAAAAAAEAAAEAAAAAAAABAAAAAAAAAAAAAAAJg7AABTAAAAAEAAABAJAAAAAAAAAAAAAAAAAAAA AAAAAGAAAAwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAIAAACAAAAAAAAAAAAAAACCAAAEgAAAAAAAAAAAAAAC50ZXh0AAAA9BsAAAAgAAAAHAAAAAIA AAAAAAAAAAAAAAAAACAAAGAucnNyYwAAABAJAAAAQAAAAAoAAAAeAAAAAAAAAAAAAAAAAABAAABA LnJlbG9jAAAMAAAAAGAAAAACAAAAKAAAAAAAAAAAAAAAAAAAQAAAQgAAAAAAAAAAAAAAAAAAAADQ OwAAAAAAAEgAAAACAAUAICQAAHgXAAABAAAAAAAAAFAgAAC4AAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAALQAAADOyu++AQAAAJEAAABsU3lzdGVtLlJlc291cmNlcy5S ZXNvdXJjZVJlYWRlciwgbXNjb3JsaWIsIFZlcnNpb249Mi4wLjAuMCwgQ3VsdHVyZT1uZXV0cmFs LCBQdWJsaWNLZXlUb2tlbj1iNzdhNWM1NjE5MzRlMDg5I1N5c3RlbS5SZXNvdXJjZXMuUnVudGlt ZVJlc291cmNlU2V0AgAAAAAAAAAAAAAAUEFEUEFEULQAAAAeAigBAAAKKh4CKAQAAAoqpnMGAAAK gAEAAARzBwAACoACAAAEcwgAAAqAAwAABHMJAAAKgAQAAAQqAAATMAEACwAAAAEAABF+AQAABG8K AAAKKgATMAEACwAAAAIAABF+AgAABG8LAAAKKgATMAEACwAAAAMAABF+AwAABG8MAAAKKgATMAEA CwAAAAQAABF+BAAABG8NAAAKKgATMAIADQAAAAUAABECAygRAAAKKBIAAAoqAAAAEzABAAcAAAAG AAARAigTAAAKKgATMAEACwAAAAcAABHQBQAAAigUAAAKKgATMAEABwAAAAgAABECKBUAAAoqABMw AQAQAAAACQAAEQKMAQAAGy0GKAEAACsqAioTMAIAEAAAAAoAABEDEgD+FQIAABsGgQIAABsqHgIo FwAACioTMAIAKAAAAAsAABECexkAAApvGgAACgsHjAMAABstEigCAAArCwJ7GQAACgdvGwAACgcq SgIoFwAACgJzHAAACn0ZAAAKKgAeAigXAAAKKhMwAgAtAAAADAAAEX4GAAAELSByAQAAcNAHAAAC KBQAAApvHgAACnMfAAAKCweABgAABH4GAAAEKgAAABMwAQAGAAAADQAAEX4HAAAEKgAAHgKABwAA BCpCcxcAAAooEQAACoAJAAAEKgAAAB4CKCAAAAoqGzABAD8AAAAOAAARfggAAAQtMn4JAAAEKBEA AAooIQAACn4IAAAELRxzFgAABoAIAAAE3hB+CQAABCgRAAAKKCIAAArcfggAAAQqAAEMAAACAB0A DCkAEAAAAAEeAigkAAAKKhMwAwCpAAAAAAAAAAICbyUAAApvJgAACnIzAABwbycAAAoCbyUAAApv KAAACigRAAAKbykAAAp0CwAAAX0KAAAEAnJrAABwfQ0AAAQCAnsNAAAEAnsKAAAEcyoAAAp9CwAA BAICewsAAARvKwAACn0MAAAEAnsMAAAEbywAAAomAnsMAAAEFm8tAAAKKBEAAAoWcrsAAHAoLgAA CiYCewwAAARvLwAACgJvJQAAChZvMAAACioAAABCU0pCAQABAAAAAAAMAAAAdjIuMC41MDcyNwAA AAAFAGwAAAAgCAAAI34AAIwIAAAACgAAI1N0cmluZ3MAAAAAjBIAACgBAAAjVVMAtBMAABAAAAAj R1VJRAAAAMQTAAC0AwAAI0Jsb2IAAAAAAAAAAgAAAVcdogkJDwAAAPoBMwAWAAABAAAALwAAAAoA AAAQAAAAGQAAAAQAAAA8AAAAAgAAADUAAAAOAAAABAAAAAgAAAAJAAAACQAAAAEAAAAHAAAAAQAA AAMAAAADAAAAAgAAAAAAzwkBAAAAAAAKAGABNgEKAJQBdgEGAKQBnQEKAPwBNgEGAHoCnQEKAPwC 0gIGADIDIQMGAF8DSgMOAMYDsQMSAEUEHAQWAIMEbQQWAJkEbQQWAKsEbQQGANMEnQEOAAYF8AQO AB8F8AQOAEwFNAUGAHYFYwUKALUFjgUKAM0FEwAOAAIG5QUGADcGFwYGAFUGnQEGAHkGnQEKAJIG EwAGANYGtwYGAPwG6gYGACMHEgcGADYHYwUSAFMHHAQaAKwHjAcaAMgHjAcKABgIEwAKACQIEwAK ADEIEwAGAFkInQEeAHwIbwgGAMoIFwYGAOoIFwYGAAgJ6gYGACUJtwYGADMJ6gYGAE4J6gYGAGkJ 6gYGAIIJ6gYGAJsJ6gYGALgJ6gYAAAAAAQAAAAAAAQABAAAAAAApADcABQABAAEAAAAAAGUANwAJ AAEAAgAAARAAcAA3AA0AAQADAAUBAAB6AAAADQAFAAgABQEAAIgAAAANAAUADwAAAAAAowCvAA0A BgARAAABEADnAPIAJQAIABUAAQAAAB0B8gApAAoAGAACAQAAKAEAADkADgAaADEAvwEgADEA6AEt ADEACgI6ADEALwJHACEACwOQABEAQgOdABEAawOhABEA3gO/ABEA5gPDAAEAkQTZAAEApATdAAEA uQThAAEAwwTlAAYG2AToAFaA4ATrAFaA6ATrAAghAAAAAAYYcAETAAEAECEAAAAABhhwARMAAQAY IQAAAAARGKsBFwABAEQhAAAAABMIsgEbAAEAXCEAAAAAEwjYASgAAQB0IQAAAAATCAECNQABAIwh AAAAABMIHwJCAAEApCEAAAAARgJlAmMAAQDAIQAAAABGAm4CaAACANQhAAAAAIMAfwJsAAIA7CEA AAAARgKHAnEAAgAAIgAAAAARAJACeAACABwiAAAAAAEArgKAAAMAOCIAAAAABhhwARMABABAIgAA AAADCMICiwAEAHQiAAAAAAYYcAETAAQAiCIAAAAAAxhwARMABACQIgAAAAAWCHcDpQAEAMwiAAAA ABYIiwOqAAQA4CIAAAAAFgiXA68ABADoIgAAAAARGKsBFwAFAPwiAAAAAAYYcAETAAUABCMAAAAA FgjzA8YABQBgIwAAAAAGGHABEwAFAGgjAAAAAAYAzgQTAAUAAAABAGwCAAABAKUCAAABAKUCAAAB AKMDCQBwARMAeQBwAfkAiQBwAQgBEQBwARMAkQBwARMAJABwARMALABwARMANABwARMAPABwARMA JADCAosALADCAosANADCAosAPADCAosAmQBwARMAoQBwARMAqQBwAVYBsQBGBqEBGQBlAmMAGQBu AmgAKQBnBq4BGQCHAnEAwQCDBr4BGQBwARMAyQBwAc4BRAALA5AATADzA4sATACtBksCTABwARMA 0QBwAVgCKQAFB2MCOQBwAWgCSQBwARMA4QArB4QC4QAxB4QC6QBwARMAUQBwARMAUQBlB44C8QC4 B5MC+QDaB5gC8QDjB58CAQHzB6MCYQBwAagCYQAFCK8CaQATCLQCaQDaB7gCCQE9CL0CaQBECBMA 8QBKCMgCIQFwAVgCKQFwAVYBMQFwAcgCOQFwARMAQQFwAVYBSQFwAVYBUQFwAVYBWQFwAVYBYQFw AVYBaQFwAVYBcQFwAVYBeQFwAVYBCAA8AO8ACABAAPQAKQCDAFsBLgDTAV0CLgCrAS8DLgDLAYMD LgDjAYMDLgDbAV0CLgCbAQcDLgCjARADLgCzATwDLgDrAF0CLgCLAWYDLgC7AV0CLgDDAWwDQAAT AP8AQAArAPQAQwATAP8AQwAbAA4BSQCDAHkBYwATAP8AYwAbAA4BaQCDAGwBgAArAPQAgwBzAPQA gwAbAA4BgwB7APQAiQCDAI0BoAArAPQAowATAP8AowDDANYBwAArAPQAwwDrAF0CwwATAP8AyQAT AHsC4AArAPQA6QATAHsCAAETAP8AAAErAPQACQEbAfQAIAETAP8AIAErAPQAIwGLAV0CIwGTAc0C QAErAPQAQAETAP8AYAErAPQAYAETAP8AgAErAPQAoAErAPQAwAErAPQAwAETAP8A4AErAPQAAAIT AP8AAAIrAPQAQgFHAUwBUQGmAaoBtQG6AckByQFRAm8CdgKJAgQAAQAGAAUABwAGAAgACAAAAJQB TwAAAE0CVAAAAPwBWQAAAFkCXgAAABUDmAAAADIDtQAAAKkDugAAAKMDywACAAQAAwACAAUABQAC AAYABwACAAcACQACAA8ACwACABIADQACABMADwABABQADwACABcAEQB1AHUAiAAmAS0BNAE7ATgC PwIEgAAAAQAAAAAAAAAAAAAAAADyAAAAAgAAAAAAAAAAAAAAAQAKAAAAAAAIAAAAAAAAAAAAAAAK ABMAAAAAAAIAAAAAAAAAAAAAAAEAnQEAAAAACgAAAAAAAAAAAAAA0AD9AwAAAAACAAAAAAAAAAAA AAABAGEEAAAAAAoAAAAAAAAAAAAAANAAbQcAAAAAAwAFAAAAAAAAAAAAAQBvCAAAAAAAAAAAAQAA AIsIAAAFAAQABgAEAAoACQAAABAADACjAgAAEAAZAKMCAAAAABsAowItAMQBLQBGAgAAADxNb2R1 bGU+AG1zY29ybGliAE1pY3Jvc29mdC5WaXN1YWxCYXNpYwBNeUFwcGxpY2F0aW9uAFNUX2JiZWVm YWI3NWI2NzQ0YzI5ZDQ4M2NhOGJmNTc5YWU2LnZicHJvai5NeQBNeUNvbXB1dGVyAE15UHJvamVj dABNeVdlYlNlcnZpY2VzAFRocmVhZFNhZmVPYmplY3RQcm92aWRlcmAxAE15UmVzb3VyY2VzAFNU X2JiZWVmYWI3NWI2NzQ0YzI5ZDQ4M2NhOGJmNTc5YWU2LnZicHJvai5NeS5SZXNvdXJjZXMATXlT ZXR0aW5ncwBTVF9iYmVlZmFiNzViNjc0NGMyOWQ0ODNjYThiZjU3OWFlNi52YnByb2oAU2NyaXB0 TWFpbgBTY3JpcHRSZXN1bHRzAE1pY3Jvc29mdC5WaXN1YWxCYXNpYy5BcHBsaWNhdGlvblNlcnZp Y2VzAEFwcGxpY2F0aW9uQmFzZQAuY3RvcgBNaWNyb3NvZnQuVmlzdWFsQmFzaWMuRGV2aWNlcwBD b21wdXRlcgBTeXN0ZW0AT2JqZWN0AC5jY3RvcgBnZXRfQ29tcHV0ZXIAbV9Db21wdXRlck9iamVj dFByb3ZpZGVyAGdldF9BcHBsaWNhdGlvbgBtX0FwcE9iamVjdFByb3ZpZGVyAFVzZXIAZ2V0X1Vz ZXIAbV9Vc2VyT2JqZWN0UHJvdmlkZXIAZ2V0X1dlYlNlcnZpY2VzAG1fTXlXZWJTZXJ2aWNlc09i amVjdFByb3ZpZGVyAEFwcGxpY2F0aW9uAFdlYlNlcnZpY2VzAEVxdWFscwBvAEdldEhhc2hDb2Rl AFR5cGUAR2V0VHlwZQBUb1N0cmluZwBDcmVhdGVfX0luc3RhbmNlX18AVABpbnN0YW5jZQBEaXNw b3NlX19JbnN0YW5jZV9fAGdldF9HZXRJbnN0YW5jZQBNaWNyb3NvZnQuVmlzdWFsQmFzaWMuTXlT ZXJ2aWNlcy5JbnRlcm5hbABDb250ZXh0VmFsdWVgMQBtX0NvbnRleHQAR2V0SW5zdGFuY2UAU3lz dGVtLlJlc291cmNlcwBSZXNvdXJjZU1hbmFnZXIAX3Jlc01ncgBTeXN0ZW0uR2xvYmFsaXphdGlv bgBDdWx0dXJlSW5mbwBfcmVzQ3VsdHVyZQBnZXRfUmVzb3VyY2VNYW5hZ2VyAGdldF9DdWx0dXJl AHNldF9DdWx0dXJlAFZhbHVlAEN1bHR1cmUAU3lzdGVtLkNvbmZpZ3VyYXRpb24AQXBwbGljYXRp b25TZXR0aW5nc0Jhc2UAbV9WYWx1ZQBtX1N5bmNPYmplY3QAZ2V0X1ZhbHVlAE1pY3Jvc29mdC5T cWxTZXJ2ZXIuU2NyaXB0VGFzawBNaWNyb3NvZnQuU3FsU2VydmVyLkR0cy5UYXNrcy5TY3JpcHRU YXNrAFZTVEFSVFNjcmlwdE9iamVjdE1vZGVsQmFzZQBTeXN0ZW0uRGF0YQBTeXN0ZW0uRGF0YS5T cWxDbGllbnQAU3FsQ29ubmVjdGlvbgBzcWxDb25uAFNxbENvbW1hbmQAc3FsQ21kAFNxbERhdGFS ZWFkZXIAcmRyUmVhZGVyAHNxbENtZFRleHQATWFpbgBFbnVtAHZhbHVlX18AU3VjY2VzcwBGYWls dXJlAFN5c3RlbS5Db21wb25lbnRNb2RlbABFZGl0b3JCcm93c2FibGVBdHRyaWJ1dGUARWRpdG9y QnJvd3NhYmxlU3RhdGUAU3lzdGVtLkNvZGVEb20uQ29tcGlsZXIAR2VuZXJhdGVkQ29kZUF0dHJp YnV0ZQBTeXN0ZW0uRGlhZ25vc3RpY3MARGVidWdnZXJIaWRkZW5BdHRyaWJ1dGUATWljcm9zb2Z0 LlZpc3VhbEJhc2ljLkNvbXBpbGVyU2VydmljZXMAU3RhbmRhcmRNb2R1bGVBdHRyaWJ1dGUASGlk ZU1vZHVsZU5hbWVBdHRyaWJ1dGUAU3lzdGVtLkNvbXBvbmVudE1vZGVsLkRlc2lnbgBIZWxwS2V5 d29yZEF0dHJpYnV0ZQBTeXN0ZW0uUnVudGltZS5Db21waWxlclNlcnZpY2VzAFJ1bnRpbWVIZWxw ZXJzAEdldE9iamVjdFZhbHVlAFJ1bnRpbWVUeXBlSGFuZGxlAEdldFR5cGVGcm9tSGFuZGxlAEFj dGl2YXRvcgBDcmVhdGVJbnN0YW5jZQBNeUdyb3VwQ29sbGVjdGlvbkF0dHJpYnV0ZQBzZXRfVmFs dWUAU3lzdGVtLlJ1bnRpbWUuSW50ZXJvcFNlcnZpY2VzAENvbVZpc2libGVBdHRyaWJ1dGUAU3lz dGVtLlJlZmxlY3Rpb24AQXNzZW1ibHkAZ2V0X0Fzc2VtYmx5AFN5c3RlbS5UaHJlYWRpbmcATW9u aXRvcgBFbnRlcgBFeGl0AERlYnVnZ2VyTm9uVXNlckNvZGVBdHRyaWJ1dGUAU2NyaXB0T2JqZWN0 TW9kZWwAZ2V0X0R0cwBNaWNyb3NvZnQuU3FsU2VydmVyLk1hbmFnZWREVFMATWljcm9zb2Z0LlNx bFNlcnZlci5EdHMuUnVudGltZQBDb25uZWN0aW9ucwBnZXRfQ29ubmVjdGlvbnMAQ29ubmVjdGlv bk1hbmFnZXIAZ2V0X0l0ZW0AZ2V0X1RyYW5zYWN0aW9uAEFjcXVpcmVDb25uZWN0aW9uAEV4ZWN1 dGVSZWFkZXIAUmVhZABJbnRlcmFjdGlvbgBNc2dCb3hSZXN1bHQATXNnQm94U3R5bGUATXNnQm94 AENsb3NlAHNldF9UYXNrUmVzdWx0AENMU0NvbXBsaWFudEF0dHJpYnV0ZQBTeXN0ZW0uQWRkSW4A QWRkSW5BdHRyaWJ1dGUAU1RfYmJlZWZhYjc1YjY3NDRjMjlkNDgzY2E4YmY1NzlhZTYudmJwcm9q LlJlc291cmNlcy5yZXNvdXJjZXMAQ29tcGlsYXRpb25SZWxheGF0aW9uc0F0dHJpYnV0ZQBSdW50 aW1lQ29tcGF0aWJpbGl0eUF0dHJpYnV0ZQBBc3NlbWJseUZpbGVWZXJzaW9uQXR0cmlidXRlAEd1 aWRBdHRyaWJ1dGUAQXNzZW1ibHlUcmFkZW1hcmtBdHRyaWJ1dGUAQXNzZW1ibHlDb3B5cmlnaHRB dHRyaWJ1dGUAQXNzZW1ibHlQcm9kdWN0QXR0cmlidXRlAEFzc2VtYmx5Q29tcGFueUF0dHJpYnV0 ZQBBc3NlbWJseURlc2NyaXB0aW9uQXR0cmlidXRlAEFzc2VtYmx5VGl0bGVBdHRyaWJ1dGUAU1Rf YmJlZWZhYjc1YjY3NDRjMjlkNDgzY2E4YmY1NzlhZTYudmJwcm9qLmRsbAAAAAAxTQB5AC4AUgBl AHMAbwB1AHIAYwBlAHMALgBNAHkAUgBlAHMAbwB1AHIAYwBlAHMAADdBAEQATwAgAC4ATgBFAFQA IABBAGQAdgBlAG4AdAB1AHIAZQBXAG8AcgBrAHMAMgAwADAAOAAAT1MARQBMAEUAQwBUACAAQwBP AFUATgBUACgAKgApACAARgBSAE8ATQAgAFsAUABlAHIAcwBvAG4AXQAuAFsAQQBkAGQAcgBlAHMA cwBdAABrVABoAGUAIABbAFAAZQByAHMAbwBuAF0ALgBbAEEAZABkAHIAZQBzAHMAXQAgAHQAYQBi AGwAZQAgAGMAbwBuAHQAYQBpAG4AcwAgAHQAaABpAHMAIABtAGEAbgB5ACAAcgBvAHcAcwA6AAAA Md9/dgoa10qBPzDXxbqAAwAIt3pcVhk04IkIsD9ffxHVCjoDIAABAwAAAQQAABIMBwYVEhgBEgwE AAASCAcGFRIYARIIBAAAEhEHBhUSGAESEQQAABIUBwYVEhgBEhQECAASDAQIABIIBAgAEhEECAAS FAQgAQIcAyAACAQgABIVAyAADgIeAAcQAQEeAB4ABzABAQEQHgACEwAEIAATAAcGFRIZARMABCgA EwADBhIdAwYSIQQAABIdBAAAEiEFAAEBEiEECAASHQQIABIhAwYSIAIGHAQAABIgBAgAEiAIiYRd zYCAzJEDBhItAwYSMQMGEjUCBg4CBggDBhEoBAAAAAAEAQAAAAUgAQERQQgBAAEAAAAAAAUgAgEO DhcBAApNeVRlbXBsYXRlBzguMC4wLjAAAAYVEhgBEgwGFRIYARIIBhUSGAESEQYVEhgBEhQEBwES DAQHARIIBAcBEhEEBwESFAQgAQEOEAEAC015LkNvbXB1dGVyAAAMAQAHTXkuVXNlcgAAEwEADk15 LkFwcGxpY2F0aW9uAAATAQAOTXkuV2ViU2VydmljZXMAAAQAARwcAwcBAgMHAQgGAAESFRFdBAcB EhUDBwEOBRABAB4ABAoBHgAEBwEeAAcgBAEODg4OYQEANFN5c3RlbS5XZWIuU2VydmljZXMuUHJv dG9jb2xzLlNvYXBIdHRwQ2xpZW50UHJvdG9jb2wSQ3JlYXRlX19JbnN0YW5jZV9fE0Rpc3Bvc2Vf X0luc3RhbmNlX18AAAAGFRIYARMABhUSGQETAAQKARMABSABARMABgcCEwATAAQgAQECBQEAAAAA BCAAEm0GIAIBDhJtBgcCEh0SHQQHARIhCAEAAgAAAAAABAABARwEBwESIAQgABJ5BCAAEn0GIAES gIEcAyAAHAQgARwcBiACAQ4SLQQgABI1AyAAAgQgARwICgADEYCJHBGAjRwEIAEBCDkBAApTY3Jp cHRNYWluAwBUDgdWZXJzaW9uAzEuMFQOCVB1Ymxpc2hlcgBUDgtEZXNjcmlwdGlvbgAIAQAIAAAA AAAeAQABAFQCFldyYXBOb25FeGNlcHRpb25UaHJvd3MBDAEABzEuMC4wLjAAACkBACQ4YmY5MTA2 YS02ODVkLTQ5OTctOGYzYS00MDE1OTBmNjczMTUAAAUBAAEAABYBABFDb3B5cmlnaHQgQCAgMjAw OQAALwEAKlNUX2JiZWVmYWI3NWI2NzQ0YzI5ZDQ4M2NhOGJmNTc5YWU2LnZicHJvagAAAMA7AAAA AAAAAAAAAN47AAAAIAAAAAAAAAAAAAAAAAAAAAAAAAAAAADQOwAAAAAAAAAAAAAAAAAAAABfQ29y RGxsTWFpbgBtc2NvcmVlLmRsbAAAAAAA/yUAIEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAD AAMAAAAoAACADgAAAEgAAIAQAAAAYAAAgAAAAAAAAAAAAAAAAAAAAgACAAAAeAAAgAMAAACQAACA AAAAAAAAAAAAAAAAAAABAAB/AACoAACAAAAAAAAAAAAAAAAAAAABAAEAAADAAACAAAAAAAAAAAAA AAAAAAABAAAAAADYAAAAAAAAAAAAAAAAAAAAAAABAAAAAADoAAAAAAAAAAAAAAAAAAAAAAABAAAA AAD4AAAAAAAAAAAAAAAAAAAAAAABAAAAAAAIAQAA2EQAAOgCAAAAAAAAAAAAAMBHAAAoAQAAAAAA AAAAAADoSAAAIgAAAAAAAAAAAAAAGEEAAMADAAAAAAAAAAAAAMADNAAAAFYAUwBfAFYARQBSAFMA SQBPAE4AXwBJAE4ARgBPAAAAAAC9BO/+AAABAAAAAQAAAAAAAAABAAAAAAA/AAAAAAAAAAQAAAAC AAAAAAAAAAAAAAAAAAAARAAAAAEAVgBhAHIARgBpAGwAZQBJAG4AZgBvAAAAAAAkAAQAAABUAHIA YQBuAHMAbABhAHQAaQBvAG4AAAAAAAAAsAQgAwAAAQBTAHQAcgBpAG4AZwBGAGkAbABlAEkAbgBm AG8AAAD8AgAAAQAwADAAMAAwADAANABiADAAAACAACsAAQBGAGkAbABlAEQAZQBzAGMAcgBpAHAA dABpAG8AbgAAAAAAUwBUAF8AYgBiAGUAZQBmAGEAYgA3ADUAYgA2ADcANAA0AGMAMgA5AGQANAA4 ADMAYwBhADgAYgBmADUANwA5AGEAZQA2AC4AdgBiAHAAcgBvAGoAAAAAADAACAABAEYAaQBsAGUA VgBlAHIAcwBpAG8AbgAAAAAAMQAuADAALgAwAC4AMAAAAIAALwABAEkAbgB0AGUAcgBuAGEAbABO AGEAbQBlAAAAUwBUAF8AYgBiAGUAZQBmAGEAYgA3ADUAYgA2ADcANAA0AGMAMgA5AGQANAA4ADMA YwBhADgAYgBmADUANwA5AGEAZQA2AC4AdgBiAHAAcgBvAGoALgBkAGwAbAAAAAAASAASAAEATABl AGcAYQBsAEMAbwBwAHkAcgBpAGcAaAB0AAAAQwBvAHAAeQByAGkAZwBoAHQAIABAACAAIAAyADAA MAA5AAAAiAAvAAEATwByAGkAZwBpAG4AYQBsAEYAaQBsAGUAbgBhAG0AZQAAAFMAVABfAGIAYgBl AGUAZgBhAGIANwA1AGIANgA3ADQANABjADIAOQBkADQAOAAzAGMAYQA4AGIAZgA1ADcAOQBhAGUA NgAuAHYAYgBwAHIAbwBqAC4AZABsAGwAAAAAAHgAKwABAFAAcgBvAGQAdQBjAHQATgBhAG0AZQAA AAAAUwBUAF8AYgBiAGUAZQBmAGEAYgA3ADUAYgA2ADcANAA0AGMAMgA5AGQANAA4ADMAYwBhADgA YgBmADUANwA5AGEAZQA2AC4AdgBiAHAAcgBvAGoAAAAAADQACAABAFAAcgBvAGQAdQBjAHQAVgBl AHIAcwBpAG8AbgAAADEALgAwAC4AMAAuADAAAAA4AAgAAQBBAHMAcwBlAG0AYgBsAHkAIABWAGUA cgBzAGkAbwBuAAAAMQAuADAALgAwAC4AMAAAACgAAAAgAAAAQAAAAAEABAAAAAAAgAIAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAACAAACAAAAAgIAAgAAAAIAAgACAgAAAgICAAMDAwAAAAP8AAP8AAAD/ /wD/AAAA/wD/AP//AAD///8AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAB3d3d3d3d3d3d3d3d3d3AERERERERERERERERERERw BP/////////////////0cAT/////////////////9HAE//////////////////RwBP////////// ///////0cAT/////////////////9HAE//////////////////RwBP/////////////////0cAT/ ////////////////9HAE//////////////////RwBP/////////////////0cAT///////////// ////9HAE//////////////////RwBP/////////////////0cAT/////////////////9HAE//// //////////////RwBP/////////////////0cAT/////////////////9HAE//////////////// //RwBIiIiIiIiIiIiIiIiIiEcARERERERERERERERERERHAETExMTExMTExMTs7OSXRwBMzMzMzM zMzMzMzMzMzEAABEREREREREREREREREQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAD/////////////////////wAAAAYAAAAGAAAABgAAAAYAAAAGAAAAB gAAAAYAAAAGAAAABgAAAAYAAAAGAAAABgAAAAYAAAAGAAAABgAAAAYAAAAGAAAABgAAAAYAAAAGA AAABgAAAAYAAAAGAAAADwAAAB////////////////ygAAAAQAAAAIAAAAAEABAAAAAAAwAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAACAAACAAAAAgIAAgAAAAIAAgACAgAAAgICAAMDAwAAAAP8AAP8A AAD//wD/AAAA/wD/AP//AAD///8AAAAAAAAAAAAHd3d3d3d3d0RERERERERHT///////+EdP//// ///4R0////////hHT///////+EdP///////4R0////////hHT///////+EdP///////4R0iIiIiI iIhHTMzMzMzMzEfEREREREREwAAAAAAAAAAAAAAAAAAAAAD//wAAgAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEAAP//AAD//wAAAAABAAIAICAQAAEABADo AgAAAgAQEBAAAQAEACgBAAADAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAwAAAMAAAA8DsAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 0 Performs high-performance data extraction, transformation and loading;Microsoft Corporation; Microsoft SQL Server v10; (C) 2007 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 OLE DB vs ADO NET performance comparison - OLE DB {ec392b7a-5fbb-4bde-9bcb-ec7ce8a77bdc} Moving records from a SQL Server source using OLE DB source SSIS.Pipeline.2 0 0 C:\BIMonkeySamples\rawfile 0 0 [Sales].[SalesOrderDetail] 1252 false 0

0 2 -1 Constraint {09385D4F-24C7-49B6-8182-B7E426AC51ED} ADO NET Source Component Basics {23191199-D739-4FD7-89DB-AB6C0C5DE932} SSIS.Package.2 0 <PrecedenceConstraint 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:EvalOp>Constraint</dwd:EvalOp></PrecedenceConstraint> dts-designer-1.0 {09385D4F-24C7-49B6-8182-B7E426AC51ED} {270E02ED-A4D6-470F-B0C5-79381C4211C3} <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>-3334</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="16" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="0" scrolltop="-4500" gridx="150" gridy="150" marginx="1000" marginy="1000" zoom="100" x="24950" y="11351" 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="01000000900144420100065461686f6d61" /> </font> <mouseicon> <ddsxmlobjectstreamwrapper binary="6c74000000000000" /> </mouseicon> </diagram> <layoutmanager> <ddsxmlobj /> </layoutmanager> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="This Script Task uses an ADO .NET connection to execute a query against a relational database" left="1555" top="-1249" logicalid="5" controlid="1" masterid="0" hint1="0" hint2="0" width="9525" 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="00080000352500008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{684C4F22-12A5-4753-93E6-10E284622785}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Moving records from a SQL Server source using ADO NET source" left="1555" top="1238" logicalid="6" controlid="2" masterid="0" hint1="0" hint2="0" width="9525" 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="00080000352500008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{C11B3B41-4952-4BE0-9171-81429A73C055}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Moving records from a SQL Server source using OLE DB source" left="1555" top="3193" logicalid="7" controlid="3" masterid="0" hint1="0" hint2="0" width="9525" 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="00080000352500008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{ec392b7a-5fbb-4bde-9bcb-ec7ce8a77bdc}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="5918" top="2003" logicalid="8" controlid="4" masterid="0" hint1="0" hint2="0" width="799" height="1690" 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="2" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" /> </ddsxmlobj> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{09385D4F-24C7-49B6-8182-B7E426AC51ED}" 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="17" destattachpoint="16" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"> <point x="6317" y="2402" /> <point x="6317" y="3193" /> </connector> </ddscontrol> <ddscontrol controlprogid="MSDDS.Text" left="1555" top="-3334" logicalid="12" controlid="8" masterid="0" hint1="0" hint2="0" width="11768" height="839" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="1" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"> <control> <ddsxmlobjectstreaminitwrapper binary="00020000f82d000047030000030064000000050000800000ff00000000002a0001000000bc02a42c0200065461686f6d612000410044004f0020002e004e0045005400200053006f007500720063006500200043006f006d0070006f006e0065006e007400200052006500760069006500770000000000" /> </control> <layoutobject> <ddsxmlobj /> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Text" left="1555" top="-2516" logicalid="13" controlid="9" masterid="0" hint1="0" hint2="0" width="8778" height="468" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="1" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"> <control> <ddsxmlobjectstreaminitwrapper binary="000200004a220000d40100000300640000000500008008000080000000002a0001000000900144420100065461686f6d612f00430072006500610074006500640020006200790020004a0061006d006500730020004200650072006500730066006f0072006400200066006f00720020007700770077002e00620069006d006f006e006b00650079002e0063006f006d0000000000" /> </control> <layoutobject> <ddsxmlobj /> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Text" left="12700" top="-1113" logicalid="14" controlid="10" masterid="0" hint1="0" hint2="0" width="8382" height="812" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="1" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"> <control> <ddsxmlobjectstreaminitwrapper binary="00020000be2000002c0300000300640000000500008008000080000000002a0001000000900144420100065461686f6d616a004100200073007000650063006900660069006300200075007300650020006f00660020007400680065002000410044004f0020002e004e0045005400200063006f006e006e0065006300740069006f006e00200069007300200074006f00200065006e00610062006c00650020000d000a0061006300630065007300730069006e0067002000720065006c006100740069006f006e0061006c00200073006f00750072006300650073002000770069007400680069006e0020006100200073006300720069007000740020007400610073006b0000000000" /> </control> <layoutobject> <ddsxmlobj /> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Text" left="12779" top="1215" logicalid="15" controlid="11" masterid="0" hint1="0" hint2="0" width="8249" height="1500" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="1" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"> <control> <ddsxmlobjectstreaminitwrapper binary="0002000039200000dc0500000300640000000500008008000080000000002a0001000000900144420100065461686f6d61b10042006500630061007500730065002000410044004f0020002e004e004500540020006100640064007300200061006e0020006100640064006900740069006f006e0061006c0020006c00610079006500720020006f00660020000d000a00700072006f00630065007300730069006e00670020006f0076006500720020004f004c004500200044004200200063006f006e006e0065006300740069006f006e0073002c00200069006600200061006300630065007300730069006e006700200061006e000d000a004f004c004500200044004200200063006f006d0070006c00690061006e007400200073006f0075007200630065002000690074002000770069006c006c00200061006c007700610079007300200062006500200073006c006f007700650072000d000a00610073002000740068006500730065002000630061007300650073002000640065006d006f006e007300740072006100740065002e0000000000" /> </control> <layoutobject> <ddsxmlobj /> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> </dds></dwd:Layout><dwd:PersistedViewPortTop>-4500</dwd:PersistedViewPortTop></dwd:DtsControlFlowDiagram></Package> dts-designer-1.0 {23191199-D739-4FD7-89DB-AB6C0C5DE932} {DAE4AFEA-EF16-4A9B-9F14-1DB3979502F3} <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="8" 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="24950" y="10425" 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="01010000900180380100065461686f6d61" /> </font> <mouseicon><ddsxmlobjectstreamwrapper binary="6c74000000000000" /> </mouseicon> </diagram> <layoutmanager><ddsxmlobj /> </layoutmanager> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Extracts data from a relational database by using a .NET provider." left="7620" top="1323" logicalid="4" controlid="4" 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"><control><ddsxmlobjectstreaminitwrapper binary="000800000e0e00008c040000" /> </control> <layoutobject><ddsxmlobj><property name="LogicalObject" value="{C11B3B41-4952-4BE0-9171-81429A73C055}/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="Loads raw data into a file." left="7620" top="4842" logicalid="6" controlid="6" 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"><control><ddsxmlobjectstreaminitwrapper binary="000800000e0e00008c040000" /> </control> <layoutobject><ddsxmlobj><property name="LogicalObject" value="{C11B3B41-4952-4BE0-9171-81429A73C055}/components/64" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="9020" top="2088" logicalid="7" controlid="7" masterid="0" hint1="0" hint2="0" width="799" height="3254" 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="{C11B3B41-4952-4BE0-9171-81429A73C055}/paths/70" 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="4" destid="6" sourceattachpoint="7" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"><point x="9419" y="2487" /> <point x="9419" y="4842" /> </connector> </ddscontrol> </dds></dwd:Layout></dwd:DtsDataFlowDiagram><dwd:DtsComponentDesignerPropertiesList><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">1 DataSourceViewID</dwd:key></dwd:DtsComponentDesignTimeProperty></dwd:DtsComponentDesignerPropertiesList></TaskHost> dts-designer-1.0 {C11B3B41-4952-4BE0-9171-81429A73C055} {60B8DD0A-C511-4394-B52C-EBF3451E7DCA} <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>ADO NET Source Output</dwd:SourceName><dwd:DestinationName>Raw File Destination Input</dwd:DestinationName></PipelinePath> dts-designer-1.0 {C11B3B41-4952-4BE0-9171-81429A73C055}-70 {D62BFD42-88AB-47CB-9983-FBAD5FBE3D06} <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="9" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="0" scrolltop="2955" gridx="150" gridy="150" marginx="1000" marginy="1000" zoom="100" x="24950" y="10425" 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="01010000900180380100065461686f6d61" /> </font> <mouseicon><ddsxmlobjectstreamwrapper binary="6c74000000000000" /> </mouseicon> </diagram> <layoutmanager><ddsxmlobj /> </layoutmanager> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Loads raw data into a file." left="7223" top="6480" logicalid="5" controlid="5" 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"><control><ddsxmlobjectstreaminitwrapper binary="000800000e0e00008c040000" /> </control> <layoutobject><ddsxmlobj><property name="LogicalObject" value="{ec392b7a-5fbb-4bde-9bcb-ec7ce8a77bdc}/components/64" 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="7223" top="4040" logicalid="7" controlid="7" 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"><control><ddsxmlobjectstreaminitwrapper binary="000800000e0e00008c040000" /> </control> <layoutobject><ddsxmlobj><property name="LogicalObject" value="{ec392b7a-5fbb-4bde-9bcb-ec7ce8a77bdc}/components/82" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="8623" top="4805" logicalid="8" controlid="8" masterid="0" hint1="0" hint2="0" width="799" height="2175" 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="{ec392b7a-5fbb-4bde-9bcb-ec7ce8a77bdc}/paths/97" 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="7" destid="5" sourceattachpoint="7" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"><point x="9022" y="5204" /> <point x="9022" y="6480" /> </connector> </ddscontrol> </dds></dwd:Layout><dwd:PersistedViewPortTop>2955</dwd:PersistedViewPortTop></dwd:DtsDataFlowDiagram><dwd:DtsComponentDesignerPropertiesList><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">82 DataSourceViewID</dwd:key></dwd:DtsComponentDesignTimeProperty><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">82 TableInfoObjectType</dwd:key><dwd:value xsi:type="xsd:string">Table</dwd:value></dwd:DtsComponentDesignTimeProperty></dwd:DtsComponentDesignerPropertiesList></TaskHost> dts-designer-1.0 {ec392b7a-5fbb-4bde-9bcb-ec7ce8a77bdc} {3054A6B9-C1AE-46EF-A864-9851383118E3} <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>Raw File Destination Input</dwd:DestinationName></PipelinePath> dts-designer-1.0 {ec392b7a-5fbb-4bde-9bcb-ec7ce8a77bdc}-97 {36E069C4-26EC-411E-A63E-F2B47F3C919C} <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>-3334</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="16" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="0" scrolltop="-4500" gridx="150" gridy="150" marginx="1000" marginy="1000" zoom="100" x="24950" y="11351" 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="01000000900144420100065461686f6d61" /> </font> <mouseicon> <ddsxmlobjectstreamwrapper binary="6c74000000000000" /> </mouseicon> </diagram> <layoutmanager> <ddsxmlobj /> </layoutmanager> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="This Script Task uses an ADO .NET connection to execute a query against a relational database" left="1555" top="-1249" logicalid="5" controlid="1" masterid="0" hint1="0" hint2="0" width="9525" 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="00080000352500008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{684C4F22-12A5-4753-93E6-10E284622785}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Moving records from a SQL Server source using ADO NET source" left="1555" top="1238" logicalid="6" controlid="2" masterid="0" hint1="0" hint2="0" width="9525" 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="00080000352500008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{C11B3B41-4952-4BE0-9171-81429A73C055}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.2" tooltip="Moving records from a SQL Server source using OLE DB source" left="1555" top="3193" logicalid="7" controlid="3" masterid="0" hint1="0" hint2="0" width="9525" 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="00080000352500008c040000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{ec392b7a-5fbb-4bde-9bcb-ec7ce8a77bdc}" vartype="8" /> <property name="ShowConnectorSource" value="0" vartype="2" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="5918" top="2003" logicalid="8" controlid="4" masterid="0" hint1="0" hint2="0" width="799" height="1690" 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="2" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" /> </ddsxmlobj> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="{09385D4F-24C7-49B6-8182-B7E426AC51ED}" 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="17" destattachpoint="16" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"> <point x="6317" y="2402" /> <point x="6317" y="3193" /> </connector> </ddscontrol> <ddscontrol controlprogid="MSDDS.Text" left="1555" top="-3334" logicalid="12" controlid="8" masterid="0" hint1="0" hint2="0" width="11768" height="839" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="1" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"> <control> <ddsxmlobjectstreaminitwrapper binary="00020000f82d000047030000030064000000050000800000ff00000000002a0001000000bc02a42c0200065461686f6d612000410044004f0020002e004e0045005400200053006f007500720063006500200043006f006d0070006f006e0065006e007400200052006500760069006500770000000000" /> </control> <layoutobject> <ddsxmlobj /> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Text" left="1555" top="-2516" logicalid="13" controlid="9" masterid="0" hint1="0" hint2="0" width="8778" height="468" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="1" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"> <control> <ddsxmlobjectstreaminitwrapper binary="000200004a220000d40100000300640000000500008008000080000000002a0001000000900144420100065461686f6d612f00430072006500610074006500640020006200790020004a0061006d006500730020004200650072006500730066006f0072006400200066006f00720020007700770077002e00620069006d006f006e006b00650079002e0063006f006d0000000000" /> </control> <layoutobject> <ddsxmlobj /> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Text" left="12700" top="-1113" logicalid="14" controlid="10" masterid="0" hint1="0" hint2="0" width="8382" height="812" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="1" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"> <control> <ddsxmlobjectstreaminitwrapper binary="00020000be2000002c0300000300640000000500008008000080000000002a0001000000900144420100065461686f6d616a004100200073007000650063006900660069006300200075007300650020006f00660020007400680065002000410044004f0020002e004e0045005400200063006f006e006e0065006300740069006f006e00200069007300200074006f00200065006e00610062006c00650020000d000a0061006300630065007300730069006e0067002000720065006c006100740069006f006e0061006c00200073006f00750072006300650073002000770069007400680069006e0020006100200073006300720069007000740020007400610073006b0000000000" /> </control> <layoutobject> <ddsxmlobj /> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Text" left="12779" top="1215" logicalid="15" controlid="11" masterid="0" hint1="0" hint2="0" width="8249" height="1500" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="1" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"> <control> <ddsxmlobjectstreaminitwrapper binary="0002000039200000dc0500000300640000000500008008000080000000002a0001000000900144420100065461686f6d61b10042006500630061007500730065002000410044004f0020002e004e004500540020006100640064007300200061006e0020006100640064006900740069006f006e0061006c0020006c00610079006500720020006f00660020000d000a00700072006f00630065007300730069006e00670020006f0076006500720020004f004c004500200044004200200063006f006e006e0065006300740069006f006e0073002c00200069006600200061006300630065007300730069006e006700200061006e000d000a004f004c004500200044004200200063006f006d0070006c00690061006e007400200073006f0075007200630065002000690074002000770069006c006c00200061006c007700610079007300200062006500200073006c006f007700650072000d000a00610073002000740068006500730065002000630061007300650073002000640065006d006f006e007300740072006100740065002e0000000000" /> </control> <layoutobject> <ddsxmlobj /> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> </dds></dwd:Layout><dwd:PersistedViewPortTop>-4500</dwd:PersistedViewPortTop></dwd:DtsControlFlowDiagram></Package> dts-designer-1.0 package-diagram {1796AB1A-6D62-4500-8B2B-6FCAE6401644}