32/23/2007 1:05:21 PM512010247{30FC92A2-8768-4FD7-B4E2-F8498ECF91AC}-10000ConfigConnection{4E94A5E2-F3FC-4BE3-A517-51510D6C61A0}Connection used to get information about collection configuration and for logging purposes.OLEDB@[User::ConfigConnectionString]0Data Source=(local);Initial Catalog=msdb;Provider=SQLNCLI10;Integrated Security=SSPI;APP=SQL Server Data Collector;0User::CacheDirectory\Package.Variables[User::CacheDirectory].Properties[Value]CacheDirectory{2DF91A21-DC08-404B-B537-367F20F72E42}0User::CacheWindow\Package.Variables[User::CacheWindow].Properties[Value]CacheWindow{B360CA6A-D82F-4B4E-81DB-7A8F702574F6}0User::InputParameters\Package.Variables[User::InputParameters].Properties[Value]InputParameters{FB8C290D-145C-46CE-BB73-10BB2385175F}0User::MDWConnectionString\Package.Variables[User::MDWConnectionString].Properties[Value]MDWConnectionString{5490BC46-3D1A-4F9A-8776-CF1BE3D41469}0User::ConfigConnectionString\Package.Variables[User::ConfigConnectionString].Properties[Value]ConfigConnectionString{DDD6841A-31D4-4A59-8532-F9790E901171}0User::TargetConnectionString\Package.Variables[User::TargetConnectionString].Properties[Value]TargetConnectionString{EBE7AA26-55D4-4F72-B489-B55945E6019B}0User::LoopEventName\Package.Variables[User::LoopEventName].Properties[Value]LoopEventName{F9014B9C-BC8F-489C-B99F-097E18F9BC23}0User::ExitEventName\Package.Variables[User::ExitEventName].Properties[Value]ExitEventName{C24EF892-429F-4B3C-A111-13DB7A494FCB}0User::CollectorTypeUID\Package.Variables[User::CollectorTypeUID].Properties[Value]CollectorTypeUID{27D818B0-33C7-43D0-8EF2-5977B4196718}0User::CollectionSetUID\Package.Variables[User::CollectionSetUID].Properties[Value]CollectionSetUID{E47A5D19-3066-4CB4-BBE5-FA97F105AFC3}0User::ItemID\Package.Variables[User::ItemID].Properties[Value]ItemID{2D172908-BD61-4ABF-9F82-27F51E6C1DA0}0User::InstanceID\Package.Variables[User::InstanceID].Properties[Value]InstanceID{E5363D05-5772-4597-88B3-326AF26B3C85}0User::InstanceName\Package.Variables[User::InstanceName].Properties[Value]InstanceName{361B3E87-706B-4AD0-9EC1-006A44B38233}0User::LoggingLevel\Package.Variables[User::LoggingLevel].Properties[Value]LoggingLevel{3669A456-6321-4100-AC8E-FB1A95859A8E}0User::LogID\Package.Variables[User::LogID].Properties[Value]LogID{FDCAFA60-9772-42E4-BBEF-7385D5D59B6F}0User::ParentLogID\Package.Variables[User::ParentLogID].Properties[Value]ParentLogID{27797092-0D53-4ED5-88B7-0C7B76E726BD}10.0.1418.400-100-10104857610331-10User00c:\perflogsCacheDirectory{29F8E7BD-603A-476F-9B2D-6C92119CE553}@[User::CacheDirectory] + "\\" + @[System::MachineName] + "_" + @[User::InstanceID] + "_" + @[User::CollectionSetUID] + "_" + (DT_WSTR, 255) @[User::ItemID] + ".cache"-1User00c:\perflogs\BARTDRED_MSSQL.1_640012b7-4ed0-4865-a636-4946d73c425f_0.cacheCacheFilename{967E7E54-C796-4A22-995E-AAF61BB36173}0User001CacheWindow{EF1ADEC8-05A4-4885-AE2E-F5F40EDF145A}0User00640012b7-4ed0-4865-a636-4946d73c425fCollectionSetUID{C5042E47-57C6-42FF-B65A-36AA2F808656}0User00294605dd-21de-40b2-b20f-f3e170ea1ec3CollectorTypeUID{2E115FC3-AB18-4468-BF2D-74C84CFFF849}0User00Provider=SQLNCLI10;Data Source=(local);Integrated Security=SSPI;Initial Catalog=msdb;APP=SQL Server Data CollectorConfigConnectionString{64459284-6B94-45DB-A58B-50D48D02C473}0User00EXITEVENTExitEventName{E988E92E-8FC0-4097-8AA4-CD14BD52783F}0User00<PerformanceCountersCollector><PerformanceCounters Objects="Process" Counters="*" Instances="*" /><PerformanceCounters Objects="Processor" Counters="*" Instances="*" /><PerformanceCounters Objects="Paging File" Counters="*" Instances="*" /><PerformanceCounters Objects="PhysicalDisk" Counters="*" Instances="*" /><PerformanceCounters Objects="Server" Counters="*" Instances="" /></PerformanceCountersCollector>InputParameters{3EB44CAF-64FC-4F6A-A7BE-4160AEE20B34}0User00MSSQL.1InstanceID{928007D1-B14A-4D77-8204-80390F5FB6CB}0User00(local)InstanceName{43C71C34-F794-427C-92E6-D395182A0EA9}0User000ItemID{4BE8D57B-5002-4B3E-B43A-50F76AF58148}0User002LoggingLevel{AA31DAA1-078D-4091-8B9F-1E74D4A51FA1}0User000LogID{D05C5D8C-82BF-4C78-AB42-47C01FF782BF}0User000LoopDuration{9C7C5068-DBAC-42CB-A94E-FA5EB1FAEE4A}0User00LOOPEVENTLoopEventName{9AA16C7F-334A-4F2C-9F11-CC3719DB3722}0User00Provider=SQLNCLI10;Data Source=(local);Integrated Security=SSPI;Initial Catalog=MDW;APP=SQL Server Data CollectorMDWConnectionString{2E6EF4C5-555E-4955-B8BD-22F04E37EB47}0User000ParentLogID{B87950A5-F6B0-4944-957B-943E41BD4A9C}0User000RowCountIn{610F0141-9C2A-427B-8774-BCA4C0B51F30}0User000RowCountOut{5795944D-0E69-4702-9997-D9BA10D59589}0User00Provider=SQLNCLI10;Data Source=(local);Integrated Security=SSPI;APP=SQL Server Data CollectorTargetConnectionString{44A62538-C3D0-4BFD-9216-9CF8B520D3FF}0User00-1TargetProcessID{B5CE21C4-35D9-4861-B04C-7FFD03436B28}102,7,OnError,9,OnWarning-1-1-1-1-1-1-1-1-1-1-1-1-1-1{710AEAF2-45BD-4AB2-9EAF-FB6268AD10A2}{6a2ecbd1-4348-4274-a8be-ea7c86bd0581}DC.ForEachEventEnumerator.1@[User::ExitEventName]@[User::LoopEventName]100-100-101048576-11-12000-100011048576-11001No-Op Sequence Container{3C4A6AEF-9248-43F4-9428-9A90D2180467}Sequence ContainerSTOCK:SEQUENCE00Execute SQL Task; Microsoft Corporation; Microsoft SQL Server 2008; © 2007 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;100-100011048576-1100User000SqlProcessID{8f6a0f37-d2f3-4cba-8dba-24bc965aa726}01Get SQL Process ID{8399b51b-c73c-4eb5-a314-447211237d45}Execute SQL TaskMicrosoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91000-100-101048576-11-10User00PerfCountersLockSyncRoot{2C3410CF-ED28-49FC-B178-5A5D81706A6D}000Performs 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;100-100-101048576-11-100DFT - Retrieve Performance Counters{C54F50A1-B2B5-4E92-9B84-4FAEDBF89FFF}Data Flow TaskSSIS.Pipeline.20User::RowCountOut

1User::CacheFilename2Collect Upload Package Sync Sequence Container{926A1F57-89A9-423A-8A68-151BE44CE956}Sequence ContainerSTOCK:SEQUENCE00Execute SQL Task; Microsoft Corporation; Microsoft SQL Server v9; © 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;100-100004096-11-120SQL - Log Package Stats{584e45b8-9755-4fa7-b8b7-f5c1d000603d}Execute SQL TaskMicrosoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc9100Execute SQL Task; Microsoft Corporation; Microsoft SQL Server v9; © 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;100-100004096-11-120SQL - Log Package Iteration{81cbca02-95ea-4634-95ed-6ddd61802257}Execute SQL TaskMicrosoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91022-1Constraint 3{71196d3d-021d-447d-973a-4c23d217cd1c}23-1@[User::LoggingLevel] >= 1Constraint 2{9F2FBB1A-FACF-4FC4-B755-A53DC3403F70}010@TargetProcessID == -1Constraint{A8FA1F46-2B02-4F55-A49E-4DD5C75C5F91}Target Process ID Unknown010@TargetProcessID != -1Constraint 1{7CCBF793-8783-41F4-ADC2-5E71B809CF51}Target Process ID Known220Constraint 4{0610DCB9-BB0C-4B26-BE90-D0DEFF3CC36A}LOOP - Aquire performance counters @ collection item frequency{72e40adc-49ee-4175-b503-4f26f85912fc}Foreach Loop - Aquire performance counters snapshot (Collector Item Frequency)STOCK:FOREACHLOOP0User::LoopDuration0{A54A1B17-9B8C-435D-8F32-D034B664E27C}{A54A1B17-9B8C-435D-8F32-D034B664E27C}PerfCountersCollect{C2EAABC1-5BF3-4127-BEB3-26E94D026E7D}SSIS.Package.20