How to use an SSIS user variable in a SQL statement

• Jim Covington

  Old Hand

  Points: 348

  More actions

  March 30, 2009 at 3:38 pm

  #207768

  I am using SQL 2005 and am in SSIS.

  I have a SQL Dataflow task that has a SQL statement as follows:

  Select TRACCT,TRATYP,TRDATE,TRDAT6,AMT,SERIAL, TRANCD,DORC ,ATMCOD

  From DATMCC.DDHist

  Where TRDATE > @

  ORDER BY TRACCT, TRATYP,TRDATE DESC,amt desc

  I also have a package scoped variable user::JulianDate with a date in it.

  I want to use the value in User::Juliandate1 where the @ sign is in the SQl above.

  How is this done?

  Thanks

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  March 31, 2009 at 7:13 am

  #969062

  If you are using the OLEDB Provider you need to replace the "@" with "?".

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question