Scheduling an SSIS Package is an easy job for a DBA.
1. Select New Job from the pop-up menu. (SQL Server Agent --> Jobs --> New Job)
2. Specify a new for the New Job in the General page. Click on New on the Step page, specify the step name, Select SQL Server Integration services in the Type combo box, Select the File System as Package Source and Select package from the path where the package is stored.
3. Click on the Datasource tab, there we could see all the datasources which we specified in the SSIS package. Check mark on those Datasources and verify those attributes specified in the connection string.
4. There is one more interesting option, we can write the log files into files (Check the logging tab)
after filling all these click OK.
5. To create a schedule for this job go to schedule page and create a Schedule as per our requirement.
I hope this blog will help you to create a scheduled Job For SSIS packages. Please let me know if you have any questions
1 comment:
Interesting to know.
Post a Comment