Problem with executing package in SSIS

  • 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

  • Hi

    You need to specify the datasize of the NVARCHAR2 datatype.

    CREATE TABLE "tblZipCodes_Sales_2009" (

    "sZipCode" NVARCHAR2(100),

    "SalesRegion" NVARCHAR2(100)

    )

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply