SSIS Importing flat files from Directory yields Access Denied Error
Posted on 2009-02-11
I am using SSIS 2008 for the first time and am trying to use a foreach file loop to simply load the data from a delimited flat file 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. See below.
I have given everyone full rights to the directory I am trying to read from.
Any ideas? Please help.
Information: 0x402090DC at Extract transaction Responses, Response transactions : The processing of file "\\myserver\public\RecycleBin\SampleData" has started.
Warning: 0x80070005 at Extract transaction Responses, Response transactions : Access is denied.