i have a requirement where i need to load a stored procedure result into a excel using ssis . The data which my sp is giving is huge and the count is more than the Excel holding limit (10 lakhs).
i decided to load the data into multiple sheets using ssis Script task to resolve the (10 lakh) excel limitation but the problem i am facing is i am not able to hold the data in Data set to do my operations.Please help
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)