Need Help Scheduling A .DTSX Package on SQL Server 2005

Need steps to Schedule .DTSX Package on SQL Server 2005
tomasdlvAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mikkilineniCommented:
Hi,
 First you should make deployment package of your SSIS package.
Once the package is Deplloyed the  Package can be schedued as a JOB.
0
tomasdlvAuthor Commented:
what is a deployment package?
0
brejkCommented:
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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.