Microsoft.SqlServer.BatchParser Issue

user_9982600 0
Viewed 1873

I created SSIS package:

  • this package is running powershell file
  • this powershell file is running SQL file

I tried to run this SSIS package with two ways :

  1. Use .bat file which executes the SSIS package >> This way is running successfully.
  2. Use powershell file which executes the SSIS package >> This way is failing with the following Error

Error Message:

Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version=15.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

Could I get help regarding this issue ??

I tried re-install SSMS-Setup-ENU but still have the same issue.

etl ssis powershell sql-server sql
2 Answers

After tried several feature packs and read a few discussion threads. I found jendev provided a repo in this discussion which you can clone and get the dll after compile.

If you don't have Visual Studio then take my fork which has included the exact dll already.

user_19736510

This issue fixed by using Import-Module Sqlps -DisableNameChecking; before executing sql script from ps file

user_99826000
Related