muthuraman.sm
SSC Enthusiast
Points: 108
More actions
June 11, 2008 at 3:28 am
#71436
Hi ,
I want to run DTS package automatically on weekly basis to update a database. Can anyone help me out.
Neelakandan V-453229
Ten Centuries
Points: 1109
June 11, 2008 at 6:20 am
#827187
Create a job and schedule it. you need run the sql agent up and running..
Warm Regards, Neel aka Vijay.
george sibbald
SSC Guru
Points: 104210
June 12, 2008 at 3:28 am
#827717
right click on dts package and select 'schedule package'. this creates a sqlagent job which runs the package.
---------------------------------------------------------------------
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply