Trigger SSIS job from SAS code

[mshparber_fnx]

Hello friends,

I have a SSIS package/job that I want to trigger from SAS EG.

I know it is possible, please help.

[AlanC]

Use the X command, call Powershell, and run the SSIS package using Powershell. Your environment may not allow the X command so get back if it doesnt.

See this documentation from MS: https://docs.microsoft.com/en-us/sql/integration-services/ssis-quickstart-run-powershell?view=sql-se...

[SASKiwi]

If you have SAS/ACCESS to SQL Server or SAS/ACCESS to ODBC you can use SQL Passthru and the EXECUTE statement to run an SSIS package. Here is an example:

Run an SSIS package with Transact-SQL (SSMS) - SQL Server Integration Services (SSIS) | Microsoft Do...