Post reply

Troubleshooting steps of Deploymnet

  • November 21, 2013 at 6:47 pm

    #285513

    Hi Everyone,

    Could any one suggest me how to proceed if my deployment gets failed?

    What are the minimum troubleshooting steps?

    Thanks.

    Thanks,
    I’m nobody but still I’m somebody to someone………….

  • November 22, 2013 at 5:24 am

    #1668358

    What are you deploying? What errors are you getting? Please be more specific

    I'm on LinkedIn

  • November 22, 2013 at 7:52 am

    #1668415

    I have created a package in BIDS

    Created a deployment utility

    Build the package in BIDS

    Deployed from Manifest files.

    Fortunately it successes. But i want to know the basic troubleshooting steps.

    Thanks,
    I’m nobody but still I’m somebody to someone………….

  • November 22, 2013 at 8:41 am

    #1668443

    Ah so it's SSIS.

    To be honest with you, problems with deployment don't happen so often - as long as the account doing the deployment has permissions to deploy packages to your server and the server you are deploying to has an SSIS instance and is switched on then you'll be fine.

    Errors in running a package are far more common. Steps to troubleshooting that (depending on how you are executing) could include looking at the SQL Agent history, looking at the ssislog table (if you have set it up) or simply screaming an offensive word at the computer 😀

    I would recommend you set up your own logging of events in any packages that you have. Check out this article for tips on how to go about doing that.

    I'm on LinkedIn

  • November 27, 2013 at 10:15 am

    #1669528

    yeah, it's gonna be a lot easier to assist in troubleshooting when something actually goes wrong.

    Like anything else, ya follow the trail from hopefully a helpful error message.

Viewing 5 posts - 1 through 4 (of 4 total)

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