I recently completed a SSIS course.

One of the piece of best practice I came away with, was to ALWAYS use stored procedures in data flow tasks in SSIS.

I guess there is an argument around security, however the tutor said that as the stored procedures performed all of the work "native" on the SQL Server there was/is a significant performance boost.

Is there any truth to this or articles that debate the point?

Thanks

sql-server t-sql stored-procedures ssis
Edit
Report