I'm getting an error saying [Bulk Insert Task] Error: An error occurred with the following error message: "Cannot bulk load because the file "\\a3021284\share\Imports\SOR91881\InterchangeCntlNbr" could not be opened. Operating system error code 5(Access is denied.).
\\a3021284\share\Imports\SOR91881 is a shared folder and InterchangeCntlNbr is flat file.
My environment is like this i have a package that creates five flat files in a shared folder with in sql server itself and i bulk insert all the flat files to five different tables. This is working fine because the shared folder is in the server \\ncpctst\imports\SOR91881 (ncpctst - is the sql server name). I created a folder named "imports" inside the sql server's D drive and shared this folder and gave full permission to my domain account and i added my domain account is sql server role as bulk admin, sysadmin, serveradmin . The flat files wil be created in this folder and bulk insert from this folder. This is working fine. But i trying to bulk insert a flat file from a remote system's share folder using VS 2005. This is not working and i get the Operating system error code 5(Access is denied.) error.