SSIS Compare?

mglennmglenn Posts: 25
edited March 17, 2011 9:55PM in DTS Package Compare 2
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...
· Share on Twitter

Comments

  • David AtkinsonDavid Atkinson Posts: 1,462 Rose Gold 2
    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
    Product Manager
    Redgate Software
    · Share on Twitter
  • woodmarkwoodmark Posts: 4
    Any plans for incorporating dependency checking into SSIS packages?
    · Share on Twitter
  • David AtkinsonDavid Atkinson Posts: 1,462 Rose Gold 2
    Hi,

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

    David
    David Atkinson
    Product Manager
    Redgate Software
    · Share on Twitter
  • woodmarkwoodmark Posts: 4
    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.
    · Share on Twitter
  • David AtkinsonDavid Atkinson Posts: 1,462 Rose Gold 2
    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
    Product Manager
    Redgate Software
    · Share on Twitter
  • austrianfoodispukeaustrianfoodispuke Posts: 100
    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
    · Share on Twitter
  • David AtkinsonDavid Atkinson Posts: 1,462 Rose Gold 2
    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
    Product Manager
    Redgate Software
    · Share on Twitter
Sign In or Register to comment.