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!