Reputation:
Is there way to export SSIS project from Integration services catalog to visual studio ? any information will be appreciated .
Upvotes: 0
Views: 6571
Reputation: 4477
In SSMS, from the Integration Services Node, navigate down to the project that you want to export. Right click and select export, this will create an ispac file.
Then follow these instructions to import your project into Visual Studio using the Integration Services project import wizard: https://msdn.microsoft.com/en-us/library/hh270294.aspx?f=255&MSPPError=-2147217396
Upvotes: 1