SSIS中的别名参数 [英] Alias parameters in SSIS
问题描述
我在SSIS中使用的OLE DB命令的SQL命令如下:
I am using an OLE DB command in SSIS for which the SQL command looks like this:
UPDATE DBO.CLIENT
SET
TimeZoneID = ?,
DaylightSavingTime = ?,
ModifiedBy = ?,
MicrosPropertyID = ?,
IsOffline = ?,
GlobalReporting_MaskPatronNumberType = ?,
GlobalReporting_PatronNumberReadableCharacters = ?,
GlobalReporting_MaskPrimaryCardType = ?,
GlobalReporting_PrimaryCardReadableCharacters = ?,
BICAddedDateTime = ?,
BICUpdatedDateTime = ?,
IsDBInDailyBoardRate = ?
WHERE
ClientID = ?
当我尝试进行列映射时,这些参数显示为PARAM_0,PARAM_1,PARAM_2,PARAM_3等等。有没有办法让它们显示为列名?
When I try to do the column mappings, these parameters show up as PARAM_0, PARAM_1, PARAM_2, PARAM_3, etc. Is there a way to get them to show up as the column name?
推荐答案
我发现SSIS会读取列存储过程中的名称,而不是OLE DB命令的SQL命令!
I found that SSIS will read column names from a stored procedure instead of the SQL command for the OLE DB command!
但是,它不会忽略@作为参数名称,因此智能匹配不适用于CustomerId与@CustomerId。
It will however, not ignore the @ for the parameter name and therefore the intelligent matching does not work for CustomerId vs. @CustomerId.
+1,用于使用存储过程的每个人。 :-)
+1 for everybody that uses Stored Procs. :-)
这篇关于SSIS中的别名参数的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!