Question Can we perform cross join (cartesian product) operation using Merge Join transform in SSIS? Scenario The above question was asked in one of the social forums recently. I was able to give the response to this.I’m sharing the solution…
T-SQL Tips: Execute Individual Packages in Project Deployment Model using Dtexec
Question Can we execute individual packages included in a SSIS 2012 project configured in project deployment model using dtexec utility? Scenario The above question was the main topic of discussion in one of the recent casual conversations with my fellow…