Package element: ConfigConnection
Properties
| Name | Value |
| ConnectionString | Data Source=(local);Initial Catalog=msdb;Provider=SQLNCLI11;Integrated Security=SSPI;APP=SQL Server Data Collector; |
| CreationName | OLEDB |
| DelayValidation | False |
| Description | Connection used to get information about collection configuration and for logging purposes. |
| HasExpressions | True |
| HostType | ConnectionManager |
| ID | {C9A06CAE-CFEE-4A26-BE59-A3A222474CCB} |
| InitialCatalog | msdb |
| Name | ConfigConnection |
| OfflineMode | False |
| ProtectionLevel | EncryptSensitiveWithUserKey |
| Qualifier | |
| RetainSameConnection | False |
| Scope | Package |
| ServerName | (local) |
| SupportsDTCTransactions | True |
| UserName |
Elements
| Name | Description | Type |
| ConnectionString | Expressions | |
| CacheDirectory | Variables | |
| CacheWindow | Variables | |
| CollectionSetUID | Variables | |
| CollectorTypeUID | Variables | |
| ConfigConnectionString | Variables | |
| Counter | Variables | |
| DaysUntilExpiration | Variables | |
| ExitEventName | Variables | |
| InputParameters | Variables | |
| InstanceID | Variables | |
| InstanceName | Variables | |
| ItemID | Variables | |
| LoggingLevel | Variables | |
| LogID | Variables | |
| LoopEventName | Variables | |
| MDWConnectionString | Variables | |
| ParentLogID | Variables | |
| RowCountIn | Variables | |
| SnapshotID | Variables | |
| SourceID | Variables | |
| TargetConnectionString | Variables | |
| TraceCurrentEventTime | Variables | |
| TraceCurrentFile | Variables | |
| TraceDroppedEventCount | Variables | |
| TraceID | Variables | |
| TraceInfoID | Variables | |
| TraceIsRunning | Variables | |
| TraceLastEventSequence | Variables | |
| TraceLocation | Variables | |
| TraceStartTime | Variables | |
| TraceUseDefault | Variables |
See also