I have a DTS package that I "scheduled", there by creating a JOB to execute the
DTS. The DTS package takes a Excel CSV file and
sticks the data into a database table. The CSV is on my web server which is
separate from the database server. I set the DTS package
up using UNC path to the CSV file {\\myWebServer\driveShare\files\xyz.csv}. I
made sure the JOB owner is the domain administrator,
which is the same on both the WEB and DB server...
I can execute the DTS successfully but when I try to execute the JOB it tells
me that Access is denied to the flat file...
Why is that? Did I miss something?
HELP!
Brad
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2066
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/6
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
