Cannot execute package in SSIS

[swenri]

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. Is there any thing that I need to check on the permissions to excute packages in SSIS ? Can anybody throw some light on this ? All help is greatly appreciated.

Thank you

 

[MDXer]

my guess would be the double quotes around the table and column names.

 

[swenri]

I tried even removing the quotes. Nothing seems to work. Any clue ...............to resolve it ?

 

[MDXer]

you have the resultset property set to none right?