DTS Package Execution [Resolved]

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

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

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

Latest Posts