Save Out Excel Worksheets to CSV Files Using Visual Basic
Introduction Ever found yourself needing to separate Excel worksheets into CSV flat files to make it easier to ingest for ETL? Well I’m going to walk you through the steps to take to get this done using Visual Basic(VBA). With the help of VBA and Macros in Excel, we can get the job done […]
Harnessing the Power of Data-Driven Subscriptions in SQL Server Reporting Services (SSRS)
SQL Server Reporting Services (SSRS) is a robust platform for designing, creating, and delivering reports. One of its standout features is Data-Driven Subscriptions. In this blog post, we’ll explore how Data-Driven Subscriptions can revolutionize the way you distribute reports, automate workflows, and customize content based on recipient data. As of this posting, this feature is […]