Couple of SSIS question on exporting ssis packages

Christopher Jack 1,616 Reputation points
2021-07-22T12:09:58.787+00:00

Hi,

A couple of questions...

1) If I select the a different version of the ssis package

117132-image.png

As the current one, when I go to export that file using the import package in visual studio, will it pick the selected package and if not how do I export that specific package?

2)

If I rename the project and solution in the VS it doesn't seem to rename the folder? How can I rename the folder to match the renamed solution and package

117113-image.png
117097-image.png

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,587 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,650 questions
0 comments No comments
{count} votes

Accepted answer
  1. ZoeHui-MSFT 37,221 Reputation points
    2021-07-23T02:20:25.34+00:00

    Hi @Christopher Jack ,

    1)After clicking the Restore to Selected Version button, you’ll be prompted to confirm the operation. If you select Yes to confirm, the prior version selected now becomes the current version.

    Details please refer: https://www.timmitchell.net/post/2016/11/11/ssis-catalog-project-versioning/

    2)Try with below steps:

    1.Take a backup of the entire solution (ie, copy in Explorer)
    2. Move the files around / perform the renames in Explorer
    3. Open the solution and project files in Notepad++ and fix the references there to point to the new locations and folder names
    4. Open the solution in VS to see whether your changes worked

    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


1 additional answer

Sort by: Most helpful
  1. Ryan Abbey 1,181 Reputation points
    2021-07-22T20:22:02.377+00:00

    For question 1, it seems like a try it and see

    q2, If I remember correctly, open up the .sln file in a text editor and change the references... don't forget to change the folder name too

    1 person found this answer helpful.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.