1. Create a SSIS solution.
2. Build SSIS package.
3. Set SSIS project properties/Deployment Utility/CreateDeploymentUtility to True.
4. Go to SSIS(s)/包配置. Set the package’s configuration. This is optional.
5. Rebuild the project.
6. Under bin/deployment folder, click ***. SSISDeploymentManifest file to deploy the package. You can choose the SQL Server as destination.
7. In SQLSERVER, create a new job and the steps. And the job step type you should select SQL Server Integration Service包.
8. After all these you can start the job and it will work.
2. Build SSIS package.
3. Set SSIS project properties/Deployment Utility/CreateDeploymentUtility to True.
4. Go to SSIS(s)/包配置. Set the package’s configuration. This is optional.
5. Rebuild the project.
6. Under bin/deployment folder, click ***. SSISDeploymentManifest file to deploy the package. You can choose the SQL Server as destination.
7. In SQLSERVER, create a new job and the steps. And the job step type you should select SQL Server Integration Service包.
8. After all these you can start the job and it will work.