Problem exporting data to Access database -- sql server new users

Mads Gildberg
1/16/2006 2:47:21 PM

I have made a DTS package to export data from three tables to an Access
database file. It works fine but I would like the exported data to overwrite
the existing data. Currently it appends the data to the Access database.

How do I specify that the contents of the Access database should be deleted
before the export is run?

Any help will be appreciated.

--
Mads Gildberg (mgildberg AT hotmail DOT com)

Kevin3NF
1/21/2006 1:01:46 PM

You should have the option to delete the rows first. Not sure about Access
connections, but I know it is in the wizard for SQL Server connections. If
your package already exists, add a SQL Task with the proper DELETE syntax

--
Kevin Hill
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.expertsrt.com - not your average tech Q&A site

[quoted text, click to view]

sql server new users : Problem exporting data to Access database