Database Reference
In-Depth Information
Note Much of the functionality associated with administering Integration Services
packages can be accessed through a command-line interface. By using the command
line, you can integrate your Integration Services administration with your other main-
tenance tasks.
Run the following code in Listing 15-2 to change the logging level to log all Verb-
ose records for a new execution.
Listing 15-2 . Statement to Modify the Logging Level for an Execution
DECLARE @execution_id INT
EXECUTE [catalog].[create_execution]
@folder_name = 'DesignPatterns'
,@project_name = 'DesignPatterns'
,@package_name = 'Ch15_Reporting.dtsx'
,@reference_id = null
,@use32bitruntime = false
,@execution_id = @execution_id OUTPUT
EXECUTE [catalog].[set_execution_parameter_value]
@execution_id
,@object_type = 50
,@parameter_name = 'LOGGING_LEVEL'
,@parameter_value = 3 --Verbose
EXECUTE [catalog].[start_execution]
@execution_id
Once you've done this, you can see the output from the newly set logging level by
running the query in Listing 15-3 .
Listing 15-3 . Query to Return All Messages
select * from catalog.event_messages
where operation_id =
(select max(execution_id) from catalog.executions)
 
 
 
 
Search WWH ::




Custom Search