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 - 2003-05-27 : 10:10:33
|
| Narayana Vyas Kondreddi submitted "This article discusses various SQL Server Data Transformation Services (DTS) best practices. It is divided into sections like DTS naming conventions, DTS documentation, troubleshooting DTS packages, improving the performance of DTS packages, securing DTS packages, DTS resources." Article Link. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-05-27 : 11:29:05
|
| Misses the most important point.Only use dts when it's applicable. Don't assume that just because you are doing an import that it should be controlled by dts.Only looked at the performance bit. That almost says don't use dts in places but unfortunately doesn't suggest the option.==========================================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. |
 |
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2003-05-27 : 14:37:30
|
| LOL...I see your point. But I'll add that to 'SQL Server programming best practices'. I do agree that, people tend to implement everything in DTS, which the can be done with a simple scheduled script.--HTH,Vyashttp://vyaskn.tripod.com |
|
|
|
|
|
|
Article: SQL Server DTS Best Practices