SSIS Package and SQL Job how to script it

Hello all,

I have a SSIS package that I will have in a migration directory where my migration script will run.   How do I set this into the SQL Server and then schedule it for say 12AM daily as an example.
sbornstein2Asked:
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.

Jerry MillerCommented:
Here is one way for you to put your packages on the SQL server:

http://msdn.microsoft.com/en-us/library/ms141772(v=sql.105).aspx

I use the deployment utility because I don't have direct access to the SQL server file system:
http://technet.microsoft.com/en-us/library/ms141693(v=sql.105).aspx

Use the SQL Server Agent to schedule the jobs:

http://msdn.microsoft.com/en-us/library/ms189237(v=sql.105).aspx
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
sbornstein2Author Commented:
I should have been more clear I want to add this to a SQL script.  I don't want to do anything manual if possible and allow the script to do both these things.
0
Jerry MillerCommented:
That is where the SQL Agent comes in. If you already have the package on the server, you create a job to run, schedule it at your time, and choose the SSIS package to run.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Jerry MillerCommented:
I have a lot of jobs that run throughout the day across multiple systems and databases. The SQL Agent is a great way to automate tasks.

I am not familiar with way to get a script to run on a schedule other than the agent.
0
sbornstein2Author Commented:
I thought there was a way to script out the agent job though and also apply the dtsx file or something.
0
Jerry MillerCommented:
I am not familiar with running the agent job from a script. How are you going to schedule the script without using the agent?

You can always use the request attention link and see if some others can answer your questions. A lot of experts don't review questions once someone is involved in answering the question.
0
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.

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.