arkiboys


How is it possible to schedule a SSIS package to run at a certain time please


Re: schedule

Rafael Salas


First advice: USe the search functionality of the forum.

Second: you can use SQL SERVER AGENT that ships with SQL server 2005.







Re: schedule

arkiboys

Can not find anything regarding my question

Can you guide me through setting up a schedule of a ssis package or point me to a site that does just that please






Re: schedule

arkiboys

While going through the scheduling a task in SSMS, there does not seem to be an option to point to the ssis package on the network. How do I point to this package please



Re: schedule

PedroCGD

Open your SQL Server 2005...

Goto to SQL Server Agent and add new JOB..

Go to the tab schedules!!

Helped

Regards!!






Re: schedule

arkiboys

Done that but do not see a browse functionality in there to point to the ssis package on the network.



Re: schedule

PedroCGD

Dear Friend,

Where is your SSIS package !

regards!






Re: schedule

arkiboys

As I explained before, it is on the network.

Thanks





Re: schedule

PedroCGD

Could you map the physical path to the package !

Regards






Re: schedule

arkiboys

Hi,

I have explained all these in the previous posts.

Do you see an option to browse or place the path of the ssis packages because I don't.





Re: schedule

PedroCGD

Yes...

You can browser your package to the file system!

Check the image I made for you in my blog:

http://pedrocgd.blogspot.com/2007/07/ssis-msdn-arkiboys-doubt.html

Helped

Regards!






Re: schedule

arkiboys

Ok, thanks



Re: schedule

PedroCGD

It's a pleasure!

regards!!