Export data SSIS to Access

[micang]

Hi All,

I am using export wizard SSIS, querying a SQL 2000 database, into ACCESS 2003.

I get the following error:

- Validating (Error)
Messages
Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Data Conversion 1" (181).
(SQL Server Import and Export Wizard)

But if I export from EM in SQL 2000 it works fine.

Can anyone shed some light why this is happening?

Many thanks in advance.

Michael

 

[mrdenny]

You can't do exports using SSIS to a jet data source (Access, Excel, etc) without having the SSIS service installed on your workstation.

This is by design.

You should install the SSIS service on your machine in order to do this.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[micang]

Ahh, so that is the trick!

Thanks Denny

Michael

 

[mrdenny]

No problem.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com