0x42657474657220746F2072656D61696E2073696C656E7420616E642062652074686F75676874206120666F6F6C207468616E20746F20737065616B206F757420616E642072656D6F766520616C6C20646F7562742E

😎

Most of the time cursors can be avoided but it's not a religion, there are tasks which do justify the use of cursors. Obviously if an operation can be achieved...

No worries, but do you have any sample data and table structure? Makes it easier to...

Please post proper DDL and enough data, the problem is straight forward from there.

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...