none
Visual Studio Crashing when running SSIS Package RRS feed

  • Question

  • I was able to run the SSIS Package before but it suddenly crashes Visual Studio now. Restarting VS/Computer didn't help. Coworker checked out the same code and was able to run it fine. Below are the event logs. Haven't tried uninstalling VS/ SSDT yet, wanted to avoid doing that.

    Any help is appreciated, thanks.


    -System


    - Provider
    [ Name] ESENT
    - EventID 325
    [ Qualifiers] 0
    Level 4
    Task 1
    Keywords 0x80000000000000
    - TimeCreated
    [ SystemTime] 2019-11-04T21:57:43.255402700Z
    EventRecordID 49059
    Channel Application
    Computer LAPTOP-5IRK5G3Q
    Security
    - EventData
    devenv
    9352,D,35
    3951248b-0520-41ad-bc79-90c899a80606:
    1
    C:\Users\tamng\AppData\Local\Temp\5e6d7ea4-e533-470f-98fe-21aa3ecbfd17.model
    0
    [1] 0.001321 +J(0) +M(C:0K, Fs:5, WS:20K # 4K, PF:8K # 0K, P:8K) [2] 0.000003 +J(0) [3] 0.005870 -0.000004 (3) WT +J(0) +M(C:0K, Fs:32, WS:120K # 128K, PF:20K # 0K, P:20K) [4] 0.001350 +J(0) [5] 0.000150 +J(CM:0, PgRf:3, Rd:0/0, Dy:3/3, Lg:0/0) +M(C:0K, Fs:21, WS:84K # 76K, PF:128K # 44K, P:128K) [6] 0.002685 +J(CM:0, PgRf:226, Rd:0/0, Dy:22/214, Lg:0/0) +M(C:0K, Fs:109, WS:424K # 424K, PF:356K # 356K, P:356K) [7] 0.000006 +J(0) [8] 0.000001 +J(0) [9] 0.007956 -0.006551 (3) WT +J(0) +M(C:-44K, Fs:27, WS:-256K # 12K, PF:-404K # 8K, P:-404K) [10] 0.001106 -0.000050 (2) WT +J(CM:0, PgRf:352, Rd:0/0, Dy:11/46, Lg:0/0) +M(C:12K, Fs:50, WS:140K # 0K, PF:56K # 0K, P:56K) [11] 0.000003 +J(0).
    0 0


    - System
    - Provider
    [ Name] ESENT
    - EventID 105
    [ Qualifiers] 0
    Level 4
    Task 1
    Keywords 0x80000000000000
    - TimeCreated
    [ SystemTime] 2019-11-04T21:57:43.215723000Z
    EventRecordID 49057
    Channel Application
    Computer LAPTOP-5IRK5G3Q
    Security
    - EventData
    devenv
    9352,D,0
    3951248b-0520-41ad-bc79-90c899a80606:
    0
    0
    [1] 0.001701 +J(0) +M(C:0K, Fs:535, WS:2112K # 1876K, PF:3568K # 1860K, P:3568K) [2] 0.001235 +J(0) +M(C:32768K, Fs:216, WS:792K # 792K, PF:33668K # 33660K, P:33668K) [3] 0.000017 +J(0) +M(C:0K, Fs:1, WS:4K # 4K, PF:64K # 64K, P:64K) [4] 0.004593 +J(0) +M(C:0K, Fs:25, WS:44K # 84K, PF:140K # 140K, P:140K) [5] 0.001505 +J(0) +M(C:0K, Fs:5, WS:20K # 0K, PF:0K # 0K, P:0K) [6] - [7] - [8] - [9] - [10] - [11] - [12] - [13] 0.031720 +J(0) +M(C:0K, Fs:18, WS:40K # 48K, PF:-152K # 0K, P:-152K) [14] 0.000021 +J(0) +M(C:0K, Fs:3, WS:12K # 0K, PF:0K # 0K, P:0K) [15] 0.000064 +J(0) +M(C:0K, Fs:16, WS:64K # 48K, PF:64K # 0K, P:64K) [16] 0.000002 +J(0).
    - System
    - Provider
    [ Name] ESENT
    - EventID 102
    [ Qualifiers] 0
    Level 4
    Task 1
    Keywords 0x80000000000000
    - TimeCreated
    [ SystemTime] 2019-11-04T21:57:43.212251000Z
    EventRecordID 49056
    Channel Application
    Computer LAPTOP-5IRK5G3Q
    Security
    - EventData
    devenv
    9352,P,98
    3951248b-0520-41ad-bc79-90c899a80606:
    0
    10
    00
    17763
    0000
    - System
    - Provider
    [ Name] Windows Error Reporting
    - EventID 1001
    [ Qualifiers] 0
    Level 4
    Task 0
    Keywords 0x80000000000000
    - TimeCreated
    [ SystemTime] 2019-11-04T21:57:38.234706100Z
    EventRecordID 49055
    Channel Application
    Computer LAPTOP-5IRK5G3Q
    Security
    - EventData
    1409585273951575686
    1
    APPCRASH
    Not available
    0
    devenv.exe
    15.9.28307.770
    5d1a5d5e
    msexcl40.dll
    4.0.9801.17
    5d1844dd
    c0000005
    0000bb80
    \\?\C:\Users\tamng\AppData\Roaming\microsoft\visualstudio\15.0_4448e455\activitylog.xml \\?\C:\Users\tamng\AppData\Local\microsoft\visualstudio\15.0_4448e455\devenv.exe.config \\?\C:\Program Files (x86)\Microsoft Visual Studio\2017\Professional\Common7\IDE\devenv.isolation.ini \\?\C:\ProgramData\Microsoft\Windows\WER\Temp\WERB3F8.tmp.dmp \\?\C:\ProgramData\Microsoft\Windows\WER\Temp\WERD675.tmp.WERInternalMetadata.xml \\?\C:\ProgramData\Microsoft\Windows\WER\Temp\WERD6A5.tmp.xml \\?\C:\ProgramData\Microsoft\Windows\WER\Temp\WERD6B3.tmp.csv \\?\C:\ProgramData\Microsoft\Windows\WER\Temp\WERD6D3.tmp.txt
    \\?\C:\ProgramData\Microsoft\Windows\WER\ReportArchive\AppCrash_devenv.exe_ddf4c25893e2a53da216e8fec2d13cc24835685_e0e9d5ae_0edfe6b1
    0
    9bca2295-77b2-425a-a22d-ea5f25b38501
    268435456
    05e66b43169fdf35538fda569e815e86
    0
    - System
    - Provider
    [ Name] Application Error
    - EventID 1000
    [ Qualifiers] 0
    Level 2
    Task 100
    Keywords 0x80000000000000
    - TimeCreated
    [ SystemTime] 2019-11-04T21:57:24.355613900Z
    EventRecordID 49054
    Channel Application
    Computer LAPTOP-5IRK5G3Q
    Security
    - EventData
    devenv.exe
    15.9.28307.770
    5d1a5d5e
    msexcl40.dll
    4.0.9801.17
    5d1844dd
    c0000005
    0000bb80
    22b0
    01d5935a20f0155c
    C:\Program Files (x86)\Microsoft Visual Studio\2017\Professional\Common7\IDE\devenv.exe
    C:\Windows\System32\msexcl40.dll
    9bca2295-77b2-425a-a22d-ea5f25b38501
    - System
    - Provider
    [ Name] .NET Runtime
    - EventID 1026
    [ Qualifiers] 0
    Level 2
    Task 0
    Keywords 0x80000000000000
    - TimeCreated
    [ SystemTime] 2019-11-04T21:57:22.939660700Z
    EventRecordID 49053
    Channel Application
    Computer LAPTOP-5IRK5G3Q
    Security
    - EventData
    Application: devenv.exe Framework Version: v4.0.30319 Description: The process was terminated due to an unhandled exception. Exception Info: exception code c0000005, exception address 2783BB80 Stack: 

    Monday, November 4, 2019 10:31 PM

Answers

  • I can't share it maybe I'll try making new package that has the issue. I think it's just related to loading/validating too many excel files at once since splitting up the package seems to solve the issue.
    Tuesday, November 19, 2019 3:12 PM

All replies

  • Hi,

    Could you please tell me the version of your SSDT?

    Best Regards,

    Mona


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Tuesday, November 5, 2019 6:47 AM
  • My version is 15.9.2. I just installed everything a few weeks ago.
    Tuesday, November 5, 2019 4:18 PM
  • Hi,

    • May I know if you can create new SSIS project now?

    • Could you please check if you delete some folders related to SSDT?

               If so, it's better for you to reinstall the SSDT.

    Best Regards,

    Mona



    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com




    Wednesday, November 6, 2019 6:11 AM
  • I didn't delete any folders. Sometimes VS crashes sometimes it doesn't.

    I split up my package into 2 and the crashes are less frequent now as long as I don't open them both up at once. I thought I needed a better computer but I tried with a laptop with 16gb ram and i7 8th gen and it still crashes. My files are all <100MB too.

    Wednesday, November 6, 2019 5:08 PM
  • Hi,

    Please try to reinstall your SSDT.

    Best Regards,

    Mona


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Friday, November 8, 2019 10:00 AM
  • I installed it on my coworkers computers too and they had the same problem.
    Friday, November 8, 2019 3:25 PM
  • Hi,

    Please refer to Download and install SQL Server Data Tools (SSDT) for Visual Studio .

    Best Regards,

    Mona


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Tuesday, November 12, 2019 9:45 AM
  • Yes that was the page I used to install SSDT. I ran the Visual Studio Installer and added DataProcessing then I downloaded and installed Download SSDT for Visual Studio 2017 (15.9.2).
    Tuesday, November 12, 2019 4:59 PM
  • Hi,

    May I know if you download SQL Server and SSMS?

    Please refer to the following link:

    Can't run SSIS package in Visual Studio.The directory name is invalid

    Best Regards,

    Mona


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Wednesday, November 13, 2019 7:49 AM
  • Yes I have SQL Server and SSMS installed. The SSIS Package runs and populates my DB, and VS is crashing less now that I split the package into 2. I just want to know why VS is crashing when I still have available RAM.
    Wednesday, November 13, 2019 9:19 PM
  • Hi,

    Could you please share your SSIS packages?

    Best Regards,

    Mona


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Friday, November 15, 2019 7:46 AM
  • I can't share it maybe I'll try making new package that has the issue. I think it's just related to loading/validating too many excel files at once since splitting up the package seems to solve the issue.
    Tuesday, November 19, 2019 3:12 PM