The longer I watch this thread unfold, the more troll-like it seems.

Perhaps you would provide a fuller statement of requirements to help us understand why you are doing this. And...

I don't think that Gail is a 'sir'.

edvard 19773 (4/15/2012)

---

Still thanks for having solved my immideate problem!

I am aware of, that your solution is much faster than a row by row solution, and in this case, its...

edvard 19773 (4/15/2012)

---

Did the trick - Thanks:-).

Not urgent, but how to make it in a WHILE loop instead.

I do not need it here, but it seems wrong, that i cannot...

Use Execute Package tasks instead?

If you have it installed somewhere, you could fire up Profiler and check the actual queries that are being sent from the front-end app. Might give you some clues.

Are the dnr_cst_key columns indexed in both tables?

slpgma (4/11/2012)

---

Not so sure that's a good idea for anything other than practice. If you did that in Bristol, RI, you're code would really be a problem because half...

5) Why should I do my own homework?

aarionsql (4/10/2012)

---

Hi Phil,

Many thanks! Thank you I have learned a new way of thinking and looking at things when I saw your reply. I will try and replicate your query...

OK - do you have SSIS installed on both servers? Merely executing the command line is not sufficient.

Here's a CTE example:

with Table_A as (select 10844 x_No, 2 Rank2, 18178 sysno, 1 Rank1

union select 10844, 4, 27529, 2

union select 10845, 1, 22994, null

union select 10845, 3, 22129, null...

DBAgal (4/10/2012)

---

I have a SSIS package that needs to write to a share on a server separate from where the package is executing. I can execute the package from...

EasyBoy (4/10/2012)

---

preetham gowda (4/10/2012)

---

See if you can change the dataType from char to varchar and update the coulmn by trimming it.

I did try converting Char to Varchar but getting the...

You're receiving high-quality, free assistance and advice...