6@[User::ConfigConnectionString]@[User::MDWConnectionString]@[User::TargetConnectionString]C:\DOCUME~1\apred\LOCALS~1\Temp\eKatmai_DCC:\DOCUME~1\apred\LOCALS~1\Temp\eKatmai_DC\SETHS-SSISVSTA2_MSSQL.1_640012b7-4ed0-4865-a636-4946d73c425f_0.cacheC:\DOCUME~1\apred\LOCALS~1\Temp\eKatmai_DC\SETHS-SSISVSTA2_MSSQL.1_640012b7-4ed0-4865-a636-4946d73c425f_0_upload_copyat_2011-04-08-14-56-38.956000000.cacheSETHS-SSISVSTA2_MSSQL.1_640012b7-4ed0-4865-a636-4946d73c425f_0_upload_copyat_1640012b7-4ed0-4865-a636-4946d73c425f294605dd-21de-40b2-b20f-f3e170ea1ec3Provider=SQLNCLI11;Data Source=(local);Integrated Security=SSPI;Initial Catalog=msdb;APP=SQL Server Data Collector0EXITEVENTMSSQL.1(local)020LOOPEVENTProvider=SQLNCLI11;Data Source=(local);Integrated Security=SSPI;Initial Catalog=MDW;APP=SQL Server Data Collector060Provider=SQLNCLI11;Data Source=(local);Integrated Security=SSPI;APP=SQL Server Data Collector2,7,OnError,9,OnWarning-1-1-1-1-1-1-1-1-1-1-1-1-1-10"User::CacheUploadFilesPrefixPattern"@[User::CacheDirectory]@[User::CacheUploadFilesPrefixPattern] + "*.cache"c:\perflogs\MACIES4_MSSQL.1_640012b7-4ed0-4865-a636-4946d73c425f_0.cache9560000

@[User::SnapshotID]@[User::SnapshotID](DT_DBTIMESTAMP2,1)#{Package\FEF - For Each Collected Cache File Remaining, Try to Upload\DFT - Bulk Insert Collected data into MDW\RAW - Read current tempoary storage.Outputs[Raw File Source Output].Columns[collection_time]}(DT_DBTIMESTAMP2,1)collection_time

SELECT path, performance_counter_id FROM snapshots.performance_counter_instancesSELECT [path], [performance_counter_id] FROM [snapshots].[performance_counter_instances] WHERE [path] = ?055<referenceMetadata><referenceColumns><referenceColumn name="path" dataType="DT_WSTR" length="2048" precision="0" scale="0" codePage="0"/><referenceColumn name="performance_counter_id" dataType="DT_I4" length="0" precision="0" scale="0" codePage="0"/></referenceColumns></referenceMetadata>#{Package\FEF - For Each Collected Cache File Remaining, Try to Upload\DFT - Bulk Insert Collected data into MDW\RAW - Read current tempoary storage.Outputs[Raw File Source Output].Columns[path]};1252010falsepath

performance_counter_id

0[snapshots].[performance_counter_values]1252false3falsefalseCHECK_CONSTRAINTS1000

1User::CacheFileToUpload

User::RowCountError

User::RowCountIn

User::RowCountOut

0[snapshots].[performance_counter_instances]1252false3falsefalse1000

1User::CacheFileToUpload

PerfCountersLock@[User::CacheFileName]00C:\DOCUME~1\apred\LOCALS~1\Temp\eKatmai_DC\SETHS-SSISVSTA2_MSSQL.1_640012b7-4ed0-4865-a636-4946d73c425f_0.cache