SSIS package issue

Question

SSIS package issue

Mh-397891

SSCertifiable

Points: 6704
More actions
December 26, 2008 at 2:52 pm

#204561

I am using SQL Server 2008 in 64-bit environment:
I have created ssis package(DataFromSybaseToSQLserver) using the SSIS import and export wizard, in which the source is sybase db and the destination is sql server db. Now I want to include this package in the main ssis package, I tried with the execute package task in the main ssis package, but I do'nt see the DataFromSybaseToSQLserver ssis package when I use the Execute PAckage Task. Please advice. Thx!

Viewing 5 posts - 1 through 4 (of 4 total)

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

o-3463522 SSC Enthusiast Points: 111 More actions · Answer 1

I too have problem accessing Sybase. I am also using SQL 2008 in 64-bit environment. I have datasource to Sybase and when I process the cube, it gives me "OLE DB error: OLE DB or ODBC error: Class not registered." error.

I am using Native OLEDB\Sybase Adaptive Server Anywhere Provider 9.0 provider

Kenneth.Fisher SSC-Insane Points: 20396 More actions · Answer 2

First things first, are you sure you saved your package from the wizard rather than just executing it? If you did where did you save it to? Did you save it to a SQL Server, file share etc? Did you make sure that when you looked for it in the execute package task that the location/connection are the same?

Sorry thats not much help but you may just have to start over and re-create the package from the wizard making careful note where you saved it.

Kenneth

Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]

Rick.Cornell.SME SSCrazy Eights Points: 8597 More actions · Answer 3

If he created the package locally on his PC,

My Documents\Visual Studio 2005\Projects

If he was working on the server same thing!

If he saved it to SQL Server then it would be in msdb database...

All depends....

COZYROC One Orange Chip Points: 28499 More actions · Answer 4

obulay-657245 (8/12/2010)
I too have problem accessing Sybase. I am also using SQL 2008 in 64-bit environment. I have datasource to Sybase and when I process the cube, it gives me "OLE DB error: OLE DB or ODBC error: Class not registered." error.
I am using Native OLEDB\Sybase Adaptive Server Anywhere Provider 9.0 provider

Have you tried to execute your SSIS package in 32bit mode ?

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/