SSIS: Visual Studio crashed when loading a large excel file

• krishna.packiarajah

  SSC Rookie

  Points: 48

  More actions

  July 23, 2017 at 3:29 pm

  #343663

  Hello,

  Here the situation, when I want to load a large excel file (more than 230MB) as a datasource the Visual Studio crashed..

  I am new using SSIS and I have an issue with it. 

  Do you have any idea to solve this problem?

  Changing Visual studio parameter (If yes, how?)? Split the excel file into multiple excel files automatically? Or any suggestions?

• Phil Parkin

  SSC Guru

  Points: 247158

  More actions

  July 23, 2017 at 4:14 pm

  #1952284

  You could try exporting to a text file and importing that.

  ---