Sunday, March 11, 2012

Export to SQL Server Everywhere Database

Hello!

I want to export a table in a SQL Server 2005 database to an SQL Server 2005 Everywhere database (sdf file). I use the assistent by calling "Management/Export data". The source is "SQL Native Client" showing to a certain database. The destination is "SQL Server 2005 Everywhere Edition" with an SDF File set. Then after defining the tables to be exported I come to a page showing me the steps of the export. At step "Before execution" I get the error messages (translated from German):

Error 0xc0202009: Data flow task: OLE DB error. Error code 0x80040E37

Error 0xc02020e8: Data flow task: Error opening a rowset for "TABLE_NAME". Validate the existance of the object in the database.

Does someone know what the problem is? The source is completely ok. The source table is existing and contains over 3.000 datasets.

Robert

i have the same problem|||

Import/Export from/to SQL Server Everywhere Edition (SSEv) is not implemented.

The immediate question would be why is it shown their in the list of data providers?

All the data related tools (ex: SQL Server Management Studio, Microsoft Office Word, Microsoft Office Excel ..etc) show a list of data providers from a OLEDB Provider database of the system. Since, SSEv also registers its OLEDB Provider to system, it gets listed automatically.

Thanks,

Laxmi

No comments:

Post a Comment