Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-11-02 : 07:21:32
|
| Prem writes "We are running every day night some DTS package in Sql Server 2000.It will convert Fixed delimeter Text file into Tables and it runns many stored procedure to modify data and transfer data into some other required Tables. Some of the packages are running very slow. Could you please give me some tips to speed up my Packages. Thanks." |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-11-02 : 09:14:58
|
| Optimise the code?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
surefooted
Posting Yak Master
188 Posts |
Posted - 2004-11-02 : 10:35:18
|
Start by looking at each individual procedure and begin your optimization there.-JonShould still be a "Starting Member"  . |
|
|
|
|
|
|
DTS