• A bit late to the party, but wanted to point out that the future of DTSX files is somewhat cloudy - see Data Transformation Services (DTS) for warnings on it. I would look at alternatives for updating the data. Also, the idea of having a local Access table that mirrors data in SQL Server seems a bit problematic - in general you get as good or better performance using the linked SQL Server table data, or a linked SQL Server view if you only want selected fields and data.

    Wendell
    Colorful Colorado
    You can't see the view if you don't climb the mountain!