SQL Server Performance Forum – Threads Archive

Job scheduele for DTS Package

Hello there,
I am trying to create a job schedule for DTS package.
when I test run the DTS Package from my local machine, the DTS works fine as it suppose to. When I schedule to run the DTS, getting an error, DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005). This is error appears to be the issue with writing the destination file (wanted to have the data transfered to a .txt file). As per my DTS, the text (destination) file should be on my local machine. Is there any work around to have this process schedule? Thanks in advance,
Sabesh

---

Hi,
Try this as well for testing.
Create a procedure to run the DTS using dtsrun utility and then create a job to run the procedure using T-SQL task in job. Check whether job runs this SP in turn DTS perfectly or not.
Sample Syntax: set @cmd=
‘dtsrun /S’[email protected]+’ /NPackage Name /EMicrosoft OLE DB Provider for SQL Server’
exec master..xp_cmdshell @cmd, no_output

---

]]>