- Ensure you can connect to Integration Services from SSMS
- SSMS 17.9.1 is the last version that can connect to SSIS properly
- https://docs.microsoft.com/en-us/sql/ssms/release-notes-ssms?view=sql-server-ver15#1791
- This a link with multiple versions of SSMS : https://sqlserverbuilds.blogspot.com/2018/01/sql-server-management-studio-ssms.html
- 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
Monday, November 30, 2020
SSIS - How to deploy a package to SSIS from Visual Studio
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment