312:00:00 AM501010299{E24C6D00-94C6-457B-BED4-1F9F018F3273}-1000-1ConfigConnection{AEC0A8A9-5B1C-457A-AC2A-02CBC707C18F}OLEDB@[User::ConfigConnectionString]00CacheDirectory\Package.Variables[User::CacheDirectory].Properties[Value]CacheDirectory{0D194526-2231-4E15-ADD8-5B79F8AF8E01}0CacheWindow\Package.Variables[User::CacheWindow].Properties[Value]CacheWindow{DF4E562E-F822-4769-8491-98E8376B98B2}0InputParameters\Package.Variables[User::InputParameters].Properties[Value]InputParameters{6A6FBA91-2007-409B-AF94-29445E33CAC1}0MDWConnectionString\Package.Variables[User::MDWConnectionString].Properties[Value]MDWConnectionString{D09F3056-C5FD-4657-872A-7B0444EA970E}0ConfigConnectionString\Package.Variables[User::ConfigConnectionString].Properties[Value]ConfigConnectionString{790D96A0-7BA0-4F09-AAEA-961EA3F94425}0TargetConnectionString\Package.Variables[User::TargetConnectionString].Properties[Value]TargetConnectionString{2A6ECF67-DD82-4A3B-A3FB-CC7320A598BD}0LoopEventName\Package.Variables[User::LoopEventName].Properties[Value]LoopEventName{6D9EFBB5-C6DB-42DE-AFDA-DCCAE4BA3B12}0ExitEventName\Package.Variables[User::ExitEventName].Properties[Value]ExitEventName{9D4C69F2-6A0B-45D5-86BC-E2C2AA453765}0CollectorTypeUID\Package.Variables[User::CollectorTypeUID].Properties[Value]CollectorTypeUID{69421C05-A1DD-4D95-9500-B3BF16625BEB}0CollectionSetUID\Package.Variables[User::CollectionSetUID].Properties[Value]CollectionSetUID{08CA8103-3278-439A-BE50-C493D2B23232}0ItemID\Package.Variables[User::ItemID].Properties[Value]ItemID{340ED124-0551-4559-8BC2-238857009440}0InstanceID\Package.Variables[User::InstanceID].Properties[Value]InstanceID{AD10F8E4-4A7F-44A6-82C3-C1F9F153D9CB}0InstanceName\Package.Variables[User::InstanceName].Properties[Value]InstanceName{E41EBE67-77EC-449A-B356-37FC1E601599}0LoggingLevel\Package.Variables[User::LoggingLevel].Properties[Value]LoggingLevel{FE42EC47-57AC-4D36-8C23-648257EB96D3}0LogID\Package.Variables[User::LogID].Properties[Value]LogID{C5E7323D-D8F4-4ADE-98ED-0AFF92FE8B4F}0ParentLogID\Package.Variables[User::ParentLogID].Properties[Value]ParentLogID{700D5C4C-836B-4C4C-8019-CAEB5C847D08}0IsSystem\Package.Variables[User::IsSystem].Properties[Value]IsSystem{5A86C955-9B26-486F-AAA6-EFA4792606D2}10.0.1101.000-10000104857610331-10User00CacheDirectory{1B2FE2EF-38F1-4799-965C-63C40B21622F}0User000CacheWindow{4761F201-BFE5-490A-B423-C634368AB44F}0User00CollectionPackageName{0D1C319C-F2F3-4804-B5E0-C3BFE0223148}0User00CollectionPackageUID{8705E2CB-1BED-4A22-B6D8-DFD641CFA12B}0User00CollectionSetUID{098D52E0-2021-4C96-8177-2713C20AD43E}0User00{302E93D1-3424-4be7-AA8E-84813ECF2419}CollectorTypeUID{FD369CEF-D87D-4D54-B841-4B2C725A811F}0User00ConfigConnectionString{2C9FB021-31C4-43A3-9B3E-6D388F6477EC}0User00ExitEventName{4667D1C6-348C-451B-A1DE-B6CBA23DE979}0User00InputParameters{2A45E70A-82E0-4EB4-8A46-B0651FEF332C}0User00InstanceID{FFA722B7-2975-40DC-BFC5-5A40B3D3C96F}0User00InstanceName{0FFDB8A8-51C7-42C1-B634-4EEE2D5FBF3E}0User000IsSystem{95B03165-BC22-46E4-9BE2-9CD6D6BE6BE7}0User000ItemID{D5F7341A-D034-4787-8E26-B517BC24A6FA}0User000LoggingLevel{CFF9FD21-E4DE-49F0-8598-91EC9A8FAD45}0User000LogID{B05EE1AD-27A2-430B-80FE-83AA080CF3B4}0User000LoopDuration{A3840CC6-6A2F-45BC-BDBA-7DC1E7CC198F}0User00LoopEventName{BF53936A-4A19-4927-9549-7AFB163C82DA}0User00MDWConnectionString{844CC386-E5A3-4FA4-BA8F-15BC4AB835E7}0User000ParentLogID{7AD509B2-5065-4D5F-8E21-B7FB2E52C33F}0User00TargetConnectionString{C24E0CC0-CF2A-4E62-B3EC-6B1FAC1E70B5}0User00UploadPackageName{47B6C3EE-F837-405C-BF91-1E585103E92B}0User00UploadPackageUID{A4DA5DCD-C582-4910-9C64-FA667B5159E2}105,7,OnError,13,OnPostExecute,12,OnPreExecute,10,OnProgress,9,OnWarning-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-10Execute 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 Package Name{0B3FB8D2-D701-4844-907E-77BC846D11AD}Execute SQL TaskMicrosoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc9100Generate TSQL Package Task; Microsoft Corporation; Microsoft SQL Server v10; © 2007 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;100-100-101048576-110203,7,OnError,13,OnInformation,9,OnWarning-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1GenerateTSQLPackageTask{658EAD60-7032-4546-B7AA-804769187BEF}GenerateTSQLPackageTaskMicrosoft.SqlServer.Management.Collector.Tasks.GenerateTSQLPackageTask, Microsoft.SqlServer.Management.CollectorTasks, 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 - Record Generated Packages{8C747FF6-E3F0-4455-81D1-4897B3BA140F}Execute SQL TaskMicrosoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc9100Executes DTS packages;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-100"\\Data Collector\\Generated\\" + @[User::CollectionPackageName]EPT - Run Generated Package{B4059538-BC87-4EA8-AD12-E5419D2D2B5A}Execute Package TaskSSIS.ExecutePackageTask.20False\Data Collector\Generated\{AEC0A8A9-5B1C-457A-AC2A-02CBC707C18F}03-1@[User::CollectionPackageName] == ""Constraint 5{B9EFE0DB-E8F5-4401-9A7B-DCC6AED9C9E6}030@[User::CollectionPackageName] != ""Constraint 6{70FCA6D0-A25B-4993-B6AF-56420E2C16EF}02-1Constraint 7{166001E1-DD7E-45D8-AEB4-11A07708C0FB}020Constraint 3{0C47F9C8-49AD-4680-B81F-62070E80A0B8}TSQLQueryCollect{292B1476-0F46-4490-A9B7-6DB724DE3C0B}SSIS.Package.20