Lookup transformation custom SQL error

• evaleah

  Ten Centuries

  Points: 1372

  More actions

  August 9, 2007 at 11:35 am

  #153733

  I have a Lookup Transformation where I use a custom SQL string to retrieve the values I want.  The SQL string I have written is:

  select * from [dbo].[tb_PRMCReview]

  where left([tb_PRMCReview].[PRMCReview],4) = left(?,4)

  When I go to set the parameters I get "Incorrect syntax near ')'".  I have run this same string through EM and it works nicely.  Can anyone help me figure out what I am doing wrong here?

  Thanks,Eva

• evaleah

  Ten Centuries

  Points: 1372

  More actions

  August 9, 2007 at 12:12 pm

  #725828

  I realized I could just change the column I am selecting in my source and not bother with this lookup this way. So, never mind.