Home Forums Data Warehousing Integration Services Mapped Network Share RE: Mapped Network Share

  • April 28, 2014 at 11:02 am

    #1709236

    elee1969 (4/28/2014)

    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?

    Yes and maybe. Whether you use a mapped drive or a UNC path does not affect the permissions which the service account needs to modify files there.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.