Microsoft BI Archives

SSRS Migration Case Study: Migrating SSRS Reports in a Disconnected Environment

Migrating SQL Server Reporting Services (SSRS) reports to AWS can be challenging, especially when the source and target environments are disconnected or air-gapped. Many organizations operate in secure environments where direct network connectivity between on-premises systems and AWS is not allowed. In this case study, we examine how Leidos, USA , completed an AWS SSRS migration […]

SSRS Migration Case Study: Migrating SSRS Reports in a Disconnected Environment Read More »

Download all SSRS Reports from Report Server

Microsoft BI, SSRS

If you are working with SQL Server Reporting Services (SSRS), one of the most common requirements is to download all SSRS Reports from Server in a single operation. This is especially useful when you want to migrate reports to another environment, back them up, or simply analyze the structure of your SSRS instance. Traditionally, administrators

Download all SSRS Reports from Report Server Read More »

Transferring Sensitive Data During SSIS Catalog Migrations to Another Server

Microsoft BI, SQL Server, SSIS

Migrating your SQL Server Integration Services (SSIS) Catalog to a new server or instance is a common administrative task, but it often brings with it a significant challenge: the secure handling of sensitive data. Packages within the SSIS Catalog frequently contain connection managers with sensitive information like database credentials, API keys, or other confidential parameters.

Transferring Sensitive Data During SSIS Catalog Migrations to Another Server Read More »

How to Migrate SSRS Reports from One Server to Another (Step-by-Step)

Microsoft BI, SQL Server, SSRS

In this guide, we’ll walk through the ssrs report migration process and share best practices to avoid common pitfalls.

How to Migrate SSRS Reports from One Server to Another (Step-by-Step) Read More »

CS2001 Missing AssemblyAttributes.cs when executing SSIS package deployed to the server

Microsoft BI, SQL Server, SSIS

How to resolve error : CS2001 Missing AssemblyAttributes.cs when executing SSIS package deployed to the server.

CS2001 Missing AssemblyAttributes.cs when executing SSIS package deployed to the server Read More »

The specified provider is not supported. Please choose different provider in connection manager SSIS

Microsoft BI, SSIS

If you encounter an error in SQL Server Data Tools (SSDT) for Visual Studio while working with SQL Server Integration Services (SSIS), it could be due to the missing OLE DB or ADO.NET provider on your machine. This missing component prevents SSIS from establishing a connection, leading to the following error message:

The specified provider is not supported. Please choose different provider in connection manager SSIS Read More »

An error occurred in the microsoft .net framework while trying to load assembly id 65536 SSIS

Microsoft BI, SQL Server, SSIS

Error An error occurred in the Microsoft .NET Framework while trying to load assembly id 65536. The server may be running out of resources, or the assembly may not be trusted. Run the query again, or check documentation to see how to solve the assembly trust issues. For more information about this error:System.IO.FileLoadException: Could not

An error occurred in the microsoft .net framework while trying to load assembly id 65536 SSIS Read More »

Create SSIS Catalog in SQL Server

Microsoft BI, SSIS

This article describes step by step approach to create SSISDB under Integration Services Catalog in SQL Server.

Create SSIS Catalog in SQL Server Read More »

Open ispac File in Visual Studio

Microsoft BI, SSIS

This article describes how to Open SSIS Package from ispac file or from Integration Services Catalog in SQL Server Data tools.

Open ispac File in Visual Studio Read More »

Export and import SSISDB in just a few clicks

Microsoft BI, SSIS

In this article, you will learn how to export and import SSISDB using SSIS Catalog Migration Wizard in just a few clicks.

Export and import SSISDB in just a few clicks Read More »

Cookie	Duration	Description
cookielawinfo-checkbox-analytics	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional	11 months	The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy	11 months	The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.