March 16, 2011 at 2:20 pm
Hello All - Quick question on how SSIS utilizes resources. Here my scenario:
I have a SQL 2005 Database server we'll call Server A
I have an SSIS package developed in VS2008 that does the following:
1.) Gathers rows from a table in Server A that references files to be processed
2.) For each row, gathers like files from a file share
3.) Each file in the set is processed and imported into tables on Server A
4.) Processed files are archived to another share on Server A
I have a second SQL Server 2008 server we'll call server B.
Server B contains the SSIS package and configuration file shares
Server B contains a job to run the SSIS package.
Question: Since the job is running on Server B how much work if any is moving across the network? I am guessing since the files to be processed are on Server A, that data is moving across. I have a very similar project coming up that will involve much larger files. Any thoughts?
March 16, 2011 at 2:27 pm
If the files are on ServerA, they will move across the network to ServerB to be consumed into memory and then data pumped back across the network to insert necessary records into the table on ServerA.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply