How to import SSIS Project from SSIS Server using Integration Services Import Project Wizard option in Visual Studio

In this article, we will see how to import SSIS Project from SSIS Server using the Integration Services Import Project Wizard option in Visual Studio.

Basically, rather than Importing from Server, first, try to export ispac file via SSMS to a local disk and then use the Import Wizard option to read the local deployment file in Visual Studio.

Here are the Steps:

1. Open SSMS > Connect to SQL Server where SSISDB is located
2. Expand your SSIS Project. Right-click on Project Node and click Export
   
   
    
3. This will save as ispac file (SSIS Deployment File)
4. Now go to Visual Studio (i.e. SSDT).
5. Click NEW > Project >Integration Services Import Project Wizard option 
   
    
6. On the second screen select the Import Project Deployment File option if it's not default
   
   
    
7. Choose the file we exported in the previous step.
8. Click Import to finish the wizard
9. After Import Process make sure to change TargetServerVersion

NOTE: Some users have reported issues with the SSIS Import Wizard in Visual Studio 22 or 26 (SSIS Designer Extension 2.0 or higher). If the imported package becomes corrupt, try the following workaround to see if it helps.

• Downgrade the SSIS Designer Extension to a version lower than 2.0 to see if it helps.
• Try reinstalling SSIS PowerPack > Choose Custom Install > Select all SSIS runtimes (x86/x64) and install the full product to see if it helps. 

We hope this method helps you out.

Contact Us

If you have more question(s) feel free to contact us via Live chat or email at [e-mail]

https://zappysys.com/support/