Sample Header Ad - 728x90

SSIS AND XLSM load time issue Visual Studio 2010

0 votes
1 answer
92 views
I am having the following issue of SSIS AND XLSM load time issue Visual Studio 2010 I want to speed this up I am reading a .xlsm as my excel source I have noticed its loading / reading every row of the excel...even though they are blank e.g I only have 300 + rows of data at the moment, but it loading every row even though they are blank e.g going pass the 400 row where there is no data yet I don't want it reading 200,000+ rows before it actually loads the 300 how do I stop this please team
Asked by pete (11 rep)
Feb 1, 2019, 04:01 PM
Last activity: Feb 4, 2019, 11:40 AM