Post reply

Export file accross the network

  • November 2, 2011 at 9:31 am

    #142946

    I need to create package, that will create file on the different server.

    Package will run from SQL server.

    What kind of rights do I need on server where the csv file is placed?

    Do I need to create any proxy.

  • November 2, 2011 at 9:57 am

    #1402241

    Well, lets break the parts down first.

    To get access to the other server you will need a share and access to that share, you will also need access at the file system level. To get access to outside resources your SQL Server should be running as a user and not as something like LocalSystem.

    So we have 3 things to look at.

    You can use a proxy to access those remote resources or you can use the login account of SQL, I could argue it either way.

    Basically the user probably needs read, write, and modify rights.

    Sounds about right just off the top of my head.

    CEWII

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply