Pass Parent Package Values to Child Packages via Parameter Binding
Introduction I was working on a project that required passing of variable values obtained from a parent package query to the child packages and want to share with you how I was able to achieve this. For my project, I had to get the latest date from the Insert Date column and calculate the […]
ADF vs. SSIS: Choosing Your Data Integration Champion
Data integration can be a bit of a head-scratcher, especially if you’re a newcomer. But fear not, for I’m here to break it down in the simplest terms possible. In the world of Microsoft, two heavy hitters stand out for data integration: Azure Data Factory (ADF) and SQL Server Integration Services (SSIS). So, let’s embark […]