...in SQL 2000 without having xp_cmdshell permissions.The best (easiest) way to allow that is to create a job that runs the DTS package(s), then use sp_start_job (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_sa-sz_11uq.asp) to start that job.
-PatP|||Good idea, thanks.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment