Input param not being substituted

• Soorya

  Ten Centuries

  Points: 1314

  More actions

  September 2, 2008 at 4:12 am

  #192138

  Hi,

  I am using a OLE DB source component in the data flow of a SSIS. The data access mode is "SQL command" and below placed is the query.

  SELECT Col1, Col2 FROM Table1 WHERE Col3 = ?

  Though i mapped one of the variables as a parameter to the command, i don't see the data flowing out of the task. I think, the variale's value is not substituted in the sql command.

  Please helpd me with this.

  Thanks in advance

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  September 5, 2008 at 8:27 pm

  #868101

  How'd you map the variable to the parameter? Please post exactly.

  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