Post reply

SSIS 2008R2 : Unable to browse configuration file in a Sql Server job.

  • October 19, 2020 at 8:17 am

    #3798740

    Hi all,

    I made a SSIS package on a développement  server . I deployed it using manifest file in folder :

    C:\Program Files\Microsoft SQL Server\100\DTS\Packages.

    Two files are stored in a the package subfolder --> package file (.dtsx) and the configuration file (.dtsconfig)

    See image attached (SSIS_FILES.JPG)

    So , I wanted to test my package using Sql Server Job(see SSIS_JOB.JPG) but when I tried to browse configuration no file appears(see SSIS_BROWSE_ISSUE.JPG) ??

    For information , I use sa account to buid this test job.

    Any ideas ?

    Thank you in advance.

     

     

     

    Attachments:
    You must be logged in to view attached files.

  • October 19, 2020 at 1:04 pm

    #3798837

    Please do not use C:\Program Files\Microsoft SQL Server\100\DTS\Packages

    If you have to use C drive, create C\:DBA\SSIS folder and give sql server agent permission to it

  • October 20, 2020 at 6:06 am

    #3799109

    Thank you very much.

    It solves this issue.

    For my own understanding , could you explain the reason why it is not recommended to store packages in this folder ?

    Is it related to the securioty rights  ?

    Is this folder reserved to Sql Server processes ?

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

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