Thank you very much Jonathan!
 I added the line and fieldname and no error whatsoever. So view shows data, but no additional column is showing. The query result (view) is...

Phil Parkin (11/23/2016)

---

John Rowan (11/23/2016)

---

Guessing that the DTS.Runtime library is referencing the local SSIS instance. Not sure how you'd point that to another catalog. You may check the...

M'kay, well forget about issue 1. I had a good look into it and it seems to work completely different than the old DTS assembly. I gave it a try...

Thanks Phil and John. I choose the path of executing the dtsx packages through a stored procedure.

Meanwhile I made quite some progress. Got the SP working, so I began building...

Jeff Moden (11/2/2016)

---

The solution is pretty easy then. Don't try to write...

Okay, so I've been very busy at work with this case. Data migration is finished just in time but there's lot of room for improvements.

We ended up using this querie...

Okay we're trying to solve this but I'll mark Phil's post as solution.

Thanks again!

Phil Parkin (10/23/2016)

---

You've just found a pretty good example of why SELECT * is often regarded as bad practice.

Usually, I would suggest that you specify all of the column names...

Okay, so I created the temp table and populated it. No problem.

I altered the other script so that in my opinion it should work. But now it states that 'Column...

Thanks again Phil. Yes I missed your point. Sorry for that.

Now with the extra code example I think it might be an excellent solution.

I'll start with it right away and...

What I'm trying to archieve is something like this untested (and incorrect) code (just wrote it down)

DECLARE @counter INT = 0

DECLARE @RwCnt INT = @@rowcount

WHILE @counter <= @RwCnt

BEGIN

INSERT INTO SELECT...

Phil Parkin (10/23/2016)

---

Super_Grover (10/23/2016)

---

It is unique AFAIKS but it's not an unbroken sequnece. In other words: it does not stay in sync with the row numbers...

It is unique AFAIKS but it's not an unbroken sequnece. In other words: it does not stay in sync with the row numbers (doc_numbers are missing...

Eirikur Eiriksson (10/23/2016)

---

Super_Grover (10/23/2016)

---

Hi all,

I must transfer a big table (231k rows not that big, but 735GB big because of blob) to another location by INSERT INTO SELECT FROM...

It appears...