SSIS Compare?

DTS Package Compare 2

SSIS Compare?

Postby mglenn » Fri Jul 18, 2008 12:23 am

Well it's mid-2008 and SQL Server 2008 will be released soon. Any word on whether there will ever be an SSIS 2005 Compare?

I supposed I could just compare the .dtsx XML files, but if the differences are scattered throughout it could be tough to decipher...
mglenn
 
Posts: 16
Joined: Wed Sep 13, 2006 2:36 pm

Postby David Atkinson » Fri Jul 18, 2008 11:32 am

Hi,

Sadly we have no plans to release an SSIS Compare tool at this point.

Thanks for the request.

David Atkinson
Product Manager
Red Gate Software
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

SSIS Dependancy Checker

Postby woodmark » Wed Mar 03, 2010 11:47 pm

Any plans for incorporating dependency checking into SSIS packages?
woodmark
 
Posts: 3
Joined: Tue Dec 02, 2008 9:35 pm

Postby David Atkinson » Thu Mar 04, 2010 10:58 am

Hi,

Thanks for the post. What would you be trying to achieve here?

David
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

SSIS Package Dependency Checker

Postby woodmark » Thu Mar 04, 2010 1:45 pm

If I run a Dependancy Checker against a database and if the SSIS packages were stored in the database store (or I could pick .dtsx files) it would tell me of any dependancies.

There would be 2 uses:
1) Documentation - document what objects a package uses without having to go through it. Yes, I know that the programmer/dba should maintain this, but as a consultant I often come into clients where no such documentation exists and we need to create it.

2) Troubleshooting - it would help when digging into a database and trying to figure out what's going on.
woodmark
 
Posts: 3
Joined: Tue Dec 02, 2008 9:35 pm

Postby David Atkinson » Thu Mar 04, 2010 1:49 pm

We have a product that tracks dependencies that currently ignores SSIS. The solution might be to make this product SSIS-aware. Another solution would be to make our free SQL Search tool SSIS-aware.

Thanks for drawing this use case to our attention.

Kind regards,

David
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

It doesn't have to be the same results interface as SSIS

Postby austrianfoodispuke » Mon Mar 14, 2011 10:21 am

Are there still plans to release an \"SSIS Compare\" tool?

The results wouldn't have to look exactly like the SSIS interface/BIDS.

At this moment, anything would be better than nothing
austrianfoodispuke
 
Posts: 59
Joined: Mon May 05, 2008 1:44 pm

Re: It doesn't have to be the same results interface as SSIS

Postby David Atkinson » Fri Mar 18, 2011 2:55 am

austrianfoodispuke wrote:Are there still plans to release an "SSIS Compare" tool?

The results wouldn't have to look exactly like the SSIS interface/BIDS.

At this moment, anything would be better than nothing


We haven't ruled it out, but it's not on the immediate roadmap. Is this more so you can compare or do you need this to deploy SSIS on different servers?

David
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase


Return to DTS Package Compare 2

Who is online

Users browsing this forum: No registered users and 1 guest