BBQ operates a SQL Server 2019 data warehouse with ETL processing handled through SQL Server Integration Services (SSIS). Under an internal security policy, the client rotates passwords and migrates its data warehouse environment from one server to another every six months.

Business Challenges

Each infrastructure rotation cycle required every SSIS package and ETL job on the existing server to be re-established on a new server without interrupting scheduled data processing.

Recurring infrastructure rotation

Under the client's security policy, the data warehouse environment and its passwords are migrated to a new server every six months, requiring every dependent workload to be re-established each cycle.

Live ETL continuity risk

All SSIS packages and ETL jobs running on the existing server needed to be migrated and reconfigured on the new server without interrupting scheduled jobs.

Performance and stability requirements

The migration needed to preserve existing execution time and job stability, with no tolerance for functional issues or performance degradation.

Project Objectives

Geopits scoped the engagement to migrate every SSIS package from the legacy SQL Server data warehouse to the new environment without disrupting the client's ETL schedule or performance baseline.

Key Goals:

Migrate all existing SSIS packages to the new data warehouse server with no functional issues
Preserve existing execution time and job stability throughout the cutover
Validate that all ETL jobs run as expected in the new environment before handoff

Solution Provided by Geopits

Geopits ran the migration as a structured, four-step process covering package transfer, reconfiguration, deployment, and validation.

Package Transfer

Copied all existing SSIS (.dtsx) packages from the old server to the new server.

Connection Manager Reconfiguration

Updated all Connection Managers in the SSIS packages to point from the old data warehouse to the new data warehouse.

Deployment

Deployed all reconfigured SSIS packages to the new data warehouse server.

Performance Tuning & Validation

Executed index rebuilds across all tables to optimize database performance, then validated that all ETL jobs were running as expected in the new environment.

Results & Business Impact

The figures below reflect the scope and outcome of this migration engagement as reported by the client's team.

Capabilities

Before

After

SSIS packages

Running on the previous data warehouse server

Migrated and redeployed on the new data warehouse server

Connection Managers

Pointed to the old data warehouse

Reconfigured to the new data warehouse

Index maintenance

[not documented in engagement scope]

Rebuilt across all tables post-migration

ETL job status

[not documented in engagement scope]

Validated running as expected with no functional issues

Key outcomes

100% of SSIS packages migrated

Every existing .dtsx package was copied, reconfigured, and redeployed to the new data warehouse server.

Zero functional issues or performance degradation

Every migrated package and ETL job ran successfully post-cutover, preserving the execution time and stability the client required

Full index rebuild completed

Index rebuilds were executed across all tables on the new server to optimize database performance.

Conclusion

Geopits completed the SSIS and ETL migration within BBQ's six-month infrastructure rotation window, moving every package to the new data warehouse server without disrupting live data processing. The client's ETL jobs now run on the new environment with performance and stability matching the previous baseline.

Ready to Transform Your Data?

Geopits works alongside your team as a strategic partner, starting with stabilizing your current databases, then modernizing your data infrastructure, and ultimately helping you unlock the full potential of AI.

Book a Demo Learn More

170

Happy Clients so far

2100+

Databases Managed

142+

Successful Migrations

At Geopits, our mission is to empower businesses to achieve reliable, secure and high-performing database environments and to derive meaningful business insights.