Post reply

Package running from BIDS but not from Utility

  • March 27, 2015 at 5:37 am

    #150874

    Hello,

    I have a package that uses Script task to refresh excel files in a shared folder.

    The credential I am using to run the package has read write access to the shared folder.

    When I execute the package from BIDS it is running fine. But it is not running from package utility or from SQL job.

    It is neither failing to execute. After starting it just continues to remain in the same step.

    Thanks

  • March 27, 2015 at 5:54 am

    #1786819

    Knowledge Hunter (3/27/2015)

    Hello,

    I have a package that uses Script task to refresh excel files in a shared folder.

    The credential I am using to run the package has read write access to the shared folder.

    When I execute the package from BIDS it is running fine. But it is not running from package utility or from SQL job.

    It is neither failing to execute. After starting it just continues to remain in the same step.

    Thanks

    Are you using a UNC path to the shared folder? If not, please try that.

    Also, if you change the path to a folder which is local on the server, does the job run? If yes, that means that this is almost certainly a user-rights issue.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

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

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