Schedule job in ssis

Question

Post reply

Schedule job in ssis

rui_fro

SSC-Addicted

Points: 467
More actions
April 24, 2008 at 3:56 am

#189804

Hi there!
I made a ssis package and it's running great! I wanna know how do i schedule a job. Is it in VS or in SQL Server? i want it to run at the end of each month.
Thanks for any help (Obrigado)!!

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Will Riley Ten Centuries Points: 1030 More actions · Answer 1

You can use SQL Agent for this

Go to the Agent running on the relevant server where your SSIS packages are stored and select New Job

Under the job steps, you add a step of type: SQL Server Integration Services Package

There you can choose if the package source is SQL Server or File System

Once you have set the Job Steps up, you then add a schedule for your package where you can choose the relevant frequency.

Kind Regards, Will

wissemhabboub Mr or Mrs. 500 Points: 558 More actions · Answer 2

Hi

- First you can deploy package in SQL server DB or in DTS directory or let it in file systeme .

- You can find SQL Server Agent in SQL server management studio.

- Startup SQL server Agent if it is not started,

- Add new job, in Steps onglet add step, and choose integration services package.

- select your package (with dtsx extension).

- You can parameter your package (change connection, variables values,...) then click OK.

- now, you can schedule your package with onglet schedule of your job.

and that's all.

you can view the log of your job at general onglet of your job

😀

wissem habboub

MCTS Business intelligence - itAlgeria

http://wissemhabboub.unblog.fr

rui_fro SSC-Addicted Points: 467 More actions · Answer 3

rui_fro

SSC-Addicted

Points: 467

April 28, 2008 at 5:08 am

#807677

thanks!

it works great!!

😉

Analyst Ten Centuries Points: 1063 More actions · Answer 4

Hi

Whats the difference between Sql Agent Services Account or by Using the proxy?

Is it mandatory to create a proxy to execute the package in a job?

Please let me know the difference...

Thanks,

Janani

rui_fro SSC-Addicted Points: 467 More actions · Answer 5

Hi! I think it's not necessary a proxy. In order to run a dts package, you just need to put the dts file in :

(for example "C:\Program Files\Microsoft SQL Server\90\DTS\Packages")

Then, in the SQL Server Management Studio, connect to Integration Services in your local server. Under stored packages, under file system, right click and select import package.

Package Location = File System

Path = "C:\Program Files\Microsoft SQL Server\90\DTS\Packages"

To run it, right click the package and "Run Package".

Analyst Ten Centuries Points: 1063 More actions · Answer 6

Hi,

This is to run SSIS packages. Is it mandatory to use the proxy for executing the package(scheduled) in the job?

Thanks

Toby White SSCertifiable Points: 6187 More actions · Answer 7

It is not mandatory to use a proxy. One security hoop a proxy can get you through is when the package does work on another server. Suppose the package resides on server1 and it pulls data from server2 to server1. If the package is scheduled in the agent then it will run under the security context of the service the agent us running under, or the proxy. In many cases the service the agent is running under has no permissions on the other server - server2. If you use a proxy then you can grant that proxy the necessary permissions (minimum) on server2 to accomplish the job - in this case probably data reader in the target database would suffice.

Regards