6@[User::ConfigConnectionString]@[User::MDWConnectionString]@[User::TargetConnectionString]1{0E218CF8-ECB5-417B-B533-D851C0251271}Provider=SQLNCLI11;Data Source=(local);Integrated Security=SSPI;Initial Catalog=msdb;APP=SQL Server Data Collector00EXITEVENT<ns:SqlTraceCollector xmlns:ns="DataCollectorType" use_default="1"><Events/><Filters/></ns:SqlTraceCollector>MSSQL.1MSSQLSERVER020LOOPEVENTProvider=SQLNCLI11;Data Source=(local);Integrated Security=SSPI;Initial Catalog=myMDW;APP=SQL Server Data Collector000Provider=SQLNCLI11;Data Source=(local);Integrated Security=SSPI;APP=SQL Server Data Collector2007-03-13 14:28:51.820C:\Users\macies\AppData\Local\Temp\ecodedc\DC_Trace_MSSQL.1.f37780d4-fea7-4271-90b2-fa553ad4ca91.0_1.trc00000\DC_Trace_SETHS-SSISVSTA2.MSSQL.1..02007-03-13 14:24:40.00002,7,OnError,9,OnWarning-1-1-1-1-1-1-1-1-1-1-1-1-1-1@[User::CacheDirectory]"DC_Trace_" + @[System::MachineName] + "." + @[User::InstanceID] + "." + @[User::CollectionSetUID] + "." + (DT_WSTR, 5) @[User::ItemID] + "*.trc"000SELECT [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] > 00025

0#{Package\For Loop Container\FEF - For each trace file - regular trace upload\DFT - Upload trace file\ODB - Read trace.Outputs[OLE DB Source Output].Columns[EventSequence]}710#{Package\For Loop Container\FEF - For each trace file - regular trace upload\DFT - Upload trace file\0:invalid}210

User::RowCountError

User::RowCountIn

User::RowCountOut

#{Package\For Loop Container\FEF - For each trace file - regular trace upload\DFT - Upload trace file\ODB - Read trace.Outputs[OLE DB Source Output].Columns[SqlHandle]}false#{Package\For Loop Container\FEF - For each trace file - regular trace upload\DFT - Upload trace file\ODB - Read trace.Outputs[OLE DB Source Output].Columns[PlanHandle]}false

@[User::TraceInfoID]@[User::TraceInfoID]@[User::SnapshotID]@[User::SnapshotID]@[User::TraceIsRunning]@[User::TraceIsRunning]@[User::TraceDroppedEventCount]@[User::TraceDroppedEventCount][ISNULL](#{Package\For Loop Container\FEF - For each trace file - regular trace upload\DFT - Upload trace file\AGG - Get max value of EventSequence.Outputs[Aggregate Output 1].Columns[EventSequence_Max]}) ? 0 : #{Package\For Loop Container\FEF - For each trace file - regular trace upload\DFT - Upload trace file\AGG - Get max value of EventSequence.Outputs[Aggregate Output 1].Columns[EventSequence_Max]}ISNULL(EventSequence_Max) ? 0 : EventSequence_Max

@[User::TraceInfoID]@[User::TraceInfoID]@[SnapshotID]@SnapshotID

0User::TraceLoadScript1252false3

0{call snapshots.sp_trace_update_info(?, ?, ?, ?, ?, ?)}1252818165818181

0[snapshots].[trace_data]1252false3falsefalseCHECK_CONSTRAINTS0

@[User::TraceCurrentFile]66C:\Users\macies\AppData\Local\Temp\ecodedc\DC_Trace_MSSQL.1.f37780d4-fea7-4271-90b2-fa553ad4ca91.0_1.trc@[User::TraceCurrentFile]44C:\Users\macies\AppData\Local\Temp\ecodedc\DC_Trace_MSSQL.1.f37780d4-fea7-4271-90b2-fa553ad4ca91.0_1.trc2,7,OnError,9,OnWarning-1-1-1-1-1-1-1-1-1-1-1-1-1-10766000DECLARE @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] > 00025

0#{Package\SEQ - Default trace upload\DFT - Upload default trace file\ODB - Read trace.Outputs[OLE DB Source Output].Columns[EventSequence]}710#{Package\SEQ - Default trace upload\DFT - Upload default trace file\0:invalid}210

User::RowCountError

User::RowCountIn

User::RowCountOut

#{Package\SEQ - Default trace upload\DFT - Upload default trace file\ODB - Read trace.Outputs[OLE DB Source Output].Columns[SqlHandle]}false#{Package\SEQ - Default trace upload\DFT - Upload default trace file\ODB - Read trace.Outputs[OLE DB Source Output].Columns[PlanHandle]}false

@[User::TraceInfoID]@[User::TraceInfoID]@[User::SnapshotID]@[User::SnapshotID]@[User::TraceIsRunning]@[User::TraceIsRunning]@[User::TraceDroppedEventCount]@[User::TraceDroppedEventCount][ISNULL](#{Package\SEQ - Default trace upload\DFT - Upload default trace file\AGG - Get max value of EventSequence.Outputs[Aggregate Output 1].Columns[EventSequence_Max]}) ? 0 : #{Package\SEQ - Default trace upload\DFT - Upload default trace file\AGG - Get max value of EventSequence.Outputs[Aggregate Output 1].Columns[EventSequence_Max]}ISNULL(EventSequence_Max) ? 0 : EventSequence_Max

@[User::TraceInfoID]@[User::TraceInfoID]@[SnapshotID]@SnapshotID

0User::TraceLoadScript1252false3

0{call snapshots.sp_trace_update_info(?, ?, ?, ?, ?, ?)}1252818165818181

0[snapshots].[trace_data]1252false3falsefalseCHECK_CONSTRAINTS0

656