Phil Parkin (4/25/2014)
elee1969 (4/24/2014)
Hello - I am trying to find out what is the best way to have my ssis package export data to flat file on a mapped network share. This will run hourly with a agent job running under the service account. I know im probably going to run into issues with a network share. Any help suggestions would be greatly appreciated.Thanks !! 🙂
My suggestion would be to use a UNC path rather than a mapped drive.
So i would put the UNC path in the connection manager in the File Name section? When the package runs under the service account will it have issues writing to that location?