With DTS in SQL2000, I just created a job that ran the DTS package and then
ran the job from a Stored Procedure.
Thanks!
Phil
-- bruce (sqlwork.com)
the Package.Execute() returns a DTSExecResult enum... in case of any error
the Execute method will return DTSExecResult.Failure
http://msdn2.microsoft.com/en-us/library/ms190901(printer).aspx
http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.dtsexecresult(printer).aspx
--
Misbah Arefin
https://mcp.support.microsoft.com/profile/MISBAH.AREFIN
http://www.linkedin.com/in/misbaharefin