Execute SSIS Package from BP

[nanditaradhakrishna]

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

[ivan.gordeyev]

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"