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.
| Author |
Topic |
|
parrot
Posting Yak Master
132 Posts |
 Posted - 2009-03-19 : 21:35:56
|
| I am trying to export data from my SQL 2005 database to an Access database 2003 format. When I go thru the wizard it gives the following validation error messages and then stops the export.Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Data Conversion 2" (317). (SQL Server Import and Export Wizard)I am running on a Vista 64 bit machine. I did not have this problem on a Vista 32 bit machine doing the same export. Anyone know what the above error means and how to resolve it? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-03-19 : 23:01:42
|
From what Google tells me  it should be fixed by installing the latest SQL Server service pack. Try it on the client machine running the SSIS package first, and if that doesn't fix it then apply the service pack to the SQL Server as well (if they're different machines) |
 |
|
|
parrot
Posting Yak Master
132 Posts |
Posted - 2009-03-21 : 16:20:57
|
| Thanks for your reply. I will try to get the latest service pack and update it and see what happens. |
|
|
|
|
|
|
Export error from SQL to Access