I am exporting data from a SQL server to a Access DB with some custom Queries.

In the process I get a error between a Data conversion and OLE DB
Destination module

[OLE DB Destination [28]] Error: An OLE DB error has occurred. Error code:
0x80004005. An OLE DB record is available. Source: "Microsoft JET Database
Engine" Hresult: 0x80004005 Description: "Operation must use an updateable
query.".

Is this a permissions error or should i use custom query in my OLE DB
Destination to insert data into the access file ?

Hello Ram,

Let me see if I have this right.

You use a SELECT statement to get data from SQL Server
You then use a Data Conversion Transform
You then insert the data.

Is this a simple insert direct to the table in Access or have you specified
a query as the destination?


Have a look at this excellent article to see if it helps you

http://www.aspfaq.com/show.asp?id=2062



Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

I am doing exactly what you mentioned. Yes its a direct insert into the
Access File. No queries.
Thanks for the link i will look at it.
-Ram

"Allan Mitchell" wrote: