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

  • Is this a situation where you originally had 200k rows in the file, and deleted all but 300?
    – Jacob H
    Feb 1, 2019 at 16:04
  • no, ive only been adding the rows over the last few months , only now at the 300 row mark. please help
    – pete
    Feb 1, 2019 at 16:06
  • if it cant be stopped, is there a way of saying stop on row 1000 just to speed up package please?
    – pete
    Feb 1, 2019 at 16:10
  • Have you tried to copy and paste the 300 lines into a new Excel file?
    – McNets
    Feb 1, 2019 at 16:32
  • there are a lot of macros set up, unfortunately its not the case of copying and pasting the row :+( please help
    – pete
    Feb 1, 2019 at 19:14

1 Answer 1


I have resolved this by using an sql command in the excel properties, and only import where ID IS NOT NULL x

thank team for ideas x

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.