Import SSIS Package into SQL Server

There are several ways of doing it. ie. Save copy of package…

Or you can copy/paste the .dtsx onto the SQL server physical folder first and do the import.

1. Open SQL studio.

2. Connect –> Integration Services…

3. Stored Packages –> MSDB –> Import Packages…

4. Package location: File System

5. Once imported, Connect back to Database Engine…

6. SQL Server Agent –> Jobs –> New Jobs…

Add Parameters in SQL Jobs

Property Path:  \Package.variables[User::SiteName].Properties[Value]

Value: USA