SSIS 2008 CTE Datasource OLE DB

• Michael Torsson

  SSC Eights!

  Points: 881

  More actions

  January 21, 2009 at 1:53 am

  #198873

  Hi

  I have a SQL command with variable with cteselect that executes fine in QA and validates fine in SSIS 2005.

  But when I try to use it in SSIS 2008 I get

  "Incorrect syntax near the keyword 'with'"

  Anyone experienced this problem?

  Thanks

  Michael

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  January 21, 2009 at 7:56 am

  #930357

  Can you post the code?

  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

• larry.litvin

  Newbie

  Points: 7

  More actions

  February 8, 2011 at 2:16 pm

  #1284062

  Yes I experience it today, works fine in ssms but not in ssis. Add a ; before the CTE in the ssis execute sql task.