How to deploy your zappysys ssis package in sql server 2025

[daniel]

Introduction

In this article, you will learn how to deploy an SSIS package that uses the ZappySys SSIS PowerPack into SQL Server 2025. Proper deployment ensures that your packages run reliably in production environments, whether they include REST API integrations, ODBC connections, file system operations, or cloud-based data sources.

This guide walks you through installing SQL Server 2025 for development and deploying your SSIS package using the SSIS Catalog (SSISDB).

Prerequisites

• A working SSIS package.
• SQL Server Agent installed.
• Download and install the ZappySys SSIS PowerPack.

Step 1: install sql server 2025 and sql server management studio

1. Download the SQL Server installer from the official download page.

2. Launch SQL Server Setup and select the installation type. For this scenario, choose a custom installation.
   

   

3. Select New SQL Server stand-alone installation.

4. Under Installation edition, choose Standard Developer.

5. Select the required components, including Database Engine Services and Integration Services.

6. On the Instance Configuration page, choose one of the following options:

   • Default instance (MSSQLSERVER), or
   • Named instance (custom)

7. On the Database Engine Configuration page, select the authentication mode:

   • Mixed Mode, and set the SQL administrator password.

8. Add the current user as a SQL administrator.

9. Click Next, review the summary, and proceed with the installation.

10. After the installation completes, copy the connection information and click Install SSMS to download the SQL Server Management Studio 22 installer.

11. Run the installer.
    

    

12. Complete the installation of SQL Server Management Studio 22.
    

    

13. Open SSMS and connect to SQL Server 2025 using the connection information from the installation.
    

    

Step 2: Build the ssis project in Visual Studio

1. Open your SSIS project in Visual Studio (SSDT).

2. Create an SSIS package. In this example, the package includes a JSON source, an Upsert destination, and a Trash destination.
   

   

3. Execute the package and verify that it runs successfully.
   

   

Step 3: Deploy your package to SSISDB (project deployment model)

1. Open SQL Server Management Studio (SSMS).

2. Right-click Integration Services Catalogs and select Create Catalog.

3. Set an encryption password and click OK.
   

   

4. Expand Integration Services Catalogs, right-click SSISDB, and select Create Folder. Enter a folder name and click OK.
   

   

5. Right-click the newly created folder and select Deploy Project.
   

   

6. Select the .ispac file generated from your SSIS project, click Next, and choose SSIS in SQL Server.
   

   

7. Enter the server name, click Connect, verify the target path created in the previous step, and click Next.
   

   

8. Continue clicking Next until the Deploy button is available. Click Deploy, and then click Close once deployment completes.
   

   

Step 4: Create a SQL Server agent job

1. In SSMS, expand SQL Server Agent and ensure the service is running.

2. Right-click Jobs and select New Job.

3. In the General tab, enter a job name (for example, FirstProject).
   

   

4. Go to the Steps tab and click New.

5. Enter a step name.

6. For Type, select SQL Server Integration Services Package.

7. For Run as, select SQL Server Agent Service Account.

8. For Package source, select SSIS Catalog for SSISDB deployments or File System for .dtsx files.

9. Specify the server name and package path, then click OK.
   

   

10. Go to the Schedules tab and click New.

11. Enter a schedule name.

12. Define the execution frequency (for example, daily or weekly).

13. Configure the start time and recurrence.

14. Click OK to save the schedule.
    

    

15. Click OK to save the job.

Step 5: Run and monitor the job

1. In SSMS, navigate to SQL Server Agent → Jobs.
2. Right-click the job and select Start Job at Step.
3. Monitor the execution dialog and confirm that all steps complete successfully.
   
   

Conclusion

Deploying SSIS packages that use the ZappySys SSIS PowerPack to SQL Server 2025 is straightforward when you follow a structured installation, deployment, and scheduling process. By installing SQL Server correctly, deploying packages to SSISDB, and automating execution with SQL Server Agent, you can build reliable and scalable data integration workflows.

Explore our SSIS PowerPack for more information and download and install it to start building smarter, faster, and more scalable solutions.

References

• How to design, debug, deploy, schedule SSIS Package (In SQL Agent and Catalog)
• How to parameterize properties in SSIS package and configure them in a SQL job
• SSIS PowerPack

Contact us

If you encounter any issues or have specific questions, reach out to our support team via live chat or support ticket using our email support@zappysys.com.