DTS packages not working after upgrade to 2000 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DTS packages not working after upgrade to 2000

We recently upgraded to SQL 2000 from 7. Our DTS packages aren’t running successfully and they give the error: "The system cannot find the path specified. Cannot open a log file of specified name. The system cannot find the path specified." The name of the log file has not changed. It’s location hasn’t changed. I don’t know why it’s giving that error. Anyone have a similar experience? Thanks,
Chris
Check path were original SQL 7 was installed.
I gess the problem is differents path between SQL 2000 and SQL 7.
Luis Martin
Moderator
SQL-Server-Performance.com
Ensure the correct path name has been supplied for the DTS package to work, for instance use only UNC name such as \servernamesharenamepath etc. Ensure latest service pack is updated on SQL & OS. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>