Как загрузить огромные данные результата sp на несколько листов в excel с помощью ssis.
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