question

ChristopherJack-1763 avatar image
0 Votes"
ChristopherJack-1763 asked ZoeHui-MSFT commented

Couple of SSIS question on exporting ssis packages

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-transact-sqlsql-server-integration-services
image.png (39.9 KiB)
image.png (43.9 KiB)
image.png (226.5 KiB)
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 ZoeHui-MSFT commented

Hi @ChristopherJack-1763,

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

May I know how's the issue going 0n now?

0 Votes 0 ·
RyanAbbey-0701 avatar image
1 Vote"
RyanAbbey-0701 answered RyanAbbey-0701 commented

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

PS... take a copy of the entire solution before doing any changes... it can be quite finicky

0 Votes 0 ·