How can I view a Data Flow task without checking out the package?

Question

I have an SSIS package under source control and I need to review a previous version to identify a problem.

However I cannot open a data flow task unless the package is checked out - which results in the latest version rather than the previous version being accessed.

Is there a view the data flow task without a check-out occurring? I've set the option to prompt before check-out but if I cancel the check-out, the data flow task doesn't open.

Any ideas?

Answer 1

Workaround:

1. Get historic version to be viewed
2. Save local copy to temporary file
3. Check-out item for editing
4. Overwrite local copy with version obtained at step 2
5. Review package in Visual Studio
6. "Undo pending changes" to revert the package to its latest version unchanged

Seems like a there should be n easier way

Answer 2

Hi @Peter Bishop ,

Not sure if this could be helpful.

You may take a carefully reference, hope it could give you some ideas.

https://adatis.co.uk/stop-automatic-checkout-of-ssis-packages-in-visual-studio/

If it doesn't work, I think you may use your workaround temporarily.

Regards，

Zoe

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October