April 16, 2009 at 10:46 am
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
April 17, 2009 at 10:20 am
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