Thursday, 23 July 2020

How to open SSIS package from SQL Server - Integration Services catalog


Open "Visual Studio" on your <ENTAD00110155> server (SSIS Server). 

Go to File --> New Project -->  select "Integration services" --> 

Select "Integration Services Import Project wizard" -->  Next --> 

Select "Integration Services catalog" --> Browse (Server name) --> 

Select <ENTAD00110155> server to connect --> OK --> 

Click browse (To select Package)  --> SSISDB--> Select Folder-->

Select DTSX  --> Next --> Import --> Close --> Go to View --> 

Solution explorer -->  Open "SQL_Restore.dtsx". 

Now you can see the SSIS package workflow and tasks!!

No comments:

Post a Comment