如何使用ssis将sp结果的大量数据加载到excel中的多个工作表中。 [英] How to load huge data of sp result to multiple sheets in an excel using 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).

我尝试过：

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

推荐答案

不要试图一次性保存所有数据。分批进行。您的数据集允许您对其进行操作。

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

这篇关于如何使用ssis将sp结果的大量数据加载到excel中的多个工作表中。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！