Execute SSIS Packages Error

Question

Execute SSIS Packages Error

Omar Y Aly 0

I Have mvc dotnet app that execute SSIS Package by calling Process in function and call DTExec.exe to execute the packages locally , i want to execute this packages remotely by ConnectionString because this packages in another server

i searched and find microsoft documentation and apply it but have a bad error when testing in console application

"System.IO.FileNotFoundException: 'Could not load file or assembly 'Microsoft.SqlServer.Diagnostics.STrace, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'. The system cannot find the file specified.'"

Thank you

AgaveJoe 1,510 Reputation points

2023-11-18T21:45:03.0533333+00:00

i want to execute this packages remotely by ConnectionString because this packages in another server

I think you are asking how to execute an SSIS package by executing a T-SQL script. The following might help.

Run an SSIS package from SSMS with Transact-SQL

i searched and find microsoft documentation and apply it but have a bad error when testing in console application

What documentation are you following? Is there any way you can show us the code?
Lan Huang-MSFT 30,221 Reputation points Microsoft External Staff

2023-11-20T07:09:34.14+00:00

Hi @Omar Y Aly,

How do you test this in a console application? What version of SQL Server is it? Is it consistent?

Maybe you can fix it by launching the installer package for your version of SQL Server.