SSIS-执行SQL任务已运行但查询未运行 [英] SSIS- Execute SQL task ran but the query didn't run

问题描述

我在SSIS包中创建了一个执行SQL任务。当我运行SSIS包时，任务成功运行，但我给出的查询没有执行。如果我复制相同的查询并从SSMS运行，则查询正在成功执行。

我正在使用表达式在任务中传递查询。

Do你知道如何修复它。

谢谢，

Manisha Arora

解决方案

嗨Manisha，

您似乎需要检查执行SQL任务的表达式。

您可以在Pre-Execute步骤中停止SSIS执行并检查表达式值以查看它的评估方式。

Hi,

I have created an Execute SQL Task in my SSIS Package. When I am running SSIS package the task ran successfully but the query I have given is not executing. If I copy the same query and run from SSMS, query is executing successfully.

I am passing the query in the task using Expressions.

Do you have any idea how it will be fixed.

Thanks,

Manisha Arora

解决方案

Hi Manisha,

It seems that you need to check the expression for the Execute SQL Task.

You can stop the SSIS execution on the Pre-Execute step and examine the expression value to see how it was evaluated.

这篇关于SSIS-执行SQL任务已运行但查询未运行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！