• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 569
  • Last Modified:

compare two different SSIS (job)

i know we have tool like DBDiff that can compare 2 databases. is there a tool to compare
two SSIS packages
or
two SQL jobs?

line by line (code by code).. the jobs, package is almost similar.. (same number of tasks etc)
0
25112
Asked:
25112
1 Solution
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
There is no 'Comapre SSIS Packages and identify differences' functionality in SSMS / VB / SSDT.

What you can do is open any super-dooper file comparison tool like Ultra Edit / Ultra Compare, then load both of the .dtsx packages (as they're XML format), then compare the two files.   Keep in mind you're going to see every little cosmetic difference as well as what you're really looking for.

Good luck.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now