Why we create SSIS packages eventhough we can accomplish the same requirement in a SP or in sql statement
What is the use of creating a SSIS package? We are calling a procedure or sql statement inside a
package.So, why don't we use a procedure directly instead of creating a package..Even in sql server agent jobs also we can use procedures instead of packages.If its because of security purpose,we can restrict it in the login level.. Somebody please answer this!!
SSIS Packages is not only to execute Stored procedures or script from database. There are lot of other tasks and functionality for which SSIS is. Please go through the SSIS features and functionality, you will get your answer by own.
If you are only executing a stored procedure and not using any other functionality inherent to SSIS of any kind, you're right. You shouldn't be using SSIS. SSIS has it's own overhead that's going to slow down the execution of this procedure, if the only thing going on is the execution of the procedure.