Does anyone know how to truncate a Mircrosoft Access table from an SSIS package?
Run the SQL:
"delete from YourAccessTable"
|Ken Augustine wrote:|
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.
In control flow, use a Execute SQL task with a delete statement:
delete from table1
Use a OLE DB connection manager for Jet
I have done this exactly and I get this error:
Error: 0xC0202009 at Data Flow Task, OLE DB Command : 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.