SSIS in VS 2017 returns error on SQL Task

0

This is weird. On any SQL Task regardless of ADO.NET or OLEDB connection. Run debug and get The Execute method on the task returned error code 0x80070002 (Could not load file or assembly 'Microsoft.SqlServer.BatchParser, blah-blah

ssis
sql-server-data-tools
asked on Stack Overflow May 8, 2018 by user1160841

1 Answer

0

Thanks Tab Think I found it. Had to look real close in the GAC. The error message was right on the money. I had to hunt down MS SqlServer 2016 Feature Pack - a kitchen sink download that included ENU\x64\SharedManagementObjects.msi. Good old MS. They never make it easy, do they.

answered on Stack Overflow May 9, 2018 by user1160841

User contributions licensed under CC BY-SA 3.0