Red Gate forums :: View topic - SSIS Compare?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
DTS Package Compare 2
DTS Package Compare 2 forum

SSIS Compare?

Search in DTS Package Compare 2 forum
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
mglenn



Joined: 13 Sep 2006
Posts: 16

PostPosted: Fri Jul 18, 2008 12:23 am    Post subject: SSIS Compare? Reply with quote

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...
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1114
Location: Twitter: @dtabase

PostPosted: Fri Jul 18, 2008 11:32 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
woodmark



Joined: 02 Dec 2008
Posts: 3

PostPosted: Wed Mar 03, 2010 11:47 pm    Post subject: SSIS Dependancy Checker Reply with quote

Any plans for incorporating dependency checking into SSIS packages?
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1114
Location: Twitter: @dtabase

PostPosted: Thu Mar 04, 2010 10:58 am    Post subject: Reply with quote

Hi,

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

David
Back to top
View user's profile Send private message Send e-mail
woodmark



Joined: 02 Dec 2008
Posts: 3

PostPosted: Thu Mar 04, 2010 1:45 pm    Post subject: SSIS Package Dependency Checker Reply with quote

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.
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1114
Location: Twitter: @dtabase

PostPosted: Thu Mar 04, 2010 1:49 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
austrianfoodispuke



Joined: 05 May 2008
Posts: 59

PostPosted: Mon Mar 14, 2011 10:21 am    Post subject: It doesn't have to be the same results interface as SSIS Reply with quote

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
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1114
Location: Twitter: @dtabase

PostPosted: Fri Mar 18, 2011 2:55 am    Post subject: Re: It doesn't have to be the same results interface as SSIS Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group