We help IT Professionals succeed at work.

Need Help Scheduling A .DTSX Package on SQL Server 2005

Need steps to Schedule .DTSX Package on SQL Server 2005
Comment
Watch Question

Hi,
 First you should make deployment package of your SSIS package.
Once the package is Deplloyed the  Package can be schedued as a JOB.

Author

Commented:
what is a deployment package?
Commented:
0. If you need to run the package under specific Windows context, create a proxy.
a) In Management Studio connect to database engine with Object Explorer window.
b) In Object Explorer window go to Security, right-click on Credentials and choose New Credential...
c) Choose the proper Windows account and provide a password for this account to create a credential.
d) In Object Explorer go to SQL Server Agent, right-click on Proxies and choose New Proxy...
e) Check the SQL Server Integration Services Package subsystem on the subsystem list.
f) Choose the proper credential (created in 0b-c) add principals that will be allowed to use the proxy.

1. Create a job
a) In Management Studio connect to database engine with Object Explorer window.
b) In Object Explorer go to SQL Server Agent, right click on Jobs and choose New Job...
c) In the General tab provide a name for the job and choose the owner (the one who can use a proxy if you are going to use one).
d) In the Steps tab click New... to create a job step.
e) In New Job Step provide a name for the step, choose SQL Server Integration Services Package as a type.
f) Choose your proxy (or leave it empty if you want to run the step as the job owner) account in Run as drop-down list.
g) Specify package and configure its options such as logging or variable values. Click OK.
h) In the Schedules tab click New... and choose the proper interval. Save the schedule under some meaningful name for future reuse. Click OK to close the New Job Schedule window, and once more OK to save the job.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.