Forum Discussion
Where is my SSIS package reside in the SQL Server Agent -> Jobs?
Good Morning, I am newbie to the forum. I would like to get your expertise to tell me where do I need to look for my SSIS package that I just deploy to my sql server using a script. REM You ma...
Hello
You can deploy SSIS Packages to msdb , File or SSIS Catalog. then from SSMS you can create a job that executes a SSIS step and there pick the package.
Here is the info
https://learn.microsoft.com/en-us/sql/integration-services/packages/sql-server-agent-jobs-for-packages?view=sql-server-ver16
Regards
Javier
You can deploy SSIS Packages to msdb , File or SSIS Catalog. then from SSMS you can create a job that executes a SSIS step and there pick the package.
Here is the info
https://learn.microsoft.com/en-us/sql/integration-services/packages/sql-server-agent-jobs-for-packages?view=sql-server-ver16
Regards
Javier