Greetings experienced DTS people..

I was just wondering, is there a best practice to how many "Transform Data
Tasks" lines you should have between two connections? In your experience,
what is the upper limit before the system performance starts to suffer? 5,
50, 500, 5000?

I'm trying to figure when it is better to add a new connection instead of
adding a new "group" of transform data lines...

Thank you for helping out a newbie!

Cheers,
Elise

Hi,

Best practices such as allocate an exception file for each PUMP task are
always welcomed as well as set in natural names in each connection rather
than Sql choose for us references such as:
"Microsoft OLE DB Provider for SQL Server 2"
"Microsoft OLE DB Provider for SQL Server"

Moreover such references aren't visible in all their lenght from the design
sheet.
--
Please post DDL, DCL and DML statements as well as any error message in
order to understand better your request. It''s hard to provide information
without seeing the code. location: Alicante (ES)


"Elise" wrote:

Hello Elise,

You should create new connections to the data source(s). You should not
have tasks going at the same time than there are processors in the box.
All you will see happen is a lot of context switching and the false appearance
of things going at the same time.

Multiple Transform data tasks between the same two connections. Only one
will go at any one time.



Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com