I have a DTS package that imports some records from an ASCII file right into a SQL Server 7.0 table, nothing fancy.
I can execute DTSRUN from a DOS shell just fine.
But when I run it from Transact SQL or from a stored procedure, it runs wiht no errors, but no records get appended. I use the no-output clause with xp_cmdshell. Any ideas out there??
Bob
Database Development Team