KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
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
Tags (comma-separated)
Save Edits
Cancel