Copy SSIS Environment variables to another server
Migrate SSIS environment variables from one SQL Server to another in just a few clicks using SSIS Catalog Migration Wizard.
2023-05-19 (first published: 2022-10-12)
2,883 reads
Kunal Rathi
- Interests: Data Warehousing, Data science, Machine Learning, Big Data
- Website: https://azureops.org
- LinkedIn: https://www.linkedin.com/in/kr55/
Migrate the SSIS Catalog in Just a Few Clicks
This wizard migrates SSIS Catalog from one server to another in just a few clicks.
2022-10-27 (first published: 2021-08-17)
13,099 reads
SSIS Environment Design Patterns
In this article, we will see 3 SSIS design patterns that we can use to set up SSIS configurations and deployments.
2022-05-05 (first published: 2022-04-08)
3,427 reads
Is Your SSIS Catalog Migration Ready
In this article, we will see if the given SSIS catalog is ready for migration without any issues using SSIS Catalog Migration Wizard inspect feature.
2022-01-28
2,070 reads
Automate MSBI deployments Using PowerShell
There are various ways we can deploy MSBI project deliverable. This article will give you an idea to automate MSBI deployments using Windows PowerShell.
2020-11-05 (first published: 2020-10-10)
2,578 reads
Blogs
Setting Up Always Encrypted
In this post we're going to go through the steps to set up Always...
Using Azure Automation and Runbooks to Run Azure SQL Database Maintenance Tasks
I’ve been using Azure SQL Database for quite some while and have set up...
Create and Verify Microsoft Fabric Capacity
From June 1, 2023, Microsoft Fabric (preview) capacities are available via the Azure portal....
Forums
how to determine if we can delete the index can be removed
In SQL Server database, there is a table InventDim with two indexes: Idx1 with...
how to determine if we can delete the index can be removed
In SQL Server database, there is a table InventDim with two indexes: Idx1 with...
how to determine if we can delete the index can be removed
The table InventDim has some indexes, we create one index idx1 which has index...
Ask SSC