An All new video on using TSQL task in SSIS to run a query and fetch data from the database and assign it to a table. All part […]
Unable to establish server mode SSAS tabular mode
Ever encountered the above error when starting SQL server management studio and connecting to SSAS ? The error has a few different root causes one of which is […]
Mary Series 3: Using SSIS to extract terms
All characters, events and data in this series are fictional. Any resemblance to any person living or dead is simply probability at work (More on that in the […]
Mary connects her Excel sheet to SQL and start using pivots to view her data
All characters, events and data in this series are fictional. Any resemblance to any person living or dead is simply probability at work (More on that in the […]
SSRS Sorting data within a Report
Sometimes when we create reports we define the sort order of the data within the report itself. This allows the user to pick and choose data based on […]
SSRS Reports not rendering beyond 90 seconds
Today I came across an interesting problem with SSRS and ASP.Net. I usually have all my reports optimized to run quickly, this includes creating snapshots revisiting indexes etc. […]
Displaying a report in Landscape mode when exporting to PDF
Often the report doesn’t fit within the boundaries of the page and these results in part of a tale being moved to the next page. When you want […]
Drill through Reports
In the below report we are fetching the column that are present within a particular table by Entering the table name as an Input parameter. This works fine […]
Adding a parameter to the Report
We add parameters to reports to be able to dynamically fetch very selective data from the underlying database. Sometimes parameters are used for controlling the behaviour of a […]
Loading data from Excel AcquireConnection Error
[Excel Source [108]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager “Excel Connection Manager” failed with error code 0xC0209303. There may be error […]