Hard to tell what is wrong without inspecting the code, can you share it?

Do you have any event handlers configured in the package, sometimes those are overlooked?

Luis Cazares (3/31/2014)

---

Eirikur Eiriksson (3/31/2014)

---

Luis Cazares (3/31/2014)

---

Here are 2 other options.

WITH Contacts AS(

SELECT INS.INSPNO, CNT.FIRSTNAME, CNT.LASTNAME, CNT.CAPACITY,

ROW_NUMBER() OVER( PARTITION BY INS.INSPNO ORDER BY CASE WHEN Capacity = 'Contractor' THEN -1...

dmbaker (3/31/2014)

---

I'm not saying that you should debug the code, I'm saying that you should *insist* that the developers give you the queries being executed when a timeout occurs. Is...

david.ostrander (3/31/2014)

---

Hello -

My SQL Server Agent shows successful completion of SSIS job but messages in Log File view shows that there was an error. How can I get the...

If you have no sequence or date/time to go by, then unfortunately you have to grab all the source records for comparison. With these sizes, which sound manageable, my suggestion...

qifai3zoi3ziq (3/31/2014)

---

Eirikur Eiriksson (3/31/2014)

---

If I am getting this right: A unique key should be a natural key, not a surrogate key, which means comparing all columns making up the key....

I agree, start with the earliest version...

You can use tools like WireShark[/url], nmap[/url] or other similar to do some diagnostics, I often use BackTrack[/url] to analyze this kind of problems.

Back in the days of SQL 7/2000...

Sounds like a good option, have used this in similar situations before with good results.

qifai3zoi3ziq (3/31/2014)

---

Hi, I need to do incremental loading from a source (a linked server in my db) to a destination which is local db.

I am planning on doing ssis package...

Hope you don't mind but here is my suggestion; check all the possible bottlenecks and possible points of failure, this may not even be a db issue. It only takes...

Jeff Moden (3/31/2014)

---

While some of the methods posted are ok, there's still the fundamental problem...

... of not knowing what...

Luis Cazares (3/31/2014)

---

Here are 2 other options.

WITH Contacts AS(

SELECT INS.INSPNO, CNT.FIRSTNAME, CNT.LASTNAME, CNT.CAPACITY,

ROW_NUMBER() OVER( PARTITION BY INS.INSPNO ORDER BY CASE WHEN Capacity = 'Contractor' THEN -1 ELSE INS.INSPNO END DESC)...

One way of simplifying this is to use the NCHAR() function;

EXEC ( ' Select CHARINDEX(NCHAR(41), @Ref) ')