Share via

Integration Services Import Project Wizard - Missing

  • Article

Question

Tuesday, March 13, 2018 3:21 PM

On SQL Server 2012 SSDT, the template  “Integration Services Import Project Wizard” is missing. How do I add it so I can import SSISDB ispac file?

All replies (3)

Tuesday, March 13, 2018 4:01 PM

Did you see "Business Intelligence"? If not, you need to install SSDT.

A Fan of SSIS, SSRS and SSAS

Tuesday, March 13, 2018 4:53 PM

Yes I see Business Intelligence and 5 templates but not the Import one.

I found a way to import the packages. Change the export file suffix ispac to Zip and extract the files. Then I can add them to a SSIS Solution, one package file at a time.

Thank You

Tuesday, March 13, 2018 5:05 PM

Yes I see Business Intelligence and 5 templates but not the Import one.

I found a way to import the packages. Change the export file suffix ispac to Zip and extract the files. Then I can add them to a SSIS Solution, one package file at a time.

Thank You

I've written about it here

https://social.technet.microsoft.com/wiki/contents/articles/25913.import-a-ssis-project-from-catalog-using-t-sql-script.aspx

Please Mark This As Answer if it solved your issue
Please Vote This As Helpful if it helps to solve your issue
Visakh

My Wiki User Page
My MSDN Page
My Personal Blog
My Facebook Page