An Execute Process Task could work as well. I have done similar things by building my command line arguments dynamically in a variable using an Expression and then mapping the...

Tatsu (8/1/2012)

---

I did an in place upgrade from 2008 R2 to 2012 and got the same thing, two instances of SSIS running side-by-side. This appears to be by-design and actually...

The EAV model is an anti-pattern when attempts are made to apply it as a 'more flexible' replacement to a proper relational design. There are certainly places where it shines,...

It's a least common denominator approach. If SSMS were coded to account for every permutation possible to arrive at the most efficient way to add a column think about the...

SQLRNNR (8/1/2012)

---

L' Eomot Inversé (8/1/2012)

---

EL Jerry (8/1/2012)

---

Revenant (8/1/2012)

---

crookj (8/1/2012)

---

L' Eomot Inversé (8/1/2012)

---

Cliff Jones (8/1/2012)

---

L' Eomot Inversé (8/1/2012)

---

bcsims 90437 (8/1/2012)

---

SQLRNNR (8/1/2012)

---

Cliff Jones (8/1/2012)

---

JAZZ Master (8/1/2012)

---

L' Eomot Inversé (8/1/2012)

---

Daniel Bowlin (8/1/2012)

---

ChrisM@Work (8/1/2012)

---

opc.three...

Giving Permissions through Stored Procedures by Erland Sommarskog

Look for sentence beginning with "As you might guess."

It is a critical point, and is the crux of what is...

SQLSACT (7/31/2012)

---

pooyan_pdm (7/31/2012)

---

To increase the performance of DELETE operation the records are not deleted immediately, instead they are marked as ghosted . A background process called ghost cleanup task...

Related post:

http://www.sqlservercentral.com/Forums/Topic1337190-147-1.aspx

Time to do some homework.

Documentation: Conditional Split Transformation - SQL Server 2005

And here is a visual example of Conditional Split:

Handling NULL Values in SSIS Using The Conditional Split Transformation

Don't forget to remove any log shipping work done to this point:

How to: Remove a Secondary Database (Transact-SQL) - SQL Server 2005

Fantastic! You might be surprised how many database development shops do not 'have it' and do not 'get it' as to why it is critical....

sys.objects - SQL Server 2008 R2

object_id is a column in the sys.objects catalog view and uniquely identifies an object in the current database. In other words the object_id for a...

sriharsha2410 (8/1/2012)

---

Im using SQL Server 2012 and I have a case where I have to delete sql jobs. I found two approaches which are as follows:

Approach 1

DECLARE @jobId binary(16)

WHILE...

I think the relevant points in the question are that the transaction was committed on the primary and the log was successfully sent to the mirror prior to the crash....