How reliable is DTS? I use the DTS utility at work a great deal and often
either save the package to SQLServer or complile the package as a VB
executable. I have often found the packages will not run properly, but will
run smoothly after a reboot. Has anyone else experienced this behavior?

-Noah Ganter

Got to say I find DTS to be very reliable.

I guess some things will depend on what you are doing in packages, calling
out to external executables or going across the LAN are some obvious
problems. I use SQL Server Agent to schedule the package runs and have as
yet had no real issues other than those mentioned.



--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


[quoted text, click to view]