?
Solved

SSIS Package and SQL Job how to script it

Posted on 2014-08-14
6
Medium Priority
?
120 Views
Last Modified: 2016-02-11
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.
0
Comment
Question by:sbornstein2
  • 4
  • 2
6 Comments
 
LVL 18

Accepted Solution

by:
Jerry Miller earned 2000 total points
ID: 40261537
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
 

Author Comment

by:sbornstein2
ID: 40261544
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
 
LVL 18

Expert Comment

by:Jerry Miller
ID: 40261548
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 18

Expert Comment

by:Jerry Miller
ID: 40261558
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
 

Author Comment

by:sbornstein2
ID: 40261569
I thought there was a way to script out the agent job though and also apply the dtsx file or something.
0
 
LVL 18

Expert Comment

by:Jerry Miller
ID: 40263486
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

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

862 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