Monday, October 03, 2011

How to import packages using Integration Services

There are two different way to import ssis packages either command prompt or SSIS.
Here i am going show you , How to import ssis package via SSIS.

1. connect to SQL Server Integration Services
2. Expand Stored Packages
3. Expand the MSDB
4. Create Folder called My SSIS Packages
5. Import Packages
6. Package Location : File system
7. Package Path : C:\SSMS_Export_to_Excel.dtsx
8. Protection Leve : Rely on the server storage and role for access control

9. Package is imported now as you can see