I have successfully created a DTS package importing data from sybase
database to a SQL server. In fact it can be run very well mostly.

But when I run the DTS package at command prompt but not at Enterprise
Manager its very unstable in course of it will hang sometime.

Can anyone tell me whether the DTS package run on Enterprise Manger is more
stable than at command prompt? What can I do to stablize the process running
on command prompt? Please help as I need very urgent!

thx

It should be no more no less stable. What happens then? breaks? Errors?

--

----------------------------

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


"LookAtMe" <alvin_tyl (AT) hotmail (DOT) com> wrote