我在SSIS中使用OLE DB命令,其sql命令如下所示:
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等.有没有办法让它们显示为列名?