DTS Package Execution [Resolved]

Posted by Bhupentiwari under Sql Server on 8/24/2016 | Points: 10 | Views : 161 | Status : [Member] | Replies : 1
Hello Guys

I have one DTS package , executing using windows services.

Now i am thinking to execute using sql server jobs would be any difference in terms performance

Thanks n Regards
Bhupendra Tiwari


Posted by: A2H on: 8/24/2016 [Member] [MVP] Bronze | Points: 50


IMO SQL Jobs and Window Services are options to trigger the execution of ssis package at regular intervals. These does not have any performance impact as such.

Having said this I find it easier to manage SQL job as the deployment and other maintainability activities are easier on SQL jobs than window services.

Please mark my reply as answer if it helps to resolve your problem

Bhupentiwari, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response