Post reply

Cannot see configuration file when creating a SQL Job for SSIS

  • August 5, 2015 at 3:00 pm

    #299389

    SQL 2008 R2

    I have an SSIS package called MyXML

    I need to schedule this job using the sql agent.

    I right clicked and selected New Job

    Gave the job a name and selected Steps

    Clicked New and gave the step a name

    Under Type, I selected SQL Server Integration Packages

    Package Source I selected File System

    In Package I clicked the ellipses and selected the package I want to run.

    On the configurations tab, I selected Add

    In the dialog provided there is nothing to select. No way to browse that I can see.

    So that is the problem, how do I browse to the configuration file?

    Any help is appreciated.

    Thanks

    Gary

  • August 5, 2015 at 6:04 pm

    #1817734

    I figured it out.

    Well, the solution is to add the user as a sysadmin and then they can see the configuration files.

    Now I don't like this solution because the user in question can create sql jobs, can navigate the file system to see the location of the SSIS package, but can't see the configuration file for said package unless they are a sysadmin. Does not make sense to me. But, I don't understand a lot of the stuff Microsoft does.

    I am sure this is by design, but it seems to me to be a bit of a flaw.

    Gary

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

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