In SQL Server Integration Services projects, it’s possible to parameterize OLEDB data connections so that a different Data Source (SQL Server) and Initial Catalog (Database)…
Tag: Business Intelligence
Aim: To access hidden sheets in Excel files with protected structures using Google Sheets. In an earlier post, I described how to unhide Very Hidden…
Aim: To unhide Very Hidden Sheets in Excel. As part of a recent data warehouse project, I had to extract data from an Excel spreadsheet…