J0shu@ (1/16/2015)
Hey Nevyn,A higher level question with regards to implementation strategy. When implementing a SSIS package, should the priority of process be put on the SSIS side as much as possible vs. the SQL side? Or when do you determine the direct DB should handle this vs. SSIS?
Well, I would say that certain things should generally be avoided in SSIS:
1) Anything that blocks the data pipeline
This includes (in-SSIS) aggregation and sorting.
Better idea: use the database engine for such things.
2) Anything that drastically slows the pipeline
The OLEDBCommand component in the data flow comes immediately to mind, with its RBAR implementation.
Better idea: fire the rows to a staging area and run a set-based process after the data flow has completed.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.