I have imported a large number of SQL 2000 DTS packages from SQL 2000
to SQL 2005. Many of these packages have a VB script step that renames
a file. I modified the VB script to point to the file location on the
new server. When I run the DTS package from within the SQL 2000 DTS
editor, the package runs as expected and the file on the new server is
renamed. When I run the DTS package using xp_cmdshell, the package
runs successfully but the file is renamed on the old server. I have
tried deleting the DTS package and reimporting it without success.
Does anybody have a suggestion as to what the problem might be?