I don't work a whole lot with table design, so excuse me if I sound dumb. I don't have one single column that can act as the PK. ...

Yea, that is why i don't know which index type I should be using for this example, clustered or non. If I just run a select statement on the...

Also, I am processing this TSQL in an execute SQL task (SSIS) and it is the first step in my sequence container.

When I tested without an index, it took longer to delete the records. I created an index with the column I have in my where clause, but its still...

For the Merge Join, if I am using inner join, will there be an option to redirect records that do not match? This is very important for me because...

Got it. thanks again.

Thanks for the information. I will test these options. Just out of curiosity, why do you say not to use the SORT transformation in SSIS?

Koen Verbeeck (5/6/2014)

---

The cache is still read into memory, so it won't reduce memory pressure.

A bit odd though you still get the out-of-memory error even after adding an extra 8GB.

There...

Koen Verbeeck (5/6/2014)

---

skaggs.andrew (5/6/2014)

---

This process is going to be used on a nightly basis. Not sure how I could use a raw file unless I had a process that...

Koen Verbeeck (5/6/2014)

---

skaggs.andrew (5/6/2014)

---

Thanks for the response DouglasH. The lookup is the destination table for this workflow. Not really sure how to redesign this mapping to use multiple...

This process is going to be used on a nightly basis. Not sure how I could use a raw file unless I had a process that created a new...

Thanks for the response DouglasH. The lookup is the destination table for this workflow. Not really sure how to redesign this mapping to use multiple lookups to achieve...

I just added 8 GB of RAM, reran my dataflow and it still error'd with the same message, so I guess the RAM is not the true issue. Any...

Thanks for the response. I tried this example and it works.

Thanks again.

Thanks all for the feedback. This is some great info for me to research and look into. Appreciate the help.