What's the difference between tsql and excite sql task

Question

II have a table with some data, i can select the data i need with tsql. With ssis excute sql task, i could also do that. So what's the difference? Which one is more useful or advice....

Answer 1

Hi @Jefferson

As far as I know, it makes no difference. Excute SQL task is to apply the execution result in SSIS.

If your requirement is just to get data and view output in the SQL database, then use tsql will be fine.

If you want to output the results to a local folder or other places, then SSIS is better.

Best regards,

Cosmog Hong

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Execute SQL Task simply runs a T-SQL batch.

If you want to use the data in your SSIS package, you could use Execute SQL Task. Same goes if it is an update operation that is part of a larger plot which you have in an SSIS package.

But if you just want to run a plain query, or a plain update, there is no need to use SSIS.