发送是什么意思？在SSIS任务中的SQL查询中 [英] What is the meaning of sending ? in sql query in SSIS task

问题描述

大家好，



我是SSIS的新手，现在需要从2005年到2008年进行一些迁移。



执行此操作时，我打开了一个SQL任务，它将一些包信息记录到DB中。当我打开查询时，我发现了？在SQL查询中。请检查以下行：

Hi All,

I am new to SSIS and now need perform some migration from 2005 to 2008.

While performing this I have opened one of the SQL task which was logging some package info into DB. When I opened the query I found that ? in the SQL query. Please check in the below line:

EXEC  dbo.usp_LogPackageStart @ID = ?,@Name =? ,@Description = ? ,@Frequency =?,@ProcessedKey = ?,@ProcessdDate = ? 

结果集被选为单行。任何人都可以告诉我在执行SQL时会在？处替换哪些值，在这种情况下单行的含义是什么。



在此先感谢

Prashant

result set is choosen as "Single Row" . Can any one tell me what values will be replaced in "? " place while executing SQL and What is the meaning of Single row in such situation.

Thanks in Advance
Prashant

推荐答案

？是您在参数选项卡中定义的参数。

"?" is a parameter you are defining in Parameters tab.

这篇关于发送是什么意思？在SSIS任务中的SQL查询中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！