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"

[nanditaradhakrishna]

 Hi Ivan,

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

Thanks,

[naveed_raza]

@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/