Where do I look for my SSIS pasckage that just being deployed to my sql server?

[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

 

[mark williams]

When you deploy an SSIS (SQL Server Integration Services) package to your SQL Server using a script, the package is typically stored in one of the following locations within the SQL Server environment:

1. SSISDB Catalog (Project Deployment Mode)
If you are using the project deployment model (the more modern and commonly used model), the SSIS package will be stored in the SSISDB catalog. To find your deployed package:

Open SQL Server Management Studio (SSMS).
Connect to the SQL Server instance where you deployed the package.
Expand the Integration Services Catalogs node in the Object Explorer.
Expand the SSISDB node.
Navigate to the project and folder where your package was deployed. You should see your package listed under the Packages node of the appropriate project.
2. MSDB Database (Package Deployment Mode)
If you are using the older package deployment model, the SSIS package will be stored in the MSDB database. To locate your package:

Open SQL Server Management Studio (SSMS).
Connect to the SQL Server instance where you deployed the package.
In the Object Explorer, expand the Management node.
Expand the Legacy node (if available).
Expand the Stored Packages node.
Expand the MSDB node.
You should see your deployed package listed under the appropriate folder.
3. File System
If you deployed the SSIS package to the file system, the package will be stored on the disk at the specified location. Typically, you would look for the package in a directory such as:

Default SSIS Package Store Location: C:\Program Files\Microsoft SQL Server\130\DTS\Packages (the path may vary depending on your SQL Server version and installation settings).
To locate the package:

Open Windows Explorer.
Navigate to the folder where you deployed the package.
Look for the .dtsx file corresponding to your SSIS package.
How to Verify Deployment and Package Location
Using SSMS for SSISDB Catalog:
Querying SSISDB Catalog:
sql
Copy code
SELECT
p.name AS PackageName,
f.foldername AS FolderName,
p.project_name AS ProjectName,
p.object_id AS PackageObjectId
FROM
catalog.packages AS p
JOIN
catalog.folders AS f ON p.folder_id = f.folder_id
WHERE
p.name = 'YourPackageName'; -- Replace with your package name
Using MSDB Database:
Querying MSDB for Deployed Packages:
sql
Copy code
USE msdb;
GO
SELECT
name,
description,
package_format,
package_data
FROM
dbo.sysssispackages
WHERE
name = 'YourPackageName'; -- Replace with your package name