Monday, November 30, 2020

SSIS - How to deploy a package to SSIS from Visual Studio

  • Ensure you can connect to Integration Services from SSMS
  • Create SSIS Catalog
    • From your SQL Server>Integration Services Catalog
      • Right Click>Create Catalog
      • Right click>New folder
  • Publish Project in catalog
    • Inside Catalog>right click on Projects folder>Deploy Project
    • Select files from \Users\AdmBob\source\repos\projectname
    • enter password>Apply
    • Refresh
    • Publish>Overwrite? click yes
  • Schedule Package
    • From Job, Right click, new job, new step
      • Type: SQL Server integration package
      • Package Source:SSIS Catalog
      • Package: Local path for project (copy from \Users\AdmBob\source\repos\projectname)
    • Define job schedule

No comments:

Post a Comment