经典数据流模板失败

若出现经典数据流模板失败的问题，可以尝试以下步骤：

1.检查输入和输出参数是否正确设置。

2.检查数据流任务的连接是否正确。

3.检查源数据是否正确。

以下是一个包含代码示例的

DECLARE @sourceQuery VARCHAR(MAX)     
SET @sourceQuery = 'SELECT * FROM dbo.Orders'

DECLARE @destinationTable VARCHAR(128) = 'dbo.OrderHistory'

-- 创建数据流任务并添加源和目标
DECLARE @execution_id BIGINT
EXEC [SSISDB].[catalog].[create_execution]
@package_name=N'Package.dtsx',
@execution_id=@execution_id OUTPUT,
@folder_name=N'DataFlowProject',
@project_name=N'Integration Services Project',
@use32bitruntime=False,
@reference_id=Null

-- 设置源数据
EXEC [SSISDB].[catalog].[set_object_parameter_value]
@object_type=20,
@parameter_name=N'SourceQuery',
@object_name=N'Package.dtsx',
@folder_name=N'DataFlowProject',
@project_name=N'Integration Services Project',
@value=@sourceQuery

-- 设置目标表
EXEC [SSISDB].[catalog].[set_object_parameter_value]
@object_type=30,
@parameter_name=N'TableName',
@object_name=N'Package.dtsx',
@folder_name=N'DataFlowProject',
@project_name=N'Integration Services Project',
@value=@destinationTable

-- 启动数据流任务
DECLARE @var0 smallint = 1
EXEC [SSISDB].[catalog].[set_execution_parameter_value]
@execution_id,
@object_type=50,
@parameter_name=N'LOGGING_LEVEL',
@parameter_value=@var0

-- 执行包
EXEC [SSISDB].[catalog].[start_execution] @execution_id