dts package job failing

[tylerjones]

I created a dts package about 2 weeks ago that takes data from a table and puts it into an excel spreadsheet. Then I scheduled it to run as a job every 15 minutes. Everything has been running fine since then until yesterday afternoon. Now, I can go in and manually execute the package just fine... but the job itself fails every time. I've tried to delete and recreate the job, but it still fails. What else can I check? Thanks.

 

[tylerjones]

Nevermind... I just figured out that one of our admin guys changed the ip address of the data destination computer. What's strange is that in the connection properties, I specified the connection as \\pcname\directory ... and like I said above, I'd execute it manually and it'd work fine. But, it seemed like the somehow it was using the old ip when it would run as a job. Strange....