karen.blake (1/4/2016)

---

I have put this here as I am still learning about SSIS and have assumed I can do this using this.

So, there is a table where we need to...

Eirikur's response rendered what I was going to write mostly redundant. But I do have some minor points:

1) If you 'obfuscate' something, you make it unclear or difficult to interpret....

Eric M Russell (12/30/2015)

---

Orlando Colamatteo (12/30/2015)

---

Assuming the identity seeds were both 1, loading with IDENTITY_INSERT ON using the original identity *-1 (what Phil said) is where I would start the...

titsiros (12/30/2015)

---

Hi Phil, thanks for the -1 tip, that would work also..Do you know of any tool that would do this instead of scripting this manually? I looked into Redgate...

If a CASE statement is returning an item from a list...

dndaughtery (12/30/2015)

---

I used a select...into to create a staging table. Its been fine but lastnight I got a truncation error. I was under the "Assumption" that sql server looked at...

Certainly did. And invented a new noun, the "scree-shot" 😛

Eric M Russell (12/28/2015)

---

I'm assuming the scenario is that you have two clients in separate SQL Server instances, each having overlapping sequential integer identifiers, and so you need to assign...

drew.allen (12/29/2015)

---

Your client may be limiting the number of characters returned. It may limit either the total returned or the amount returned per column. For instance, SSMS limits...

Eirikur Eiriksson (12/29/2015)

---

Phil Parkin (12/29/2015)

---

Eirikur Eiriksson (12/29/2015)

---

Phil Parkin (12/29/2015)

---

Grant Fritchey (12/29/2015)

---

Eirikur Eiriksson (12/29/2015)

---

I really appreciate the effort of those who write the articles posted on this site but sometimes the...

Eirikur Eiriksson (12/29/2015)

---

Phil Parkin (12/29/2015)

---

Grant Fritchey (12/29/2015)

---

Eirikur Eiriksson (12/29/2015)

---

I really appreciate the effort of those who write the articles posted on this site but sometimes the quality seriously suffers from...

Grant Fritchey (12/29/2015)

---

Eirikur Eiriksson (12/29/2015)

---

I really appreciate the effort of those who write the articles posted on this site but sometimes the quality seriously suffers from the absence of technical...

Have you also considered using a script task? It might be the most elegant solution in this case.

Ok thanks. Have you considered creating an appropriately indexed 'working' table to hold the results?

I'd suggest including a date created column.

Then your package logic becomes

1. Should I recreate results? (Based...

Yes, as far as I know. SSIS packages are executed by dtexec.exe, which is separate from the other...