Hi All,

I have to create a package which will take the records of an access table and update the values in an sql server table with the corresponding id.

I have a table in each db called person with the following fields, ID name, country.

So If the ID value from the access table is in the sql server table, i want to update the rest of the fields in the sql server table.

So far I have connection objects to each db and an execute sql task object to get the records from the access table then store them in a global variable.

I'm I going about this the right way.

Any help would be appreciated.

Thanks:(

I have a solution:

01) Create a table in SQL Server which will temporarily hold the records you are importing.

02) Use the DTS import wizard to import the records from access into sql server and save the package.

03) Create a stored procedure to update the primary table from the temp then delete the temp records.

04) Add to the package sql task to execute the stored procedure on success of record import.

I hope someone finds this useful, apart from myself.

:)