SSIS Package cant read form the file server share.

  • Hello All,

    i have come across a very weird senario and I am hoping some one much more well versed in SSIS can guide me to a right path.

    I have a very simple task that creates CVS file on a file server location, lets say

    \\servername\sharename\file.cvs

    package failed throwing the error that cant connect to the file share.

    when i change the location on to the local drive the package works fine.

    obviously i thought i need the server account of the server to have access to the folder, which i asked and was granted.

    now when i go the server connected as a service account and go to the run command and type the path it takes me to the path.... this shows that the service account has access to the file share.

    when i open the package and go to the flat file connection and click browse to the location i get a error "windows cannot access \\servername\sharename\.

    after this if i go back again to the run command and enter the path , now i cant even connect form there, even though before opening the package i was able to connect to the folder form the run command.

    i have no idea why i am getting this weird error. can any one help please?

    thanks in advance

  • Check the share permissions. There are file/folder permissions and then there are share permissions. With you accessing via a UNC path with what looks to be a share, you are likely being obstructed by share permissions.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Thanks for the response,

    -how would I like check the share permissions?

    also , i am able to open the server, can go to run command, and type the share path successfully; only once i load the package and open it on the VS than i cant connect to the path successfully.

    why its happening this way.. would appreciate any help.

    Thanks

  • Are you running VS under the same account.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Hi,

    I think your server is not a remote server

    You can take the file path as variable and change the connection string in expression of file connection properties changed to variable

    Hopefully it's works

    Thaks,

Viewing 5 posts - 1 through 4 (of 4 total)

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