在SSIS OLE DB源编辑器中映射输出参数

How can i map output parameter in OLEDB Soruce SSIS(BIDS 2008).In (BIDS 2012) we can specify the query parameter as input and output.

如何在OLEDB Soruce SSIS(BIDS 2008)中映射输出参数。在(BIDS 2012)中,我们可以将查询参数指定为输入和输出。

SET FMTONLY OFF;
EXEC  [dbo].[ProcessPingErrorAlert_KeyValue]
  @AlterId = ?,
  @Hour = ?,
  @Day = ?,
  @TraceId = ?,
  @IsAlert = ? OUTPUT

Please see below two picutres.

请看下面两张图片。

SSIS Package In BIDS 2008

2008年BIDS的SSIS包

SSIS Package in BIDS 2012

2012年BIDS的SSIS包

1 个解决方案

#1

The SQL statement should be: EXEC ? = [dbo].[ProcessPingErrorAlert_KeyValue] ?, ?, ?, ?, ? OUTPUT .

SQL语句应该是:EXEC? = [dbo]。[ProcessPingErrorAlert_KeyValue]?,?,?,?,?输出。

Then edit SQL task and choose, in Parameter Mapping, @IsAlert as Output (check pic just for reference, variables are different). The first question mark is just for the return value (you have to declare that variable amd in Parameter Mapping). Please respect the order you have your question marks and its correspondence by 0, 1, 2, ...

然后编辑SQL任务并在参数映射中选择@IsAlert作为输出(查看图片仅供参考,变量不同)。第一个问号仅用于返回值(您必须在参数映射中声明该变量amd)。请尊重您的问号顺序及其对应的0,1,2,......

For further information you can try to read this: https://sqlserverrider.wordpress.com/2014/08/31/execute-stored-procedure-with-input-and-output-parameters-and-return-status-in-ssis/

有关详细信息,您可以尝试阅读:https://sqlserverrider.wordpress.com/2014/08/31/execute-stored-procedure-with-input-and-output-parameters-and-return-status-in- SSIS /

#1