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.
5548
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
