How to import Pervasive Database into SQL Server 2005

Hi

I have tried to import Pervasive Database to SQL Server 2005.

I am not getting any option in Data Source for Pervasive So I tried following

I have Provided the following Connection String to SQL server Import and Export Wizard (in .net framework data provider for ODBC)

Connectio String: Dsn=DEMODATA;Driver={Pervasive ODBC Engine Interface}

DSN: DEMODATA

Driver:Pervasive ODBC Engine Interface

but i m getting error that "Can not get supported data types from th database connection."

Can you please look in to it and tell me possible ways by which I can import pervasive Database into SQL server 2005.

and let me know if there is any other tool by which we can see "Pervasive ODBC Engine Interface"

in Data Source

Thanks,

Arun

Unless there is another Pervasive user out there who can help you, I would suggest the following: try building the package in the designer rather than through the wizard. The designer in Business Intelligence Development Studio offers more options than the wizard, which only covers simple scenarios.

Having said that - if the provider does not return data type information, it may yet be a problem.

Donald

|||Did you ever get this resolved?|||

I am Currently working in a ETL project that extracts data from Pervasive V8 DB. I wanted to use OLE DB connection but I could not make it work; so I am using ODBC. I installed the ODBC driver in my the development stations and the SSIS server (as a part of the Client tool Pervasive.SQL Data Manager installation); then I defined the Dsn. Whitin SSIS I defined my datasaource as:

Provider: .Net Providers\Odbc Data Provider

Use user or System data SOurce Name: <Choose from dropdown list my dsn>

The conction string of the data source is just simple: Dsn=<MyDsn>

And I was ready to go...

Then I had problems in the server because it is x64 bit machine; but that is a different story.

Rafael Salas

|||

I'm on Pervasive 2000i... my issue is that I'm trying to use the demodata dsn and I get the following error:

Cannot get the supported data types from the database connection "Dsn=demodata;Driver={Pervasive ODBC Engine Interface}".

Additional information:

--> Specified cast is not valid. (System.Data)

|||

German,

Did you try what Donald Suggested you? All what I did was inside of BIDS and actually I never tried with the wizard since I needed to perform some transformations before writing into the destination table

Rafael Salas