SSIS Package Execution Issue

  • Hello everyone,

    I have an IS package that runs perfectly inside of the BI Development Studio (SS2008R2 w\BIDevStudio2008) but when I set up an Agent job to run the package at an interval it fails. The package uses 3 connection managers to SQL instances that are within the Domain. Again, the package runs perfectly in the Dev Studio.

    Any ideas would be greatly appreciated.

    Thanks.

  • What's the error in the job history?


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • Does the SQL Server Agent user account have all the necessary permissions to connect to the instances and perform the tasks you implemented in the SSIS package?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

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

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