topic Re: Trigger SSIS job from SAS code in SAS Enterprise Guide

Trigger SSIS job from SAS code

mshparber_fnx — Sun, 01 May 2022 09:13:41 GMT

Hello friends,

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

I know it is possible, please help.

Re: Trigger SSIS job from SAS code

AlanC — Sun, 01 May 2022 13:53:50 GMT

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-server-ver15

Re: Trigger SSIS job from SAS code

SASKiwi — Sun, 01 May 2022 20:11:51 GMT

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 Docs