There is a Power Query activity in SSIS and Azure Data Factory, which can be more useful than other tasks in some situations.
Unlike an on premises SQL Server, Integration Services (SSIS) works very differently on Azure. If there are requirements to run our existing SSIS packages on Azure, then we need to understand our options. In this article we will talk about our options for migrating SSIS to Azure and what components are required to migrate SSIS packages. […]
In this article we look at how to securely store data in text files that could be used for SQL Server authentication or wherever you need to keep data secure.
When working on an SSIS project with multiple developers, a merge conflict can occur in the git repository. In this tip we'll show you how to resolve this type of conflict and provide alternative options.
For organizations relying on the SQL Server, Melissa's solutions directly integrate with SSIS, so the learning curve is minimal. You can drag and drop Melissa components in SSIS to validate, cleanse, append and enhance data.
Email based validation is more than just a simple RFC check, this is where Melissa's Global Email Verification with a web-based API and SSIS delivers valuable data to SQL Server Professionals.