oulegulas


I have scheduled an export of some DBs to mdb- files.

the problem is: everytime the DTS- packet is executing, the records are appended. eg the packet runs 4 times there are 4 records with the id 1, 4 records with id2 and so on.

But I only want a fresh copy of the database, not an incremental update.

please help



Re: Exporting mdb-files via DTS

Madhu K Nair


if i understood the problem correctly.... what u are currently doing is just insert into statement to the table... before doing this u need to delete existing data from the table... sothat only u have the latest copy..

Madhu







Re: Exporting mdb-files via DTS

oulegulas

I used the Import/Export wizard for the databases and saved and scheduled the packets.
I tried to alter the SQL- Statements, but I don't know how to set up a condition like in MySQL
DROP TABLE IF EXISTS

An example for the generated statements:

CREATE TABLE `qry_filter` (
`Zugangs-Nr` VarChar (255) NULL,
`Akten-Art` VarChar (255) NULL
)

how do I change it

btw: I'm running MSSQL 2003 Standard Ed.





Re: Exporting mdb-files via DTS

Madhu K Nair

in Export/Import WIzards ... Select Source Table and View WIndow..... click on Edit Mapping button.... there is an option to delete the existing table

Madhu






Re: Exporting mdb-files via DTS

oulegulas

actually I can't find such a button... I searched all over the wizard.

in Select Source I got only 2 Buttons: Refresh and Advanced(should be in english for I have no english GUI)
in Select Target I can choose a Filename for the mdb- file(target is Microsoft Access) and have an Advanced- button.
next screen I have 3 radio- buttons:
1 - Copy tables from db
2 - Use query for data transmission
[3 - greyed out]
no more options. I used button 1
next step I can choose the tables to export - no more options
next step run and save DTS- packet
and on next step I finish the wizard.

so I don't see any button like the one you mentioned




Re: Exporting mdb-files via DTS

Madhu K Nair

I can choose a Filename for the mdb- file(target is Microsoft Access) -- catch is this

you may not have this option in Access export... I don't have access installed on my machine i will check it and let u know

Madhu