Package element: SQL - Register collection set to MDW

CollapseAll image

Collapse image Properties


 Name   Value 
ApartmentThreaded True
BypassPrepare True
CodePage 1252
Connection MdwConnection
CreationName Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
DebugMode False
DelayValidation True
Description Execute SQL Task
Disable False
DisableEventHandlers False
ExecutionDuration 0
ExecutionResult Success
ExecutionStatus None
FailPackageOnFailure False
FailParentOnFailure True
ForcedExecutionValue 0
ForceExecutionResult None
ForceExecutionValue False
HasExpressions False
HostType Task
ID {a3667210-4432-41f0-8d04-d53b10574f52}
IsDefaultLocaleID True
IsolationLevel Serializable
IsStoredProcedure False
LocaleID English (United States)
LoggingMode Disabled
MaximumErrorCount 0
Name SQL - Register collection set to MDW
ResultSetType 1
SqlStatementSource
execute [core].[sp_update_data_source]
  @collection_set_uid=?
, @machine_name=?
, @named_instance=?
, @days_until_expiration=?
, @source_id=? OUTPUT
SqlStatementSourceType Direct Input
SuspendRequired False
TargetServerVersion 130
TimeOut 0
TransactionOption Supported
TypeConversionMode 2
Version 0

Collapse image Elements


 Name   Description   Type 
ExecuteSQLExecutingQuery Provides information about executing an SQL query. LogEntryInfos
CacheDirectory   Variables
CacheFileName   Variables
CacheOutput   Variables
CacheUploadFilesPrefixPattern   Variables
CacheWindow   Variables
CollectionSetUID   Variables
CollectorTypeUID   Variables
ConfigConnectionString   Variables
DaysUntilExpiration   Variables
ExitEventName   Variables
InputParameters   Variables
InstanceID   Variables
InstanceName   Variables
ItemID   Variables
LoggingLevel   Variables
LogID   Variables
LoopEventName   Variables
MDWConnectionString   Variables
ParentLogID   Variables
SnapshotID   Variables
SourceID   Variables
TargetConnectionString   Variables

Collapse image See also


Package index