To be absolutely sure I just defined a OLE DB source mit a row count after that. The data is still read only by one thread. How is this possible?

TABLOCK is independent for parallel inserts. It is just relevant for minimal transaction logging. Is that what you mean?

I have tried the Balanced Data Distributer and used one output for one CPU core (i.e. 8 outputs in total). Now, when looking at the SQL monitoring I see one...

I am not limiting the number of threads. But I have a primary key on the fact table which is of course varies in each row :-). I have no...

Ok, I found a way to define the many-to-many relationships but the results are not explainable :-(. As the original thread title does not match anymore, I will open a...

If it is not supported, why is it allowed to have several fact tables in place and define linkages :-(?

Is there a workaround?

It's multi-dimensional by model.

Do you think dim_Spell is the problem in MD, too? Why do you think it is the cause?

Thanks

LoL, at least I profit from the workflow engine and parallel execution, logging and error handling. This is something very difficult to implement, especially to have parallel SQL tasks running...

So when dealing with data transformations at tables with 40-50GByte in size: is it recommended to use SSIS interal operators at all or should I go always for DB Engine...

Ok, understood. Just thought that I can somehow skip persisting manually the intermediate table.

Can you recommend some links which provide translation and thinking from T-SQL to SSIS?

For me, it is...

Hi,

thanks for your fast reply. I thought so as I didn't find any literature. Though, it would be nice to have something like that. There is a script transform. Why...

Hi guys,

sorry for the late reply. I had email notification turned off and the post was out of my mind.Thanks for the input about not dropping compression. I thought that...

Thanks, I will test this :-).

Hi @thom-2 A,

thanks for your very detailed code example, it helped me a lot. It will not suit my use case but I have other tasks where it...

Thanks for the quick input.

@table

is meant to be an object in my example. I just wanted something like in MS Access, where I can input RecordSet objects...