antonio.estima 4150 (9/25/2012)

---

Now, the filter "where SUBSTRING (nomeint, 1,1) = 'P' ", which is in subquery is precisely to bring unit not equals "PA" and thus does not occur conversion...

Sam.... (9/25/2012)

---

hi,

I have a requirement in which i have to restart the package where it fails. I initially thought to use check points but that is not possible because i...

Get your DBA to look at the filenames in the production pathing. Most likely one of them has an invalid naming convention that you're picking up and trying to...

rburko (9/25/2012)

---

Just for chuckles, I changed my initial selection criteria so that only 100 rows get selected, instead of 1,000 or so rows, ending up in the ADO recordset...

PiMané (9/25/2012)

---

The webservice writes directly on the Users' table and the trigger on the SyncEntities' table, with a FOR UPDATE, INSERT.

Is the FOR UPDATE, INSERT executed in the same transaction...

Smash125 (9/21/2012)

---

Its been while have not given any interview SSIS.Just preparing my future course of action

One common questions that comes to my mind is

Explain SSIS architecture? My answer may...

When performing an upgrade, one of the general ideas that underlies doing so is that you'll have to upgrade all the internal components to the new design. Now, I...

George is pretty much dead on the money, but a comment about multiple partitions in the primary.

The only time I would recommend using partitions without multiple file groups is for...

sathiyan00 (9/24/2012)

---

Hi all,

i have to move invalid records(data type mismatch) from excel into error log and have to process only valid records.

But...

capnhector (9/21/2012)

---

bitbucket-25253 (9/21/2012)

---

SQLRNNR

Targeting Joe and baiting him really needs to stop. And the same can be said of anybody else that has been personally attacked or been the recipient of...

I may just be old school, but I can't STAND not having an integrated development environment amongst all the developers. I guess the idea is that your database needs...

PiMané (9/21/2012)

---

Aren't FKs faster to check than the IF SELECT .. ? If we name our FKs we can catch the specific error on code and display a more user-friendly...

JanTimmermans (9/21/2012)

---

But I'm still curious how you'd rewrite the procedure without using an cursor 🙂

What we do:

Select ID, Adress, Zipcode

From aTable

Open Cursor

Fetch Next into variables

Do while eof

...

Crusty, where are you...

SomewhereSomehow (9/20/2012)

---

You are to optimistic to evaluate. I think our country has left behind 50 years....