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)
LVL 5
25112Asked:
Who is Participating?
 
Jim HornConnect With a Mentor Microsoft 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.