Re: Best Practice
From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 12/09/04
- Next message: Allan Mitchell: "Re: Reset a Global Variable??"
- Previous message: Allan Mitchell: "Re: copy db objects using import export wizard"
- In reply to: Paul Say: "Best Practice"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 9 Dec 2004 19:45:16 -0000
Only you can tell that.
I only ever have running on a dedicated box as many tasks as I have processors (-1)
-- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.SQLIS.com - SQL Server 2005 Integration Services. www.Konesans.com "Paul Say" <saywin@tpg.com.au> wrote in message news:OCNL$AZ3EHA.524@TK2MSFTNGP09.phx.gbl... >I am writing a DTS package to import from a Pervasive Database to MSSQL > > I have to import quite a number of records from aprox 12 tables > > Performance wise(speed) is it best to have each DataPumpTask run at the same time or sequentially. > > Paul Say >
- Next message: Allan Mitchell: "Re: Reset a Global Variable??"
- Previous message: Allan Mitchell: "Re: copy db objects using import export wizard"
- In reply to: Paul Say: "Best Practice"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
