Admit up front this is a stretch.. But you might wrap it all in an EXEC ( ' ' ). I'm wondering if the compiler...

Syed Jahanzaib Bin hassan (4/27/2011)

---

that is the restriction of Standard Edition you can failover only 2 nodes if you want to failover more than 2 then you should for Enterprise...

MysteryJimbo (4/27/2011)

---

I'm a little puzzled as to why you would have a four node cluster and utilise only two of them? Wouldnt it make more sense to have two,...

At first glance I would say that insert performance is not your problem.

Simple math, 86,400 seconds in a day OR 86,400,000ms. Even if every insert took 100ms you could...

Excel is ok IF you are getting excel files. Your code has to handle other types as well, like pdf since you mentioned it earlier.

The simple answer...

Keep in mind when you say render you are implying a display of the data. The only portion of SQL that really qualifies is SSRS, and I don't think it...

I think you guys are expecting something from SQL that it doesn't provide. SQL just stores the data, in this case binary data. It doesn't know what that...

I agree, you don't need to know DTS intimately. The wizard does ok, but will usually no do a very good job with even a slightly complex package or one...

As it sits the pipeline(buffers) from one data-flow are not accessible from another, period, there is nothing that allows that.

With that said I think brian118 was on the right track.....

Are you running the app on the same server as the SSIS package runs? Also, what is your comparison methodology? Another thought is you probably have a connection...

I largely agree with Koen, however, for that method to work without issue you have to know that there will be no duplicates coming out of the source. If you...

If that is selected the table will be locked. Now depending on what you mean by threads it might be less relevant. If you are trying to do multiple bulk...

My first thought was that the discussion about a change in methodology might be premature. Have you looked at exactly where the package is taking longer than your test .net...

I have a few thoughts.. First this is a 2005 forum and you are talking about 2008, which is it? And do you have the correct version of BIDS...

Could you explain why you want to do it this way? I think it would be useful to understand.

CEWII