Hello,
Can someone please help me with an issue that I'm facing with setting up SSIS package where I am trying to generate a report in Excel file dynamically. Basically this Excel report needs to be generated on the second business day of every month with a date stamp.
I get an open row set error whenever I execute the package. In my source I am using a SQL query with a CTE. I want to code this package without using a script task.
Any guidance will be highly appreciated.