Voila! Thanks so much! I totally spaced that part :)
Brad -----Original Message----- From: Levenson, Keith [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 09, 2004 11:33 AM To: SQL Subject: RE: DTS Package Ownership It's been my experience that you need to be logged in with the same administrator account that runs the MSSQLServer & SQLAGENT services when you create your DTS package, or the scheduled job won't handshake correctly. -----Original Message----- From: Bradford T Comer [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 09, 2004 9:55 AM To: SQL Subject: DTS Package Ownership 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:2068 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
