February 9, 2009 at 5:28 pm
I am using SSIS 2008 and am trying to use a foreach file loop to simply load the data into a sql server 2008 table. I am using a config file to specify the directory to look in (I followed the directions in the online ebook) and each time I run the package I am getting an Access Denied error after the output line states "....The processing of file \\.... has started.
I have given everyone full rights to the directory I am trying to read from.
Any ideas? Please help.
February 10, 2009 at 10:10 am
The ssis package maybe running as a userid that doesn't have permissions on the file. Use the security audit log of the server/pc holding the file. It will show what user id is being denied access to the file.
February 10, 2009 at 2:00 pm
How can I view the security log? This is on a file server.
I did run FileMon while running the package and was very surprised to see the amount of logs generated by DTS. However FileMon did not show any errors.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply