Knowledge Base
Search Results ...
Using Common Table Expressions in SSIS Scripts
Common Table Expressions (CTEs) are a powerful tool in SQL that can simplify complex queries by breaking them down into more manageable pieces. In SQL Server Integration Services (SSIS) scripts, they can be used to improve readability and maintainability.[.....]
Implementing Data Governance with SQL Tags Note from the Data Whisperer
Welcome to the SQL Support blog. Today, we delve into an important element of database management, which is Data Governance. Data Governance entails the overall management of the availability, integrity, and security of the data employed in an enterprise.[.....]
Automating SSIS Package Deployment
The automation of SSIS package deployment is a critical aspect of the SQL Server Integration Services (SSIS) framework that can significantly improve efficiency and productivity. SSIS is a tool provided by Microsoft that enables complex data transformation[.....]
Using SQLCMD Variables in Deployment Scripts Note from the Data Whisperer
SQLCMD mode in SQL Server 2019 is an interactive command line tool for SQL Server that allows users to execute Transact-SQL commands directly, execute script files, and execute commands in an operating system. One of the powerful features of SQLCMD mode is[.....]
Using SSIS Script Task for REST API Calls
In today's data-driven world, integrating and synchronizing data across various platforms is a common necessity. With SQL Server Integration Services (SSIS), you can accomplish this task with ease. One of the powerful features of SSIS is the Script Task, w[.....]
Staging Strategies in ETL Using SSIS
Extract, Transform, Load (ETL) is a critical aspect of the data pipeline in any business. When working with SQL Server Integration Services (SSIS), understanding the best staging strategies is crucial to ensure efficient data flow, performance optimization[.....]
Writing Cross-Platform SQL Compatible Queries
SQL, short for Structured Query Language, has been the de facto standard for interacting with relational databases for many years. However, with the advent of numerous database management systems like SQL Server 2019, MySQL 8.0, DB2 11.5, Azure SQL, and Az[.....]
Writing SQL Audit Triggers for Compliance
In today's data-driven business world, it is more crucial than ever to ensure that your data is secure and compliance is maintained. SQL Server, as one of the most popular database platforms, offers various features to help you achieve this. One such featu[.....]
Generating Excel Files from SSIS
As data professionals, we are frequently tasked with exporting data from SQL Server and other databases into Excel files. In this blog post, we will explore how to generate Excel files from SQL Server Integration Services (SSIS), using SQL Server 2016, SQL[.....]
SSRS Subreports and Performance Optimization
In the world of business intelligence, SSRS (SQL Server Reporting Services) is a powerful tool that allows users to create, deploy, and manage reports. One feature of SSRS that is often used, but sometimes misunderstood, is the concept of subreports. Subre[.....]