Problem with executing package in SSIS

• swenri

  SSC-Addicted

  Points: 469

  More actions

  April 16, 2009 at 10:46 am

  #202084

  I've created a package in SSIS 2005 using SSIS Import Export Wizard. The source is Sql Server 2005, destination is Microsoft Provider for Oracle(MSDAORA.1). The package is created successfully but,when ever I execute I keep getting the error mentioned below. SSIS package "Package7.dtsx" starting.

  Error: 0xC002F210 at Preparation SQL Task, Execute SQL Task: Executing the query "CREATE TABLE "tblZipCodes_Sales_2009" (

  "sZipCode" NVARCHAR2,

  "SalesRegion" NVARCHAR2

  )

  " failed with the following error: "ORA-00906: missing left parenthesis

  ". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

  Task failed: Preparation SQL Task

  SSIS package "Package7.dtsx" finished: Failure.

  I had checked the sql query, there is nothing wrong in it.

  CREATE TABLE "tblZipCodes_Sales_2009" (

  "sZipCode" NVARCHAR2,

  "SalesRegion" NVARCHAR2

  )

  It is beyond my reach and puzzled why I cannot execute the package suuccessfully. Can anybody throw some light on this ? All help is greatly appreciated.

  Thank you

• Vijaya Kadiyala

  SSCrazy Eights

  Points: 9149

  More actions

  April 17, 2009 at 10:20 am

  #979797

  Hi

  You need to specify the datasize of the NVARCHAR2 datatype.

  CREATE TABLE "tblZipCodes_Sales_2009" (

  "sZipCode" NVARCHAR2(100),

  "SalesRegion" NVARCHAR2(100)

  )

  Thanks -- Vijaya Kadiyala
  www.dotnetvj.com
  SQL Server Articles For Beginers