Red Gate forums: DTS Package Compare 2

editing a dts package

balajiammananna — Mon, 18 Apr 2011 10:09:25 GMT

Hi All,

Currently i am working on issue which is related to editing a dts package.

there is a dts package which creates 6 reports daily from a database .
the requirement is that i need to stop 4 of the reports and to continue the remaining two reports.

could you please give me clarification that how to proceed with this issue.

thanks and regards
balaji

RE: SSIS Compare?

David Atkinson — Fri, 18 Mar 2011 01:55:52 GMT

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

RE: SSIS Compare?

austrianfoodispuke — Mon, 14 Mar 2011 09:21:21 GMT

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

RE: SSIS Compare?

David Atkinson — Thu, 04 Mar 2010 12:49:32 GMT

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

RE: SSIS Compare?

woodmark — Thu, 04 Mar 2010 12:45:51 GMT

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.

RE: SSIS Compare?

David Atkinson — Thu, 04 Mar 2010 09:58:00 GMT

Hi,

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

David

RE: SSIS Compare?

woodmark — Wed, 03 Mar 2010 22:47:04 GMT

Any plans for incorporating dependency checking into SSIS packages?

DTS PACKAGE COMPARE Reports

mohan.sri — Tue, 23 Dec 2008 10:16:28 GMT

Hi I have installed DTS package compare and comparing two instances and it is looking good and i got the diffrences in it. but my question is the report is available in XML only and how can i find the diffrences in the report.

RE: SSIS Compare?

David Atkinson — Fri, 18 Jul 2008 10:32:32 GMT

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

SSIS Compare?

mglenn — Thu, 17 Jul 2008 23:23:42 GMT

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...

RE: Compare Options Missing?

dairec — Wed, 11 Jul 2007 13:58:23 GMT

Brian Donahue wrote:

Hi Daire,

Unfortunately the help for DTS Package Compare had never been completed, so the options are not going to be where the outdated help says they are.

If the goal of setting this option is to be able to filter out previous versions of the same package, DTS Package Compare 2.0 already has this functionality built-in. It is possible now to compare all versions of the packages to each other or even different versions of the same package.

Thanks Brian, I see all the options in the Filter tab now.

Daire

RE: Compare Options Missing?

Brian Donahue — Wed, 11 Jul 2007 13:41:36 GMT

Compare Options Missing?

dairec — Wed, 11 Jul 2007 10:29:28 GMT

Hi there.

I'm using DTS Compare 2.0 to compare two packages with different GUIDs.
According to the online help there is an Ignore GUIDs option in the Options menu. However, when I go to the Options menu I do not see this option or indeed, any other of the "Ignore..." options. I only see options for "Don't wait...", background comparing and saving passwords. In the Advanced Options I only see options for caching.
I notice the help seems to be for pre-version 2.0. Were these options removed in version 2.0?

The servers are SQL Server 2000.

Regards,
Daire

RE: Comparing DTS Packages in SQL server 2000 & SQL server 2005

Brian Donahue — Sat, 19 May 2007 17:57:31 GMT

Hello,

Sorry, I do not know of any utilities that do this. It may be difficult, because even though DTS is available to SQL Server 2005 as a 'legacy component', Microsoft have released SSIS as a replacement for DTS for SQL Server 2005. I also suspect that even the 'legacy' DTS for SQL Server 2005 is not entirely compatible with DTS Package Compare.

Sorry I can't be more helpful!

Comparing DTS Packages in SQL server 2000 & SQL server 2005

sukith — Thu, 17 May 2007 05:07:09 GMT

Hi all,

Im facing a situation where I need to compare DTS package in SQL server 2000 and SQL server 2005. According to the functionality offered by DTS Package compare 2.1, it doesnt support such functionality. It will allow only to compare packages in SQL server 2000 environment. Does any one of you know a tool which offers the above functionality ? If so please respond.

thanks.