Aliasing parameters in SSIS

• raj more-489942

  Mr or Mrs. 500

  Points: 512

  More actions

  July 16, 2009 at 7:54 am

  #208197

  [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]

• Lamprey13

  SSCertifiable

  Points: 6210

  More actions

  July 16, 2009 at 3:24 pm

  #1025922

  Nope, not with the OLE DB tasks.