Error when creating a tbale/sheet to Excel with SSIS 2008

• WilburSmith

  Hall of Fame

  Points: 3225

  More actions

  November 7, 2014 at 6:36 am

  #291791

  Hi,

  I'm trying to study the mechanism described in here:

  http://sqljourney.wordpress.com/2013/01/12/ssis-create-new-excel-file-dynamically-to-export-data/

  When I run the Sql Task with the table/sheet creation command:

  CREATE TABLE 'Data' ('YearMonth' Long, 'ProductCode LongText, 'ProductStandardCost' Long, 'TotalProductCost' Long, 'SalesAmount' Long)

  I get the error:

  Error: 0xC002F210 at CreateNewExcel, Execute SQL Task: Executing the query "CREATE TABLE 'Data' ('YearMonth' Long, 'ProductCod..." failed with the following error: "Syntax error in CREATE TABLE statement.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

  What might be wrong here? I believe I've done everything like in the URL example. Excel 97-2003

  Regards, Ville

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  November 7, 2014 at 6:49 am

  #1757195

  Be aware that those are special quotes in the CREATE TABLE statement.

  ` is not the same as '

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP

• WilburSmith

  Hall of Fame

  Points: 3225

  More actions

  November 7, 2014 at 6:58 am

  #1757198

  Thank you!