| Author |
Message |
mglenn
Joined: 13 Sep 2006
Posts: 16
|
 Posted: Fri Jul 18, 2008 12:23 am Post subject: SSIS Compare? |
 |
|
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 |
|
 |
David Atkinson
Joined: 05 Dec 2005
Posts: 1080
|
| Posted: Fri Jul 18, 2008 11:32 am Post subject: |
|
|
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 |
|
|
woodmark
Joined: 02 Dec 2008
Posts: 3
|
| Posted: Wed Mar 03, 2010 11:47 pm Post subject: SSIS Dependancy Checker |
|
|
| Any plans for incorporating dependency checking into SSIS packages? |
|
| Back to top |
|
|
David Atkinson
Joined: 05 Dec 2005
Posts: 1080
|
| Posted: Thu Mar 04, 2010 10:58 am Post subject: |
|
|
Hi,
Thanks for the post. What would you be trying to achieve here?
David |
|
| Back to top |
|
|
woodmark
Joined: 02 Dec 2008
Posts: 3
|
| Posted: Thu Mar 04, 2010 1:45 pm Post subject: SSIS Package Dependency Checker |
|
|
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 |
|
|
David Atkinson
Joined: 05 Dec 2005
Posts: 1080
|
| Posted: Thu Mar 04, 2010 1:49 pm Post subject: |
|
|
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 |
|
|
austrianfoodispuke
Joined: 05 May 2008
Posts: 59
|
| Posted: Mon Mar 14, 2011 10:21 am Post subject: It doesn't have to be the same results interface as SSIS |
|
|
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 |
|
|
David Atkinson
Joined: 05 Dec 2005
Posts: 1080
|
| Posted: Fri Mar 18, 2011 2:55 am Post subject: Re: It doesn't have to be the same results interface as SSIS |
|
|
| 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 |
|
|
|
