MS SQL Server DTS - Can I have multiple Data Transform Task to the same Destination Ta

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Can I have multiple Data Transform Task to the same Destination Ta

James Ma

2005-09-27, 8:24 pm

Hi,

Now I am using multiple Data Transform Task to BULK INSERT to the same
destination table at the same time. The aim is to boost performance and I
found it pretty good.

Do you know if there is any risk in doing that?

Thanks in advance

James

bnhcomputing

2005-09-28, 8:24 pm

One thing that I have found: The first transformation task to succeed will
cause the DTS workflow to execute the next step. It will not wait for ALL
the transformation tasks to succeed.
--
bnhcomputing

"James Ma" wrote:

> Hi,
>
> Now I am using multiple Data Transform Task to BULK INSERT to the same
> destination table at the same time. The aim is to boost performance and I
> found it pretty good.
>
> Do you know if there is any risk in doing that?
>
> Thanks in advance
>
> James

Sponsored Links