Roy Ernest (10/8/2009)

---

This does not look like the transaction log is full. It seems like the your Data file is full. Did you run out of Hard disk space or...

Truncating will delete all the records. We can't delete every record. The delete statement has a where clause.

John Rowan (9/22/2009)

---

You'll need to be careful with #1. SSIS is very metadata dependant and a stored procedure that returns a different result set based on parameter values can...

John Rowan (9/22/2009)

---

Elliott W (9/22/2009)

---

Ok, here is a really quick and dirty POC. How many Dataflows run depends on the variable "ExecutionThreadCount", it can be up to 5. ...

Elliott W (9/22/2009)

---

Ok, here is a really quick and dirty POC. How many Dataflows run depends on the variable "ExecutionThreadCount", it can be up to 5. I even...

Elliott W (9/22/2009)

---

John Rowan (9/22/2009)

---

I'm with you Elliot. Yes, you can thread multiple pumps inside a single data flow. Memory becomes the limiting factor. I typically use...

Also to add, this process would be running on a pretty beefy server (I think if I remember some of the specs correctly, it'll have atleast 250GB RAM and 4...

Hi Elliott W,

I think your concept is close to what I'm looking to do. But the key pieces of the project are that I won't necessarily know is the...

Ok thanks, I'll try that. How about reading a variable from an executable?

Thanks,

Strick

That's one of the things I never liked about excel (the fact that it changes data types). Which is why excel can be bad for creating extracts. Not...

Hello,

I think from a performance perspective, the one that has the most resources (processers, memory, etc.) will perform better. So if the server that the sp resides on has...

Found the issue guys. Needed SET NOCOUNT ON in the sp.

Thanks for your help.

Strick

What control flow task are you using?

I was going to suggest the same that Phil did. Although my suggestion would be to use a script component as a source instead of a script task. ...

Great thanks!

Strick