Microsoft.SqlServer.BatchParser Issue

Question

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.

Answer 1

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