To execute SSIS packages, Need to follow one of the below mentioned approaches.
Approach 1:
F5 from the Microsoft visual studio
Approach 2:
1. Open Solution explorer in Microsoft visual studio
2. Right click on package.dtsx
3. “Execute Package”
Approach 3:
1. Type “cmd” in Run
2. Paste package path with as mentioned below and click on enter
>DTEXEC /File “D:\Ramkoti\SSIS\BuildingAndExecutingPackage\ BuildingAndExecutingPackage\Package.dtsx
Approach 4:
- Type “DTEXECUI.EXE” in Run
- That will open “Execute Package Utility”
- Select Package source as “File System” and select Package path
- And click on Execute.
Approach 5:
SQL Server Agent Scheduling
By creating SQL Server job with following parameters.
- Type as “SQL Server Integration Services Package”
- Run as “SQL Server Agent Service Account”
- Package source as “File System”
- Package path