Duplicate post. Original thread with replies can be found here:

http://www.sqlservercentral.com/Forums/Topic1562726-3411-1.aspx

kbnyny (4/17/2014)

---

I was changing the datatype to see if I get a different output when I run the package. Currently when I run it with DT_NTEXT and that is the...

You should...

mr_effe (4/17/2014)

---

Yes you're right. The most locks occur by the merge statements. Do you have an idea how to prevent it?

So can you also give me some hints what i...

Anyone with a better grasp of partitioning and locking can chime in on this one?

http://www.sqlservercentral.com/Forums/Topic1562552-391-1.aspx

mr_effe (4/17/2014)

---

Hi Koen,

thanks for the fast answer. But is there no other chance to load the table at the same time? Because i thought that because of the partioned tables...

That...

dopydb (4/17/2014)

---

hi

i have an ssis job, which runs various calculations, creates a .txt file and then uploads to an FTP site.

when i run it in bids it works fine,...

Is it an option to create a report? (it will be much easier)

You can load a data warehouse in parallel, but I would try to avoid loading a table by multiple processes at once.

Try loading different tables at the same time.

Easy one thanks.

Did you look for the full error?

kbnyny (4/16/2014)

---

Error msg say " The data type for input column "Copy of XML_f52e2b61-18a1"(330)" is DT_NTEXT.

When I change encoding to unicode and the data type DT_NTEXT to that this is...

You could use sp_msforeachtable.

You cannot post directly from your own hard drive.

You can upload an image as an...