topic Re: Execute SSIS Package from BP in Digital Exchange

Execute SSIS Package from BP

nanditaradhakrishna — Tue, 04 Nov 2025 07:28:13 GMT

Hi all,

I am trying run a SSIS package, is there a way to run SSIS Package from Bp other than running from cmd?

Thanks,

Nandita

Re: Execute SSIS Package from BP

ivan.gordeyev — Tue, 18 Nov 2025 10:11:39 GMT

Yes.

I encourage you to use a 'Stored Procedure' for this purpose.
Create a stored procedure e.g. "sp_SSIS_package" that would trigger SSIS package.
Ensure that stored procedure has relevant access (Properties > Permissions)

Then, using Blue Prism action:
'Data - SQL Server - Execute'
you can trigger "execute dbo.sp_SSIS_package"

Re: Execute SSIS Package from BP

nanditaradhakrishna — Mon, 15 Dec 2025 07:43:38 GMT

Hi Ivan,

Can you please share the SP script to run SSIS package if possible?

Thanks,

Re: Execute SSIS Package from BP

naveed_raza — Mon, 15 Dec 2025 10:59:47 GMT

@nanditaradhakrishna - you can refer to this site on how you can execute SSIS package via store procedure.

You have deploy your SSIS package and then you can create the store procedure all details about deployed SSIS package.

https://www.mssqltips.com/sqlservertip/2992/how-to-execute-an-integration-services-ssis-package-from-a-sql-server-stored-procedure/