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...

subha V (4/9/2012)

---

Hi,

Im running my package using a command file.When im executing the package manually by clicking the command file,its running fine.

But when im trying to run the package via...

mdkmohan (4/8/2012)

---

Hi,

I just need to disable sql jobs during holidays.

I found few ways for doing that but I don't know which is more efficient and generalized method.

Kindly provide your suggestion...

sivag (4/7/2012)

---

how to create log file and plz tell me what is log file here iam using website for advertising ads...

Hmm, clearly not, as you have duplicates 🙂

I'm therefore guessing that this table does not have a PK,...