[font="Tahoma"]I am using an OLE DB command in SSIS for which the SQL command looks like this:
[/font]
[font="Courier New"]UPDATE DBO.CLIENT
SET
TimeZoneID = ?,
DaylightSavingTime = ?,
ModifiedBy = ?,
MicrosPropertyID = ?,
IsOffline = ?,
GlobalReporting_MaskPatronNumberType = ?,
GlobalReporting_PatronNumberReadableCharacters = ?,
GlobalReporting_MaskPrimaryCardType = ?,
GlobalReporting_PrimaryCardReadableCharacters = ?,
BICAddedDateTime = ?,
BICUpdatedDateTime = ?,
IsDBInDailyBoardRate = ?
WHERE
ClientID = ?
[/font]
[font="Tahoma"]
When I try to do the column mappings, these parameters show up as PARAM_0, PARAM_1, PARAM_2, PARAM_3, etc.
Well, the SQL statement that I have shown here is truncated. My actual warehouse tables are flattened and contain a large number of columns. One mistake can lead to a LOT of pain.
Is there a way to get the parameters to show up as the column name (@TimeZoneId) instead of PARAM_0?
[/font]