Need Help Scheduling A .DTSX Package on SQL Server 2005

Posted on 2008-01-28
Medium Priority
Last Modified: 2012-08-13
Need steps to Schedule .DTSX Package on SQL Server 2005
Question by:tomasdlv

Expert Comment

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

Author Comment

ID: 20761841
what is a deployment package?
LVL 18

Accepted Solution

brejk earned 2000 total points
ID: 20761895
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.

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question