Post reply

Cannot see drive in SQL server agent

  • March 7, 2014 at 6:15 pm

    #284312

    I want to use config files for a package. I stored them on my C drive. However, the C drive I see in the config options tab is totally different from my C. Also, there is a new drive F there which is not even present on my computer. I cannot access any of the drives in config options/tab of agent. So, I am not able to even configure my job for running. How do I fix this ?

    Thanks.

  • March 10, 2014 at 7:55 am

    #1695527

    Your config files should be on a network accessible share with permissions to the account (SQL Agent or proxy account) running the job. Typically I avoid mapped drives in all situations like this because you never know when drive mappings can change so I use UNC path naming conventions. So rather than

    C:\FileShareFolder\configfile.dtsx

    I would use

    \\Servername\FileShareFolder\configfile.dtsx.

  • March 10, 2014 at 1:36 pm

    #1695724

    Yeah just use Network path and grant permissions to the agent or SSIS Proxy Credential.

    --

    SQLBuddy

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

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