Please, I have a requirement below to develop an ssis package to follow this sequence at runtime;
Step 1) Dynamically get previous month startdate and enddate parameter and stored these parameter in a variable table
Step 2) The two parameters should be inserted into a stored procedure , when stored procedure runs it populates a SQL Server table
Step 3) The SQL Server table should eventually be populated to an excel sheet.
I will appreciate if someone can help with the best route to resolve this in SSIS package.
Thanks in advance.