In Expressions of this data flow task, set. Set the DelayValidation property of this data flow task to 'True' to bypass the validation before execution Set SQLStatement in Expressions: 'CREATE TABLE `' + User:: sheetName] + '` ( `column1` INTEGER)'Ĭreate ADO NET Source component to load data from SQL ServerĬreate Excel Destination component to load data to Excel table Map the result of count to variable User:: rowcount in Result Set page Set SQLStatement: select count(*) as count from dbo.int
Create a Data Flow Task In For Loop Container to load chunk data to Excel sheetīelow document describe the details for each component Create a Execute SQL Task in For Loop Container to create Excel sheet for each chunkĤ. Create a For Loop Container to split the row count to n chunksģ. Create a Execute SQL Task to read row count from SQL ServerĢ. Split the rows to n chunks in a For Loop Container, create an Excel sheet for each chunk and load data into itġ. Read row count of the data to load from SQL Server and save the row count in variableĢ. This sample SSIS package has below steps:ġ.
