This is a good start on the subject:

Nesting Transactions

blehhhh (6/28/2013)

---

Hi,

I work in a system administrator type role, managing and supporting things like server 2008, local network, AD, exchange, patching, workstation etc.

I also have been doing ssrs reports over...

When you get SSMS (SQL Server Management Studio) started, you need to fill in the servername. The easiest way to do this is to just put a dot .

This means...

Very nice question. Thanks.

100% sure the source is pointing to the correct server?

Any package configurations?

ugh3012 (8/7/2013)

---

Koen Verbeeck (8/7/2013)

---

I don't know how big your tables are, but you can do this easily with a lookup component.

Read ID, fieldA and fieldB from ServerB into the data...

ugh3012 (8/7/2013)

---

Koen Verbeeck (8/7/2013)

---

Now, I need to use the list of IDs from the staging table to query a table in Server B and pull the results into the staging...

Is there anything in the package configured to redirect rows by error or truncation?

Now, I need to use the list of IDs from the staging table to query a table in Server B and pull the results into the staging table in Server...

Steve Jones - SSC Editor (8/7/2013)

---

Koen Verbeeck (8/7/2013)

---

BrainDonor (8/7/2013)

---

GilaMonster (8/6/2013)

---

Chad Crawford (8/6/2013)

---

They did a movie too[/url] - wasn't too good, but I thought it was worth watching because I...

SteveHood79 (8/7/2013)

---

I have my blog syndicated through SQL Server Central. The problem with blogging is that there's no feedback on if you're providing a useful service or if people...

Good to know, thanks for posting back.

sandy1234 (8/7/2013)

---

Thanks for the reply.

Finally solved the issue, The problem is with final destination table to which we are doing the inserts and updates.

There is a trigger on this...

Are you using any linked servers?

SQL Authentication or Windows Authentication?

John Mitchell-245523 (8/7/2013)

---

P Jones (8/7/2013)

---

I always read the email on my 2 x 1920px wide desktop monitors and since the layout change have given up reading from QOTD onwards as...