Does the client take a performance hit when running SSIS packages?

Last Post 16 Jun 2009 04:38 AM by DBADave. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
DBADave
New Member
New Member

--
15 Jun 2009 10:01 AM
When executing DTS packages from a client PC or application server, the package utilized the hardware resources on the client to execute the package. Is this true with SSIS and if so, to what extent are the resources (CPU, disk, memory) used?

Thanks, Dave
DBADave
New Member
New Member

--
16 Jun 2009 04:38 AM
I would imagine if the package is only running stored procedures then the bulk of the work is done on the database server. Correct?

But if the package is also performing file managment (extracts, ext.) then I suspect that type of work uses the client's resources. Correct?

What about transformations? Is this work handled primarily by the client?

If the package contains dynamic SQL is this load handled primarily by SQL Server or the client?

Thanks


Acceptable Use Policy
---