Cannot execute package.. help please

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

Cannot execute package.. help please

Author

Topic

swenri
Yak Posting Veteran

72 Posts

Posted - 2009-04-16 : 12:35:58

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

donsen_cai
Starting Member

1 Post

Posted - 2009-05-09 : 02:11:14

quote:
Originally posted by 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. Can anybody throw some light on this ? All help is greatly appreciated.

Thank you

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-05-09 : 04:55:08

why do you need "" around table name? where are you creating table? in oracle db or sql db?

richaux
Starting Member

1 Post

Posted - 2009-09-07 : 14:34:16

Hi,
Not sure how you've checked the SQL... as the "missing left parenthesis" appears to relate to the size of the nvarchar2 fields. Try the following for example:

CREATE TABLE "tblZipCodes_Sales_2009" (
"sZipCode" NVARCHAR2(255),
"SalesRegion" NVARCHAR2(255)
)

I believe this is is a symptom related to the Oracle driver you use in SSIS; if the driver you're using doesn't allocate a datasize, try a different driver or edit the SQL manually.
hth, R

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources