Where is my SSIS package reside in the SQL Server Agent -> Jobs?

[MinhTran360]

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 may deploy the packages from a different server if Visual Studio is installed somewhere other than the SQL server

"C:\Program Files\Microsoft SQL Server\130\DTS\Binn\dtutil.exe" /Copy SQL;"Add User" /DestServer "MyServer" /DestUser "myname" /destpassword "Mypassword" /File "c:\temp\addUser.dtsx"
PAUSE SSIS Package install completed

  I look for my package addUser in my SSMS sql server agent -> job but I could not find it.

I wonder where else should I look?

Many Thanks,

Me

[#2]

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-packag...

Regards
Javier

[#3]

/File "c:\temp\addUser.dtsx"

---

@MinhTran360 . the location of the SSIS package = .dstx stands in the execution command: "c:\temp\addUser.dtsx"