SSIS Variable Value as SELECT Statement

• Jody Claggett-376930

  Ten Centuries

  Points: 1152

  More actions

  October 17, 2008 at 3:49 pm

  #126979

  I have a STRING variable with the value set as: "select x from tableA"

  I have a OLE DB Provider connection with the Data Access Mode set as SQL Command. That command looks similar to this:

  SELECT * FROM tableB

  WHERE tableB.Name IN (?)

  The parameter is then set to the string variable.

  For some reason, this doesn't seem to be working correctly as I am not pulling in any records.

  Am I writing the SELECT statement variable correctly?

  _______________________________
  [font="Tahoma"]Jody Claggett
  SQL Server Reporting Analyst[/font][/size]

• COZYROC

  One Orange Chip

  Points: 28499

  More actions

  October 24, 2008 at 3:30 pm

  #889521

  Jody,

  Have you checked this thread?

  http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2985964&SiteID=1

  ---
  SSIS Tasks Components Scripts Services | http://www.cozyroc.com/