Paul White (9/9/2009)

---

Marios Philippopoulos (9/9/2009)

---

I have had the same problem in the past (on 32-bit environment).

I used the -g startup parameter (I specified it as -g384), and the problem...

I have had the same problem in the past (on 32-bit environment).

I used the -g startup parameter (I specified it as -g384), and the problem went away.

Elliott W (8/27/2009)

---

I think I have your answer:

http://www.simple-talk.com/sql/sql-server-2005/sql-server-2005-ssis-tuning-the-dataflow-task/

Use a SQL Select Statement to Retrieve Data From a View

Avoid using the Table or view access mode in the OLE DB Source...

No worries, I'd like to learn more about the internals...

The performance issue is fixed.

The package has gone from running for over 3 hrs to 10 seconds!!

The change you ask?

In the OLEDB Source of my data-flow component I...

Yes, we have a WHERE clause in the OPENQUERY SELECT.

Gkhadka (8/14/2009)

---

Marios, I think something is going wrong @ ur SSIS. I have a ssis package that loads over a 8 millions rows in less then 15 mins, to be...

Thanks for the suggestion, actually this is in...

Elliott W (8/14/2009)

---

That is shockingly bad performance. The other thought I had is what ELSE is going on on the source and destination servers at the same time, could...

I just noticed that I'm using the "Table or View" access mode in the OLEDB Source Adapter. According to this link this is very bad for performance:

http://www.simple-talk.com/sql/sql-server-2005/sql-server-2005-ssis-tuning-the-dataflow-task/

Use a SQL Select...

Elliott W (8/14/2009)

---

Three thoughts:

1. Is the destination table empty at the beginning of the load? I seem to remeber being told that this can prevent the fast load option...

Hey guys, good point on caching data locally at set intervals and using local queries during the day (as opposed to linked servers).

At this point of the discussion I have...

I'm not using ORACLE, but the link contained interesting info all the same.

This link looks interesting:

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/ce92ab37-b051-4f9e-9072-9fce685c83c0

Elliott W (8/12/2009)

---

I don't know of any tools, but the first problem is figuring out what is using linked servers, you can do a search of the syscomments using the...