Solved

compare two different SSIS (job)

Posted on 2015-01-13
1
485 Views
Last Modified: 2016-02-15
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
Comment
Question by:25112
1 Comment
 
LVL 65

Accepted Solution

by:
Jim Horn earned 500 total points
ID: 40548910
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL trigger 5 18
SSIS Start 2 20
Compare a numeric value to a varchar w/o getting an error 4 18
How can I get the entire database script? 7 11
My client has a dictionary table. They're defining a list of standard naming convention. Now, they are requiring my team to provide us a mechanism how to match new incoming data with existing data in their system.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

790 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question