Post reply

How to access other computer's folder in SSIS Packages?

  • July 19, 2012 at 1:03 am

    #392777

    Hi All,

    Actually i have db server and application server.

    i have imported SSIS package in DB and that package is creating the file in application server.

    How my SSIS package will access that folder and create the file in it (i have script with me which we working fine)?

    Do i have to provide access on that folder (but it should not be shared folder)?

    Please correct me if i am wrong.

    Thanks

  • July 19, 2012 at 2:14 am

    #1514664

    Use UNC paths with admin shares as default (eg \\SERVER\D$\Folder) but this will require administrator access to the SQL Agent account

    Or share the folder as \\SERVER\Folder but lock it down so that only the SQL Agent account can access the share.

  • July 19, 2012 at 4:28 am

    #1514729

    Thanks for quick update...

    I am facing problem as follow:

    There are two servers: DBServer and AppServer

    User1: User1 has access on AppServer shared folder only. And I have imported Package1 in SQL 2005, using USER1.

    Package1: which is creating the file on AppServer shared folder on which I have given access to User1.

    But when I executed the package1, it is not creating the file on AppServer shared folder (User1 has only person who has access on that shared folder)

    Is anything am missing it?

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

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