question

PeterBishop-3345 avatar image
0 Votes"
PeterBishop-3345 asked ZoeHui-MSFT answered

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

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?

sql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

PeterBishop-3345 avatar image
0 Votes"
PeterBishop-3345 answered

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



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered

Hi @PeterBishop-3345,

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.