Use Insert Update Delete in DTS

[sudhirkrishnan]

I have an Access table from which I have to get data periodically in 30
minutes everyday to an SQL server table. both have the same data structure. I
want to get all the new records as insert, modified records as update and
deleted records in source table that still exists in target table to be
deleted. I have tried searching on the net. They all explain about using the
insert, update and delete statements in DDQ. I understand that but how do i
change the related constant in the ActiveX script for eg: Main =
DTSTransformstat_UpdateQuery for update. I saw somewhere an eg. where i use a
select case according to some column in the table that has to be changed to
insert or update but i dont want to add a new column for this. some solution
that will compare the source table and target table with sql queries using
exists. but i cant identify target and source in a query if i use the
"Execute SQL task". Can someone help.

[rmiao]

Why don't let app use sql db directly?

[bobkand]

Hi Sudhir..
r u getting all your records direclty from Access into your database.???
or access to Temporary table in your DB and from there to ur DB tables??
if u r using a Temp. table u can write a proc where u can check the records if new Insert, existing Update....
I don't think so that u can compare a table with another table without a relation Column...