I have a table in Access and a table in SQL. I need to insert records from access into sql that are not already in that table and also sync sql to access so that at all times those two tables are matching. the Job will be run once an hour. Any ideas? I can use SSIS but it is the merging i'm lost on.
Question: Are you using a SQL backend for your access database or access tables? If using access tables I would firstly ask why when you have SQL? If you are using SQL for both then: I would try using ssis and using the 'execute sql command' object, then get it to run a stroed procedure in your sql database.