SQLLion (3/10/2014)

---

Hi All,

I am getting following error on executing SSIS package through agent job.

Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified...

Int is always 4 bytes, so the data retrieval will not be slower.

Regarding calculations: no idea, but I think the effect will be negligible.

If you are not going to store decimal values (and also not in the future), I see no reason to choose float.

Go with int.

You can use the REPLACE function.

Maybe you have a lot of columns? Hard to guess without the table DDL.

How to tackle the issue? Do you have row/page compression on the table (Enterprise edition if I'm...

Every question should have this as an extra option 🙂

Jack Corbett (3/7/2014)

---

So for those of you who knew I was unemployed. I have an offer on the table. The only problem is that it involves...

At what step of the process do you get that error?

Nice question, thanks!

tracmonali (3/7/2014)

---

Thanks for information. Is there a way to write an SSIS which reads a table columns from one SQL server and transfers into another SQL server? I do not...

It is possible:

* store the current file name in a variable (you can configure this in the for each loop)

* inspect the file name with a script task. According to...

There are cases where an index might speed up an update statement, as the index allows to easier find the to-be...

Which DML operation?

If you're talking about updates/inserts/deletes, that's because the indexes themselves also need updating.

You need to make sure the 32-bit ACE OLE DB provider is installed on the machine.

What exactly do you mean with "that conditional data flow logic"?

Having seperate for each loop containers will exploit parallellism to the max. Although 12 seems a bit excessive 🙂