a. Automation: SSIS runs on SQL Server, even though I’m designing it in Visual Studio and currently running these processes in the IDE. I know how to invoke SSIS packages from stored procedures, but I need some help with parameters, as we will have packages designed for multiple clients.
3. Using SSIS with SOAP or REST APIs
4. Performance tips
5. Possible Visual Studio extensions or third party tools that may be useful.
6. Impact on daily SQL Server performance.