Cannot execute package .. Need help !!

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

SSIS and Import/Export (2005)

Cannot execute package .. Need help !!

Author

Topic

swenri
Yak Posting Veteran

72 Posts

Posted - 2009-04-16 : 17:09:11

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.

rgombina
Constraint Violating Yak Guru

319 Posts

Posted - 2009-04-17 : 07:53:46

Do you have ResultSet set to None?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources