Click here to Skip to main content
15,667,436 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:

I am using Excel Source with around more than 11000 rows which varies from file to file and loading these to sql server table.
I want to configure the buffer rows dynamically how to make it using variables.

Please suggest.


What I have tried:

I have no idea how to compute the length of column in excel

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