33/6/2007 4:18:14 PM50-10100218{87F7CC3E-C760-44E0-87AA-A7BC9B2E08CF}-10000ConfigConnection{C9A06CAE-CFEE-4A26-BE59-A3A222474CCB}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{6CE046ED-1A7E-4831-864D-EF6FCE30E5A9}Connection used to upload collected data to a warehouse.OLEDB@[User::MDWConnectionString]-1Data Source=(local);Initial Catalog=myMDW;Provider=SQLNCLI10;Integrated Security=SSPI;APP=SQL Server Data Collector;0TargetConnection{607D54DC-E752-4779-9BB2-B3D19CAD0C76}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{C32CCDDF-1CB6-4E64-806E-193762452CA6}0User::CacheWindow\Package.Variables[User::CacheWindow].Properties[Value]CacheWindow{5A111CDB-34FB-47A2-8307-96D7C3BB49CA}0User::InputParameters\Package.Variables[User::InputParameters].Properties[Value]InputParameters{AC2982C3-5B39-4514-B50D-092C15857C1F}0User::MDWConnectionString\Package.Variables[User::MDWConnectionString].Properties[Value]MDWConnectionString{3B823989-622C-484E-A927-E0C211588865}0User::ConfigConnectionString\Package.Variables[User::ConfigConnectionString].Properties[Value]ConfigConnectionString{BD6C4FE9-3BCB-447C-A897-0DA27695E684}0User::TargetConnectionString\Package.Variables[User::TargetConnectionString].Properties[Value]TargetConnectionString{7A1F3609-4C0F-4BFA-A979-4AF89D61F160}0User::LoopEventName\Package.Variables[User::LoopEventName].Properties[Value]LoopEventName{5C370D78-5CD2-427F-B461-BF36DDAFF7F6}0User::ExitEventName\Package.Variables[User::ExitEventName].Properties[Value]ExitEventName{8EDCACD7-00DF-40EC-A8C0-B24F1E7D926B}0User::CollectorTypeUID\Package.Variables[User::CollectorTypeUID].Properties[Value]CollectorTypeUID{EDC66214-7B5A-479C-9F8A-4F1A3DE80C93}0User::CollectionSetUID\Package.Variables[User::CollectionSetUID].Properties[Value]CollectionSetUID{FF327F2E-CCC8-4F10-A2D0-38603D037E2C}0User::ItemID\Package.Variables[User::ItemID].Properties[Value]ItemID{01BD5F34-840B-4D65-8BF9-969DAE6CF738}0User::InstanceID\Package.Variables[User::InstanceID].Properties[Value]InstanceID{FD17D526-ED20-412C-8410-FA25A5F46BAC}0User::InstanceName\Package.Variables[User::InstanceName].Properties[Value]InstanceName{D3DD404F-F408-420C-A9EA-A20AAB672DBB}0User::LoggingLevel\Package.Variables[User::LoggingLevel].Properties[Value]LoggingLevel{3F16CD83-89C9-4318-A8AD-16A99DB6A766}0User::LogID\Package.Variables[User::LogID].Properties[Value]LogID{B4A38B6C-953A-42F8-8BF4-56631E8D7614}0User::ParentLogID\Package.Variables[User::ParentLogID].Properties[Value]ParentLogID{8406BEC6-5D17-457B-BD92-714F0CF97EB5}0User::DaysUntilExpiration\Package.Variables[User::DaysUntilExpiration].Properties[Value]DaysUntilExpiration{6F51BB50-9D79-4BA5-A519-6EF540C17B67}10.0.1600.2200-1000010485761033100User002345CacheDirectory{E34CB8FD-CBD7-4A2E-B4E0-738BC079307C}0User0067891CacheWindow{9251F22F-29AD-41BA-B38F-E50534BD4E12}0User002345CollectionSetUID{55DA9900-29F0-48FE-B856-2F7CAACA67E1}0User002345{0E218CF8-ECB5-417B-B533-D851C0251271}CollectorTypeUID{BDB5BAD1-EF93-4D54-9722-7994B328EB88}0User002345Provider=SQLNCLI10;Data Source=(local);Integrated Security=SSPI;Initial Catalog=msdb;APP=SQL Server Data CollectorConfigConnectionString{5D803253-0D98-4C29-90AE-84E720B07657}0User0067890Counter{8934324A-007D-49FB-A1FF-F92608513E4D}0User0067890DaysUntilExpiration{1EF6EE6B-FED9-4B60-8FC3-05A59E7667B0}0User002345EXITEVENTExitEventName{1FC5CE71-C336-452D-8E10-BFAE5569C2CE}0User002345<ns:SqlTraceCollector xmlns:ns="DataCollectorType" use_default="1"><Events/><Filters/></ns:SqlTraceCollector>InputParameters{C2B0D6E3-585D-4357-9C80-12E7B8000299}0User002345MSSQL.1InstanceID{9E6FBB1C-469F-44CC-839D-A0B5EE84CEF4}0User002345MSSQLSERVERInstanceName{8BFB15C6-3D9A-4C4D-B1F4-B4EBF49B8D65}0User0067890ItemID{43E08441-AEAE-4004-87B5-B11D2507FCF6}0User0067892LoggingLevel{B7F59CF4-A8A0-4E82-93A0-E52E8E859904}0User0067890LogID{E466E841-5C40-48CB-8CFC-E678F9967C80}0User002345LOOPEVENTLoopEventName{049D5A2B-A19C-4F1B-8036-0392BC42CE3A}0User002345Provider=SQLNCLI10;Data Source=(local);Integrated Security=SSPI;Initial Catalog=myMDW;APP=SQL Server Data CollectorMDWConnectionString{A6803296-75B6-41BC-B261-1EA8C279A888}0User0067890ParentLogID{F21C218D-AA71-457B-99D0-CE63B7012CA4}0User002345RowCountIn{59D1463F-2A4E-4399-BFE9-814648EBDB91}0User0067890SnapshotID{B649CEEE-C1E3-4434-A3BC-86FC468A9EDD}0User0067890SourceID{9D4E5F6C-F05E-42AD-8E32-8D215CBC25DD}0User002345Provider=SQLNCLI10;Data Source=(local);Integrated Security=SSPI;APP=SQL Server Data CollectorTargetConnectionString{5D48AFDE-B6ED-4AD2-A721-030A19BBB2BB}0User0023452007-03-13 14:28:51.820TraceCurrentEventTime{5D57E938-0D8F-4C71-959A-C20D0BAD5C09}0User002345C:\Users\macies\AppData\Local\Temp\ecodedc\DC_Trace_MSSQL.1.f37780d4-fea7-4271-90b2-fa553ad4ca91.0_1.trcTraceCurrentFile{72FDA754-43D5-4AAC-930C-6074C64CE825}0User0067890TraceDroppedEventCount{7B00BCC4-67F6-4480-8034-2836E0929FE8}0User0067890TraceID{00FC8CA7-8D41-4099-9A78-865E9CB964A4}0User0067890TraceInfoID{E9DB8444-2521-4213-8DDE-2F19885D8E74}0User0067890TraceIsRunning{39F34FBD-911E-4F15-847D-577DC76049CA}0User0023450TraceLastEventSequence{0D1478BA-31B7-42AD-8762-50342593C49C}@[User::CacheDirectory] + "\\DC_Trace_" + @[System::MachineName] + "." + @[User::InstanceID] + "." + @[User::CollectionSetUID] + "." + (DT_WSTR, 5) @[User::ItemID]-1User002345\DC_Trace_NIMESHDEVMC.MSSQL.1..0TraceLocation{7C0FFEA0-C638-49F3-AA0D-9DCA4A372559}0User0023452007-03-13 14:24:40.000TraceStartTime{E5277DAE-C666-41F7-B34E-3B58DC087855}0User0023450TraceUseDefault{8F4EF19C-F61E-4CEE-BE5A-A73B4EA5A710}102,7,OnError,9,OnWarning-1-1-1-1-1-1-1-1-1-1-1-1-1-10XML Task; Microsoft Corporation; Microsoft SQL Server code name "Katmai"; © 2007 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;100-100-101048576-11001XML - Check use_default attribute{DB542074-1D89-441B-BA2B-E1E55527C2B8}XML TaskMicrosoft.SqlServer.Dts.Tasks.XMLTask.XMLTask, Microsoft.SqlServer.XMLTask, 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-101048576-11020SQL - Get trace info{33CFBECB-7DAD-4256-811D-FED4E423755D}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-101048576-11020SQL - Update data source{D8732C3C-BF2D-40C6-BA2E-AF18493924AC}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-101048576-11020SQL - Get last upload time{0F29500B-BB42-4603-AB36-A6C75CFC649B}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-101048576-11020SQL - Get snapshot id{C316D13F-2EEE-42A1-B307-924555587091}Execute SQL TaskMicrosoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91000-100-101048576-11-10User0067890RowCountError{AD706893-04C6-4F6A-851B-6E8961A23D59}0User0067890RowCountIn{CCB242CF-14BC-4978-B629-AC8BDA3637AA}0User0067890RowCountOut{F61B5459-D245-44A4-8FFF-694915DE1C25}01000-100-101048576-11-1"DECLARE @trace_file_name nvarchar(512)
SELECT @trace_file_name = path FROM sys.traces WHERE is_default=1
SELECT
[TextData],
[BinaryData],
[DatabaseID],
[TransactionID],
[LineNumber],
[NTUserName],
[NTDomainName],
[HostName],
[ClientProcessID],
[ApplicationName],
[LoginName],
[SPID],
[Duration],
[StartTime],
[EndTime],
[Reads],
[Writes],
[CPU],
[Permissions],
[Severity],
[EventSubClass],
[ObjectID],
[Success],
[IndexID],
[IntegerData],
[ServerName],
[EventClass],
[ObjectType],
[NestLevel],
[State],
[Error],
[Mode],
[Handle],
[ObjectName],
[DatabaseName],
[FileName],
[OwnerName],
[RoleName],
[TargetUserName],
[DBUserName],
[LoginSid],
[TargetLoginName],
[TargetLoginSid],
[ColumnPermissions],
[LinkedServerName],
[ProviderName],
[MethodName],
[RowCounts],
[RequestID],
[XactSequence],
[EventSequence],
[BigintData1],
[BigintData2],
[GUID],
[IntegerData2],
[ObjectID2],
[Type],
[OwnerID],
[ParentName],
[IsSystem],
[Offset],
[SourceDatabaseID],
[SqlHandle],
[SessionLoginName],
[PlanHandle]
, [GroupID] FROM
::fn_trace_gettable(@trace_file_name, default)
WHERE
[EventSequence] > " + @[User::TraceLastEventSequence]-1User002345DECLARE @trace_file_name nvarchar(512)
SELECT @trace_file_name = path FROM sys.traces WHERE is_default=1
SELECT
[TextData],
[BinaryData],
[DatabaseID],
[TransactionID],
[LineNumber],
[NTUserName],
[NTDomainName],
[HostName],
[ClientProcessID],
[ApplicationName],
[LoginName],
[SPID],
[Duration],
[StartTime],
[EndTime],
[Reads],
[Writes],
[CPU],
[Permissions],
[Severity],
[EventSubClass],
[ObjectID],
[Success],
[IndexID],
[IntegerData],
[ServerName],
[EventClass],
[ObjectType],
[NestLevel],
[State],
[Error],
[Mode],
[Handle],
[ObjectName],
[DatabaseName],
[FileName],
[OwnerName],
[RoleName],
[TargetUserName],
[DBUserName],
[LoginSid],
[TargetLoginName],
[TargetLoginSid],
[ColumnPermissions],
[LinkedServerName],
[ProviderName],
[MethodName],
[RowCounts],
[RequestID],
[XactSequence],
[EventSequence],
[BigintData1],
[BigintData2],
[GUID],
[IntegerData2],
[ObjectID2],
[Type],
[OwnerID],
[ParentName],
[IsSystem],
[Offset],
[SourceDatabaseID],
[SqlHandle],
[SessionLoginName],
[PlanHandle]
, [GroupID] FROM
::fn_trace_gettable(@trace_file_name, default)
WHERE
[EventSequence] > 0TraceLoadScript{a2d94ca5-a845-4067-8951-906992367f42}20DFT - Upload default trace file{ed5bc122-e2d0-47fe-9a21-91b4d462f083}Data Flow TaskSSIS.Pipeline.20User::RowCountOut0025User::RowCountIn0{call snapshots.sp_trace_update_info(?, ?, ?, ?, ?, ?)}12528181658181810User::TraceLoadScript1252false3User::RowCountError0[snapshots].[trace_data]1252false3falsefalseCHECK_CONSTRAINTS00Execute SQL Task; Microsoft Corporation; Microsoft SQL Server v9; © 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;100-100001048576-11-1DATEDIFF("millisecond", @[System::ContainerStartTime] , GETDATE() )-1User0023457127170LoopDuration{74950c5e-3a60-494f-83a3-e04e64e1217f}20SQL - Log package stats{147f8f7a-f829-4ac7-a038-03943f58ee3b}Logs statistics about the most recent Data Flow TaskMicrosoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91023-1@[LoggingLevel] >= 1Constraint{AEDEEA80-FB4F-4737-B938-B2909C835D5A}SEQ - Default trace upload{38B4A79F-D07D-418D-BA5A-2AF603D6620F}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-100-101048576-11020SQL - Close trace{EAA2093E-36E6-4EA8-A5E9-E568C5A46516}Execute SQL TaskMicrosoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc910@Counter = 0@Counter < 2@Counter = @Counter + 1100-100011048576-11001{821B0536-E431-458F-8EAE-028BE667F142}{821B0536-E431-458F-8EAE-028BE667F142}DTS.ForEachFileEnumerator.2@[User::CacheDirectory]"DC_Trace_" + @[System::MachineName] + "." + @[User::InstanceID] + "." + @[User::CollectionSetUID] + "." + (DT_WSTR, 5) @[User::ItemID] + "*.trc"100-100-101048576-1100User0067890RowCountError{3D6F8AD1-3C96-4920-B28C-F360CA77AEFD}0User0067890RowCountIn{3ED87BA4-E9D0-4FC4-A1A1-47A19C6EDF3B}0User0067890RowCountOut{491029A7-AEDE-4DAC-B07E-7C134EF63963}200File Access;Microsoft Corporation; Microsoft SQL Server codename Katmai; (C) 2007 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;100-100001048576-11001@[User::TraceCurrentFile]4FAT - Precheck if trace file is accessible{BCAA70EC-FD75-4E75-9698-7459FF0FB8BB}File Access TaskDTS.FileAccessTask.104C:\Users\macies\AppData\Local\Temp\ecodedc\DC_Trace_MSSQL.1.f37780d4-fea7-4271-90b2-fa553ad4ca91.0_1.trc000-100-101048576-11-1"SELECT
[TextData],
[BinaryData],
[DatabaseID],
[TransactionID],
[LineNumber],
[NTUserName],
[NTDomainName],
[HostName],
[ClientProcessID],
[ApplicationName],
[LoginName],
[SPID],
[Duration],
[StartTime],
[EndTime],
[Reads],
[Writes],
[CPU],
[Permissions],
[Severity],
[EventSubClass],
[ObjectID],
[Success],
[IndexID],
[IntegerData],
[ServerName],
[EventClass],
[ObjectType],
[NestLevel],
[State],
[Error],
[Mode],
[Handle],
[ObjectName],
[DatabaseName],
[FileName],
[OwnerName],
[RoleName],
[TargetUserName],
[DBUserName],
[LoginSid],
[TargetLoginName],
[TargetLoginSid],
[ColumnPermissions],
[LinkedServerName],
[ProviderName],
[MethodName],
[RowCounts],
[RequestID],
[XactSequence],
[EventSequence],
[BigintData1],
[BigintData2],
[GUID],
[IntegerData2],
[ObjectID2],
[Type],
[OwnerID],
[ParentName],
[IsSystem],
[Offset],
[SourceDatabaseID],
[SqlHandle],
[SessionLoginName],
[PlanHandle]
, [GroupID] FROM
::fn_trace_gettable(N'" + @[User::TraceCurrentFile] + "', 1)
WHERE
[EventSequence] > " + @[User::TraceLastEventSequence]-1User002345SELECT
[TextData],
[BinaryData],
[DatabaseID],
[TransactionID],
[LineNumber],
[NTUserName],
[NTDomainName],
[HostName],
[ClientProcessID],
[ApplicationName],
[LoginName],
[SPID],
[Duration],
[StartTime],
[EndTime],
[Reads],
[Writes],
[CPU],
[Permissions],
[Severity],
[EventSubClass],
[ObjectID],
[Success],
[IndexID],
[IntegerData],
[ServerName],
[EventClass],
[ObjectType],
[NestLevel],
[State],
[Error],
[Mode],
[Handle],
[ObjectName],
[DatabaseName],
[FileName],
[OwnerName],
[RoleName],
[TargetUserName],
[DBUserName],
[LoginSid],
[TargetLoginName],
[TargetLoginSid],
[ColumnPermissions],
[LinkedServerName],
[ProviderName],
[MethodName],
[RowCounts],
[RequestID],
[XactSequence],
[EventSequence],
[BigintData1],
[BigintData2],
[GUID],
[IntegerData2],
[ObjectID2],
[Type],
[OwnerID],
[ParentName],
[IsSystem],
[Offset],
[SourceDatabaseID],
[SqlHandle],
[SessionLoginName],
[PlanHandle]
, [GroupID] FROM
::fn_trace_gettable(N'C:\Users\macies\AppData\Local\Temp\ecodedc\DC_Trace_MSSQL.1.f37780d4-fea7-4271-90b2-fa553ad4ca91.0_1.trc', 1)
WHERE
[EventSequence] > 0TraceLoadScript{76E0DEBC-BF6A-45D2-A30B-EB6746BEB47B}20DFT - Upload trace file{96A9329D-379F-466F-970B-4A97A3FCF7A1}Data Flow TaskSSIS.Pipeline.20User::RowCountInUser::RowCountOut00250{call snapshots.sp_trace_update_info(?, ?, ?, ?, ?, ?)}12528181658181810User::TraceLoadScript1252false3User::RowCountError0[snapshots].[trace_data]1252false3falsefalseCHECK_CONSTRAINTS00File Access;Microsoft Corporation; Microsoft SQL Server codename Katmai; (C) 2007 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;100-100001048576-11-101@[User::TraceCurrentFile]6FAT - Check if trace file is accessible{679134AC-EFFB-4A28-B2C2-4247D71FEE23}File Access TaskDTS.FileAccessTask.106C:\Users\macies\AppData\Local\Temp\ecodedc\DC_Trace_MSSQL.1.f37780d4-fea7-4271-90b2-fa553ad4ca91.0_1.trc0File System Task;Microsoft Corporation; Microsoft SQL Server v9; © 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;100000001048576-11-1202,7,OnError,9,OnWarning-1-1-1-1-1-1-1-1-1-1-1-1-1-1FST - Delete trace file{5EE7C74E-CD4E-40E2-8D32-7475CF6457B1}File System TaskMicrosoft.SqlServer.Dts.Tasks.FileSystemTask.FileSystemTask, Microsoft.SqlServer.FileSystemTask, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc910-454761244OnError00-100011048576-110@[System::ErrorCode] != -10735485400System0067890Propagate{6C9DBDD1-7561-4A92-87F2-521B9881BB19}The propagate property of the event01{582131DF-655C-41F3-B0E7-5D7E8FDBB56F}OnError0Execute SQL Task; Microsoft Corporation; Microsoft SQL Server v9; © 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;100-100001048576-11-1DATEDIFF("millisecond", @[System::ContainerStartTime] , GETDATE() )-1User0023457127236LoopDuration{B2278345-853A-4BC7-BC04-346F236BE117}20SQL - Log package stats{7FE278CC-D8C4-4CCD-B884-D4FD9790D5A0}Logs statistics about the most recent Data Flow 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 code name "Katmai"; © 2007 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;100-100011048576-11001SQL - logs uploaded file name{36601F9F-22D5-41EB-AC7D-0CBF2756CC8C}SQL - logs uploaded file nameMicrosoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91023-1@[LoggingLevel] >= 1Constraint 1{41B4AC86-833E-417B-A00D-2259D0C87E35}02-1Constraint{4184AC42-F94B-469C-A49E-EE793CB1D245}02-1Constraint 2{0957B7CD-F748-44F6-BD2F-9A5B335C4F16}23-1@[LoggingLevel] > 1Constraint 3{A52A42F1-5767-464E-AEBC-F8FB69B7BAC4}02-1Constraint 4{1963E80B-FFFB-425B-AEF5-0F6F5BE8FFA2}FEF - For each trace file - regular trace upload{26A8C112-8CCB-4C21-BADC-77E438246248}Foreach Loop ContainerSTOCK:FOREACHLOOP0User::TraceCurrentFile0{2FE5FF29-A973-47A2-AAF5-B529588DB38B}{2FE5FF29-A973-47A2-AAF5-B529588DB38B}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-101048576-11020SQL - Get Last_Event_Sequence{1fe772eb-42ae-4641-af91-138c98b8fcba}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-100001048576-11020SQL - Check trace info{782c9195-15b2-4260-bff9-6d85b486e50f}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-101048576-11020SQL - Close trace{0b304887-a5f5-48be-a81e-48ab362bfe41}Execute SQL TaskMicrosoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91003-1@[User::TraceIsRunning] == 0Constraint 1{77861B0E-1726-4FE2-BEC6-4CAB5CEE2AFA}22-1Constraint{3392402A-8EDF-40CA-B868-CE800491C3A4}02-1Constraint 2{0B57ACB1-DDFE-4E1F-909A-36BF193C6D15}For Loop Container{ECC401D1-FE83-46E6-AD37-0E1F711F0C62}For Loop ContainerSTOCK:FORLOOP002-1Constraint{2DBE8AE5-8C75-44A9-8C57-D571678FF149}02-1Constraint 1{9C582F44-453F-431A-80FE-D79155C6E519}02-1Constraint 2{8D136BE7-D0D6-486D-85E9-D64DB633850E}02-1Constraint 6{5545F925-D433-4F90-93FD-D3E432AE1D83}03-1@[User::TraceUseDefault] == "1"Constraint 8{58C2147A-C7A3-4809-95AB-F70A1F1C57BF}03-1@[User::TraceIsRunning] == 0Constraint 5{285C2E0E-D5D3-467A-8237-E0B32D55C912}010@[User::SnapshotID] != 0 && @[User::TraceUseDefault] != "1"Constraint 3{0E7EF1B1-B857-44B2-87BF-CA42682C6354}SqlTraceUpload{F389A8E6-5A17-4056-ABFD-C8B823F2092E}SSIS.Package.20