Data

SSIS Consulting

SSIS packages fail quietly, run longer every quarter, or live on a server nobody wants to patch. The first job is to make the ones you depend on reliable.

Keep the package, or move it

Not every SSIS package should be rewritten. Catalog deployment, configuration and a failure you can see are often enough. Packages that are blocked by an old runtime, or that need to run next to Azure data, are the ones to consider for Azure Data Factory. We recommend that package by package.

The wider integration practice, including AWS DMS, is on ETL and data integration.

What we look at

  • Which packages the business cannot skip
  • Where they are deployed and how they are configured
  • Failures that do not notify anyone
  • Runtime and SQL Server version constraints
  • Which packages, if any, should leave SSIS

Tell us which package is the problem

The SQL Server version, where SSIS runs, and whether you want it repaired or considered for Azure Data Factory.