I have a series of packages running on my SQL server. The
first two packages are responsible for bringing over data
from Access databases on remote machines. For a temporary
period of time, I need the packages to pull data from the
Access databases at a different path. However, when I use
the "properties" function of the Access package icon...and
alter the path to the new location, the package no longer
imports data from the Access file. I know the permissions
are set and the path is correct...using UNC filenames,
with no spaces in any directories.
Also, after I change the path I'm asked if I want to reset
the transformations that have reconfigured on that
connection. If I answer "yes" or "no", I still can't
import the data from the new location.
What to do?