Truncate Microsoft Access Table from SSIS

Does anyone know how to truncate a Mircrosoft Access table from an SSIS package?
March 27th, 2008 4:08pm

Run the SQL:

"delete from YourAccessTable"

Free Windows Admin Tool Kit Click here and download it now
March 27th, 2008 4:23pm
Ken Augustine wrote:

Does anyone know how to truncate a Mircrosoft Access table from an SSIS package?

How do you do it from inside Access?

You should be able to use the same syntax and put it into an Execute SQL task inside your package.

March 27th, 2008 4:23pm

In control flow, use a Execute SQL task with a delete statement:

delete from table1

Use a OLE DB connection manager for Jet

Free Windows Admin Tool Kit Click here and download it now
March 27th, 2008 4:29pm

I have done this exactly and I get this error:

Error: 0xC0202009 at Data Flow Task, OLE DB Command [31]: An OLE DB error has occurred. Error code: 0x80004005.

An OLE DB record is available. Source: "Microsoft Office Access Database Engine" Hresult: 0x80004005 Description: "Could not delete from specified tables.".

Error: 0xC0047022 at Data Flow Task, DTS.Pipeline: The ProcessInput method on component "OLE DB Command" (31) failed with error code 0xC0202009. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running.

I know that this is a security issue, but I gave "Everyone" full control of this folder and the database is not encrypted or locked.
July 10th, 2008 1:58pm
This does not seem to be working for me? Am I missing anything?
Free Windows Admin Tool Kit Click here and download it now
September 4th, 2015 5:55pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics