Click here to Skip to main content
15,947,411 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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).

What I have tried:

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
Updated 6-Oct-16 22:26pm

1 solution

Don't try to hold all data at once. Do in batches. This your dataset would allow you to do the operations on it.
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900