Tuesday, February 21, 2012

schedule

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

First advice: USe the search functionality of the forum.

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

|||

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?

|||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?|||

Open your SQL Server 2005...

Goto to SQL Server Agent and add new JOB..

Go to the tab schedules!!

Helped?

Regards!!

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

Dear Friend,

Where is your SSIS package?!

regards!

|||

As I explained before, it is on the network.

Thanks

|||

Could you map the physical path to the package?!

Regards

|||

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.

|||

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!

|||Ok, thanks|||

It's a pleasure!

regards!!

No comments:

Post a Comment