DTS Package Execution [Resolved]

Posted by Bhupentiwari under Sql Server on 8/24/2016 | Points: 10 | Views : 193 | 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



Responses

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

Up
0
Down

Resolved
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.

Thanks,
A2H
My Blog

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

Login to post response