SSIS packages executed through SQL Agent Job scheduler fails while connecting to Azure File Storage Path

Recently we ran into an interesting scenario where we had a SSIS package that contained a script task and inside the script task, we were making connections to Azure File Storage and pulling the data from the file. While running this SSIS package from Visual Studio – SQL Server Data Tools (SSDT) & after deploying…


SSIS Scale Out worker is not showing up in Worker Agents

  Understanding of the issue: Adding the scale out worker to the master shows successful but this does not show up in the SQL Server integration services – Manage Scale Out (ISManager). Also, this will not be added in [SSISDB].[internal].[worker_agents] Adding SSIS worker completes in the wizard as below After this finished, if we check…


“Unexpected error from external database driver (1). (Microsoft JET Database Engine)” after applying October security updates.

UPDATE: As informed, the security patches with the fix was rolled-out yesterday 11/14. We would request you to test this and verify that the issue is addressed. If not, please let us know. Please find the information below, Windows 2008 https://support.microsoft.com/en-us/help/4050795/unexpected-error-from-external-database-driver-error-when-you-create-o Windows 7/2008 R2 -Monthly Roll-up – https://support.microsoft.com/en-us/help/4048957/windows-7-update-kb4048957 -Security-only update – https://support.microsoft.com/en-us/help/4048960/windows-7-update-kb4048960 Windows 2012 -Monthly Roll-up…


ARM Resource Manager Template Deployment with Azure Analysis Services

Analysis Services model can be deployed in Azure in different ways like from SSDT or by running the JSON create script from SSMS. We can leverage the richness of template deployment in our Azure Analysis Services as well. What is Template Deployment in Azure? The Resource Manager template you deploy can either be a local…


How to display report parameter Label field in RDLC reports

While working on customer issue recently, I came across following scenario where there was a problem in displaying the report parameter label filed in the RDLC reports. Scenario and issue: Let’s say we have report parameter called “Customer” in the RDLC report which get values from the “DataSet1” as shown below We have a text…


Reporting Services Web Services with .NET CORE 2

  Any application built using .NET CORE SDK can be executed on any platform (Windows, Linux & Mac). But due to this there are a lot of APIs available in .NET Framework that are no longer available in .NET CORE. One of the missing APIs is Web Service (SOAP) Clients. The way to move forward…


SQL Server Reporting Services 2016 Integration with an Application

There are multiple ways to integrate or embed SQL Reporting Services Report in an application. This can be achieved via:- URL Access Method Using SOAP APIs Using Report Viewer Control Couple of common issue that we face while calling reports in an application are: – How to pass credentials from application to SSRS. How to…


Automating Azure Analysis Service Processing using Azure Automation Account

  Analysis Services has been progressing day-by-day with new exciting features and there is an ask from the users to automate the Azure Analysis Services Processing. There are few ways which we can automate the processing. Using the conventional way what we have for the On-Prem. Using SQL Agent Job/ Using AMO Objects/ Using PowerShell….


SSRS – Bing Maps seem to be broken with latest changes in Bing Map Service

Reporting Services Reports that contain Bing Maps seem to broken due to a change in the Bing Map APIs. From the initial analysis, Bing Maps SOAP web service seems to be shut down after July 31, 2017. When we access the Bing Maps API from SSRS we are calling into this method http://dev.virtualearth.net/webservices/v1/imagery/contracts/IImageryService/GetImageryMetadata, and are…