32/14/2007 3:06:05 PM51-101086{244F0904-5CC6-49B8-AE90-905AEEA8BAF3}-100-10ConfigConnection{9BE08268-DCA3-4834-8711-29EB7B34AC16}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;0MdwConnection{B2336E2F-4946-4B14-9A6C-BF6059132E81}Connection used to upload collected data to a warehouse.OLEDB@[User::MDWConnectionString]-1Data Source=(local);Initial Catalog=MDW;Provider=SQLNCLI10;Integrated Security=SSPI;APP=SQL Server Data Collector;0TargetConnection{BDD785A2-1226-44DB-B2B4-9D4AFF9CCB3A}Connection used to get information from the monitored (target) instance.OLEDB@[User::TargetConnectionString]-1Data Source=(local);Provider=SQLNCLI10;Integrated Security=SSPI;APP=SQL Server Data Collector;0User::CacheDirectory\Package.Variables[User::CacheDirectory].Properties[Value]CacheDirectory{72F1EE8A-126D-4918-8358-55FD82DCDA58}0User::CacheWindow\Package.Variables[User::CacheWindow].Properties[Value]CacheWindow{5EF6C061-FFAD-45CF-BEDC-170C206A9774}0User::InputParameters\Package.Variables[User::InputParameters].Properties[Value]InputParameters{62E3B07F-C5B7-4897-B347-74EF91DE84EA}0User::MDWConnectionString\Package.Variables[User::MDWConnectionString].Properties[Value]MDWConnectionString{EBB9F538-F06D-4E25-803F-DA3786931A72}0User::ConfigConnectionString\Package.Variables[User::ConfigConnectionString].Properties[Value]ConfigConnectionString{D435F04D-45EE-4705-9F59-37B75F4695BB}0User::TargetConnectionString\Package.Variables[User::TargetConnectionString].Properties[Value]TargetConnectionString{175B22A1-7B3C-4C7C-9F27-8BA255CE806D}0User::LoopEventName\Package.Variables[User::LoopEventName].Properties[Value]LoopEventName{349BCBAD-ABF2-4639-93A2-E7E6474E2C69}0User::ExitEventName\Package.Variables[User::ExitEventName].Properties[Value]ExitEventName{264D4120-D107-4880-A7FA-5BEAE2BB05B8}0User::CollectorTypeUID\Package.Variables[User::CollectorTypeUID].Properties[Value]CollectorTypeUID{E46A25A3-1DB8-4F06-93F5-700D9FF3D8DB}0User::CollectionSetUID\Package.Variables[User::CollectionSetUID].Properties[Value]CollectionSetUID{DA667ED7-E83E-4E8F-AF0B-90B784E51E4D}0User::ItemID\Package.Variables[User::ItemID].Properties[Value]ItemID{4D42DA00-DC8B-442A-AE96-18DB1C38D3E7}0User::InstanceID\Package.Variables[User::InstanceID].Properties[Value]InstanceID{8AFB1B11-7206-4A95-AED3-631969E75CE9}0User::InstanceName\Package.Variables[User::InstanceName].Properties[Value]InstanceName{7B439C62-C6E2-4961-B885-8F19CA71B18B}0User::LoggingLevel\Package.Variables[User::LoggingLevel].Properties[Value]LoggingLevel{3FB4BC97-FCA6-457F-BEFA-A22645B7824C}0User::LogID\Package.Variables[User::LogID].Properties[Value]LogID{C5B0F2F8-E34E-41C6-879A-85CAD34E4ED8}0User::ParentLogID\Package.Variables[User::ParentLogID].Properties[Value]ParentLogID{2DF60C47-E413-4E07-9EC1-F06F888B6143}10.0.1101.000-100-10104857610331-10User00C:\Users\macies\AppData\Local\Temp\ecodedcCacheDirectory{9E13D738-CEC0-4537-93A7-7926142F274B}0User001CacheWindow{E40806B1-6B8D-4381-AD2B-1C44067588E4}0User00f37780d4-fea7-4271-90b2-fa553ad4ca91CollectionSetUID{B902EBEC-969B-42D4-81BE-C5149B8E1750}0User000e218cf8-ecb5-417b-b533-d851c0251271CollectorTypeUID{998E9C65-6E29-46CD-845E-AFA5D5C6E75E}0User00Provider=SQLNCLI10;Data Source=(local);Integrated Security=SSPI;Initial Catalog=msdb;APP=SQL Server Data CollectorConfigConnectionString{9B1A5823-2F9A-4589-B15F-CDB60E89CDAF}0User00EXITEVENTExitEventName{46738D8F-C9D8-45DC-95C2-F7BD6CB95C13}0User00<?xml version="1.0" encoding="utf-8"?><ns:SqlTraceCollector xmlns:ns="DataCollectorType" normalize_sql="0" normalize_plans="0" normalize_procedures="0" normalize_connections="0" normalize_default="1"><Events><EventType id ="6" name="Performance"><Event id="58" name="Auto Stats" /><Event id="165" name="Performance statistics" /><Event id="146" name="Showplan XML Statistics Profile" /></EventType><EventType id="13" name="TSQL"><Event id="12" name="SQL:BatchCompleted" columnslist="1, 3, 9, 10, 13, 16, 17, 18" /><Event id="13" name="SQL:BatchStarting" /><Event id="41" name="SQL:StmtCompleted" /><Event id="166" name="SQL:StmtRecompile" /></EventType><EventType id="20" name="CLR"><Event id="196" name="Assembly Load" /></EventType><EventType id="1" name="Cursors"><Event id="53" name="CursorOpen" /><Event id="75" name="CursorRecompile" /><Event id="76" name="CursorImplicitConversion" /><Event id="78" name="CursorClose" /></EventType></Events><Filters><Filter columnid="13" columnname="Duration" logical_operator="AND" comparison_operator="GE" value="1000L"/><Filter columnid="10" columnname="ApplicationName" logical_operator="AND" comparison_operator="LIKE" value="Data Collector"/><Filter columnid="10" columnname="ApplicationName" logical_operator="AND" comparison_operator="EQ" value="NULL"/><Filter columnid="18" columnname="CPU" logical_operator="AND" comparison_operator="EQ" value="20"/><Filter columnid="14" columnname="StartTime" logical_operator="AND" comparison_operator="GT" value="2007-02-09 13:40:00"/></Filters></ns:SqlTraceCollector>InputParameters{A3701456-096F-4A45-A8CC-E5473ECFE075}0User00MSSQL.1InstanceID{91086B11-E37A-419D-B9F2-05807790111F}0User00(local)InstanceName{20041AC6-1B78-4A75-8F50-D4DAA6EDF964}0User000ItemID{0C688D7F-6BFB-4018-BA62-78AF00876D5D}0User002LoggingLevel{9FF8E1B3-7D2A-43BD-894D-F27FEBC3275C}0User000LogID{D13402E2-2FD2-4FF8-8873-93D5A999FCE5}0User000LoopDuration{2DF4BAA6-D6A8-4230-9007-A1CD3E5AF1CF}0User00LOOPEVENTLoopEventName{EF24B339-0DAC-42AC-A490-CD53827688F7}0User00Provider=SQLNCLI10;Data Source=(local);Integrated Security=SSPI;Initial Catalog=MDW;APP=SQL Server Data CollectorMDWConnectionString{A506924A-C3E2-41E2-8C9D-1EE5E4792051}0User000ParentLogID{58FC505F-AC84-4F90-834C-E27CC8478D0B}0User00Provider=SQLNCLI10;Data Source=(local);Integrated Security=SSPI;APP=SQL Server Data CollectorTargetConnectionString{9E925F74-02D2-4B08-8C55-BABE20B84168}0User000TraceErrorCode{549EEAA7-88DB-4FCB-9548-BBE7077559F9}0User000TraceID{05CEC9A6-14B2-4B68-8EF7-7825CC7622D4}@[User::CacheDirectory] + "\\DC_Trace_" + @[System::MachineName] + "." + @[User::InstanceID] + "." + @[User::CollectionSetUID] + "." + (DT_WSTR, 5) @[User::ItemID]-1User00C:\Users\macies\AppData\Local\Temp\ecodedc\DC_Trace_AHMEDAY03.MSSQL.1.f37780d4-fea7-4271-90b2-fa553ad4ca91.0TraceLocation{1FDF1A88-F491-496C-BB22-26F2DB314498}0User00TraceScript{6BCBC2C4-F895-4B8C-A793-EB71AFF0AF2A}102,7,OnError,9,OnWarning-1-1-1-1-1-1-1-1-1-1-1-1-1-10Trace Start Script Task;Microsoft Corporation; Microsoft SQL Server codename Katmai; (C) 2007 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;100-100-101048576-10-120@[User::InputParameters]@[User::TraceLocation]TRC - Generate Trace Start Script{A1508E93-DDD6-4E3D-BE78-46B59503E7AF}Trace Start ScriptDTS.TraceStartScriptTask.10<?xml version="1.0" encoding="utf-8"?><ns:SqlTraceCollector xmlns:ns="DataCollectorType" normalize_sql="0" normalize_plans="0" normalize_procedures="0" normalize_connections="0" normalize_default="1"><Events><EventType id ="6" name="Performance"><Event id="58" name="Auto Stats" /><Event id="165" name="Performance statistics" /><Event id="146" name="Showplan XML Statistics Profile" /></EventType><EventType id="13" name="TSQL"><Event id="12" name="SQL:BatchCompleted" columnslist="1, 3, 9, 10, 13, 16, 17, 18" /><Event id="13" name="SQL:BatchStarting" /><Event id="41" name="SQL:StmtCompleted" /><Event id="166" name="SQL:StmtRecompile" /></EventType><EventType id="20" name="CLR"><Event id="196" name="Assembly Load" /></EventType><EventType id="1" name="Cursors"><Event id="53" name="CursorOpen" /><Event id="75" name="CursorRecompile" /><Event id="76" name="CursorImplicitConversion" /><Event id="78" name="CursorClose" /></EventType></Events><Filters><Filter columnid="13" columnname="Duration" logical_operator="AND" comparison_operator="GE" value="1000L"/><Filter columnid="10" columnname="ApplicationName" logical_operator="AND" comparison_operator="LIKE" value="Data Collector"/><Filter columnid="10" columnname="ApplicationName" logical_operator="AND" comparison_operator="EQ" value="NULL"/><Filter columnid="18" columnname="CPU" logical_operator="AND" comparison_operator="EQ" value="20"/><Filter columnid="14" columnname="StartTime" logical_operator="AND" comparison_operator="GT" value="2007-02-09 13:40:00"/></Filters></ns:SqlTraceCollector>C:\Users\macies\AppData\Local\Temp\ecodedc\DC_Trace_CHINGCHA0.MSSQL.1.f37780d4-fea7-4271-90b2-fa553ad4ca91.01010TraceScript0Execute SQL Task; Microsoft Corporation; Microsoft SQL Server v9; © 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;100-100-104096-11-120SQL - Close trace if running{22a8654c-00d2-41ea-8273-a98f925bca5a}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-100-104096-11-120SQL - Execute Trace Start Script{B5D9B002-1927-4CCA-84AE-F291C7E5F613}Execute SQL TaskMicrosoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc910{710AEAF2-45BD-4AB2-9EAF-FB6268AD10A2}{710AEAF2-45BD-4AB2-9EAF-FB6268AD10A2}DC.ForEachEventEnumerator.1@[User::ExitEventName]@[User::LoopEventName]100-100-101048576-11-1200Execute 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 - Check if Trace is Running{DDDFF39B-578A-4DFB-B194-0723500C3565}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-100-104096-11-120SQL - Recreate Trace{972327c3-db40-4180-9f20-b5696bb14eb2}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-11020SQL - Log Package Stats{A96C46EC-F328-44A1-BE6B-0FA1A2E4267E}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-11020SQL - Log Package Iteration{6287158D-7570-43DF-9D6E-9D9191345709}Execute SQL TaskMicrosoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91012-1Constraint{717FFE6B-71FE-4F0A-B934-916A64CFA375}030@[User::LoggingLevel] >= 1Constraint 1{C8B2863D-73FC-49A9-A730-03681768D7A4}230@[User::LoggingLevel] >= 1Constraint 2{43AC0421-D367-442B-852C-1C8C10E392AE}22-1Constraint 3{DCF85D96-5446-432D-8CCB-976768E873D3}Foreach Loop - Monitor Trace{AC652D98-8CD6-4256-BEB0-7B937A9F6EFC}Foreach Loop ContainerSTOCK:FOREACHLOOP0User::LoopDuration0{20400B93-3704-4726-ADCC-73457B916283}{20400B93-3704-4726-ADCC-73457B916283}0Execute SQL Task; Microsoft Corporation; Microsoft SQL Server v9; © 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;100-100-104096-11020SQL - Stop Trace{B4EFD1D8-5EA4-4E54-AA01-905A01982D39}Execute SQL TaskMicrosoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91003-1@[User::TraceID] > 0Constraint 1{173BDAB9-B91C-41D7-900D-9983E6C67B72}22-1Constraint 2{CDB85B45-DF66-4F48-9171-B6E4D3CC1A2D}02-1Constraint{0AA76CCC-2FE2-4634-B3D2-A667800C2970}02-1Constraint 5{2D5D63DF-D075-4A13-BFA3-A73ECE38EB69}SqlTraceCollect{0E149FC9-1046-4DE6-98BF-4B22ED6F6C42}SSIS.Package.20