Hi Experts,
I have a Access db which I am moving into SQL db and doing some message with the data and pushing back into Access db.
When I create a DTS package I am facing problem when I try to push SQL data back into Access. As access db doesnt like duplicates because of unique key in my tables, Transformation data task is getting fail , I tried using UPDATE query or INSERT query to just update the Access record based on SQL BUT in DTS Transformation data task dont like UPDATE querys as in my query I am calling tableA from Access db and tableB from SQL so I have to find another solution to move the SQL data into Access without duplicates.
Table A--àAccess db
Table B--àSQL db
My Ideas:
1.I thought of creating a temp table in SQL db eg. tableB_temp , tableA-àtableB_temp ----(UPDATE Syntax to compare )-àtableB --àtableA
Its not working
2.using ActiveX Script ??? I dont know how
Start Free Trial
