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 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
- 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 /File "c:\temp\addUser.dtsx"
MinhTran360 . the location of the SSIS package = .dstx stands in the execution command: "c:\temp\addUser.dtsx"
