Deploy SSIS Package

Here is the steps to Deploy the package on MSDB database. [One process of deployment if number of package is less]

1. Login to Integration service.
2.Import the package.
3.Select File system.
4. Select The package path.
5.Select "Rely on server storage and roles for access control"
6.Press OK, if require give password

If you have parent and child package then need to deploy all the package in MSDB package store..

For create and schedule job : http://sqlserverinside.blogspot.in/2013/08/create-and-schedule-ssis-jobs.html
Share on Google Plus
    Blogger Comment
    Facebook Comment

0 comments:

Post a Comment