sp_syscollector_create_collector_type (Transact-SQL)
Applies to: SQL Server
Creates a collector type for the data collector. A collector type is a logical wrapper around the SSIS packages that provide the actual mechanism for collecting data and uploading it to the management data warehouse.
Transact-SQL syntax conventions
Syntax
sp_syscollector_create_collector_type
[ [ @collector_type_uid = ] 'collector_type_uid' OUTPUT ]
, [ @name = ] N'name'
[ , [ @parameter_schema = ] N'parameter_schema' ]
[ , [ @parameter_formatter = ] N'parameter_formatter' ]
, [ @collection_package_id = ] 'collection_package_id'
, [ @upload_package_id = ] 'upload_package_id'
[ ; ]
Arguments
[ @collector_type_uid = ] 'collector_type_uid' OUTPUT
The GUID for the collector type. @collector_type_uid is an OUTPUT parameter of type uniqueidentifier. If @collector_type_uid is NULL
it will be automatically created and returned as OUTPUT.
[ @name = ] N'name'
The name of the collector type. @name is sysname, and must be specified.
[ @parameter_schema = ] N'parameter_schema'
The XML schema for this collector type. @parameter_schema is xml, with a default of NULL
.
[ @parameter_formatter = ] N'parameter_formatter'
The template to use to transform the XML for use in the collection set property page. @parameter_formatter is xml, with a default of NULL
.
[ @collection_package_id = ] 'collection_package_id'
A local unique identifier that points to the SSIS collection package used by the collection set. @collection_package_id is uniqueidentifier, and is required.
[ @upload_package_id = ] 'upload_package_id'
A local unique identifier that points to the SSIS upload package used by the collection set. @upload_package_id is uniqueidentifier, and is required.
Return code values
0
(success) or 1
(failure).
Permissions
Requires membership in the dc_admin (with EXECUTE permission) fixed database role to execute this procedure.
Examples
This example creates the Generic T-SQL Query collector type.
EXEC sp_syscollector_create_collector_type
@collector_type_uid = '302E93D1-3424-4be7-AA8E-84813ECF2419',
@name = 'Generic T-SQL Query Collector Type',
@parameter_schema =
'<?xml version="1.0" encoding="utf-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" targetNamespace="DataCollectorType">
<xs:element name="TSQLQueryCollector">
<xs:complexType>
<xs:sequence>
<xs:element name="Query" minOccurs="1" maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<xs:element name="Value" type="xs:string" />
<xs:element name="OutputTable" type="xs:string" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="Databases" minOccurs="0" maxOccurs="1">
<xs:complexType>
<xs:sequence>
<xs:element name="Database" minOccurs="0" maxOccurs="unbounded" type="xs:string" />
</xs:sequence>
<xs:attribute name="UseSystemDatabases" type="xs:boolean" use="optional" />
<xs:attribute name="UseUserDatabases" type="xs:boolean" use="optional" />
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>',
@collection_package_id = '292B1476-0F46-4490-A9B7-6DB724DE3C0B',
@upload_package_id = '6EB73801-39CF-489C-B682-497350C939F0';
GO
Related content
प्रतिक्रिया
https://aka.ms/ContentUserFeedback.
जल्द आ रहा है: 2024 के दौरान हम सामग्री के लिए फीडबैक तंत्र के रूप में GitHub मुद्दों को चरणबद्ध तरीके से समाप्त कर देंगे और इसे एक नई फीडबैक प्रणाली से बदल देंगे. अधिक जानकारी के लिए, देखें:के लिए प्रतिक्रिया सबमिट करें और देखें