使用OLDEB源并设置SQL命令

EXEC yourSPName吗?

如果有的话，将参数映射到任何变量.如果它不在变量中，则将SQL语句写为

@DECLARE @myvar INT

EXEC yourSPName @myvar

目标组件为Excel或CSV，并映射所需的列.

让我知道是否有任何问题.

谢谢，

Kuthuparakkal

Use OLDEB Source and Set SQL Command

EXEC yourSPName ?

Map paramterto any variable if you have. If it''s not in variable, write SQL statement as

@DECLARE @myvar INT

EXEC yourSPName @myvar

Destination component as Excel or CSV, and map required columns.

Let me know if any issues.

Thanks,

Kuthuparakkal