>> 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??
When you run the package with DTSRUN, the package is being run on the machine that you're currently logged into. When you use TSQL or a stored procedure, the package is being run on the server under the permissions assigned to the SQLServer service account.
Also, maybe there's a trigger causing the transaction to be rolled-back. Configure the package and datapump to capture error messages to a file.
-Mike