none
How to verify a package deployed successfully

    Question

  • Hello,

    I am new to SSIS.  Once through the deployment process, how do you verify the package deployed successfully?  Is there somewhere to look for verification other than the process completing?

    Please advise,

    Dianne


    Dianne

    Wednesday, July 02, 2014 4:50 PM

Answers

  • Hi Dianne,

    You can check the deploy result from the Package Installation Wizard or Integration Services Deployment Wizard to check whether the deployment is successful. The deployment result won’t be saved to a log file. You can also check the SSIS package store or SSISDB catalog from SQL Server Management Studio (SSMS) to see whether the packages/project are there. The packages/project won’t be deployed as long as there is any failure during the deployment. In other word, it indicates the packages have been deployed successfully as long as we can see them from SSMS.

    Regards,


    Mike Yin
    TechNet Community Support

    • Marked as answer by deescott Wednesday, July 09, 2014 12:52 PM
    Wednesday, July 09, 2014 3:38 AM
    Moderator

All replies

  • You should see output when deploying from SDT or BI Studio. It indicates failure or success.

    P Brent

    Wednesday, July 02, 2014 5:03 PM
  • And does this output write to a file or is it visual?

    Dianne

    Wednesday, July 02, 2014 5:51 PM
  • Depending on where you deployed the package, you can find package under MSDB -> Your folder or Integration Services Catalog -> Your Project.

    You can then right click and select execute package and make sure it executes correctly with runtime values (ie from configurations/environment variables)


    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    Wednesday, July 02, 2014 6:04 PM
  • Thank you, but that's what I need to avoid.  I don't want to have to execute a package in production to verify it deployed correctly.  It seems to me there has to be a better answer.

    Dianne

    Wednesday, July 02, 2014 6:07 PM
  • Hi Dianne,

    You can check the deploy result from the Package Installation Wizard or Integration Services Deployment Wizard to check whether the deployment is successful. The deployment result won’t be saved to a log file. You can also check the SSIS package store or SSISDB catalog from SQL Server Management Studio (SSMS) to see whether the packages/project are there. The packages/project won’t be deployed as long as there is any failure during the deployment. In other word, it indicates the packages have been deployed successfully as long as we can see them from SSMS.

    Regards,


    Mike Yin
    TechNet Community Support

    • Marked as answer by deescott Wednesday, July 09, 2014 12:52 PM
    Wednesday, July 09, 2014 3:38 AM
    Moderator
  • Thank you, but that's what I need to avoid.  I don't want to have to execute a package in production to verify it deployed correctly.  It seems to me there has to be a better answer.

    Dianne

    Nope for checking if deployment is succesfull you just need to see package listed in MSDB or Integration Services Catalog. The second suggestion was to see if package functionality works fine. You dont need to do it if your emphasis is just to see if deployment was successful.

    In 2012 Integration Catalog you also can validate package without actually executing it.


    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs


    • Edited by Visakh16MVP Wednesday, July 09, 2014 4:35 AM
    Wednesday, July 09, 2014 4:34 AM