Post reply

Which memory is SSIS using

  • January 5, 2015 at 11:26 am

    #293443

    I have 3 servers. One is where the source data resides, another is where the job and ssis package is on, and the third is the destination server. I'm thinking the memory used by ssis is the memory of the server with the package and ssis package. Am I correct on this?

  • January 5, 2015 at 3:12 pm

    #1767892

    Yes and no.

    Memory for transformations comes from the SSIS server, but you'll use some resources from the other servers to read and write. If you have complex queries, that would use resources from the the source server.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply