Powershell to run SSIS package using dtexec

Question

Hi,

I need to develop powershell script to run SSISpackage using dtexec

below is my code.

$dtexecLocation="D:\Program Files (x86)\Microsoft SQL Server\130\DTS\Binn\DTExec.exe"

$dtexecLocation /FILE "D:\SSIS\abc.dtsx" /CONFIGFILE "D:\SSIS\abc.config"

I am getting Unexpected token 'FILE' in expression or statement.

Thanks,

Siva.

Answer 1

Hi @Sivasankar Rebba,

Why not directly use dtexec to run the package?

Such as:

DTExec /FILE "D:\SSIS\abc.dtsx" /CONFIGFILE "D:\SSIS\abc.config"

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.