Hope someone can help me.

We had a DTS package running on SQL Server 7 which was working fine (it is
called from ASP code). We then moved to SQL Server 2000 and had to transfer
the package. We saved the package as a "structured storage file" from SQL
Server 7. We then opened and saved it on the new SQL Server 2000 box.
However now when it is run it throws the error "The system cannot find the
file specified". Lovely, eh?

So, I did some research and found that apparently there some incompatibility
between SQL Server 7 and 2000 regarding DTS packages. Most of the articles
suggested saving the DTS package with an owner and user password. But first
I wanted to try a few things.

I created a new DTS package from SQL Server 2000 with the same name that
does essentially nothing and was able to successfully call it from the
existing ASP code. So I thought great all I have to do is recreate the DTS
package under SQL Server 2000 and everything should work (starting with a
new, blank DTS package and copying the code from the original). I did this
and it still doesn't work, same error "The system cannot find the file
specified.

I then decided to do what the articles suggested and put a worthless owner
and user password on the original DTS package and changed the calling ASP
code to pass a password when loading the package. It works. But what the
hell? None of this makes any sense to me. Why was it able to run an empty
new DTS package named the same without a owner and user password? And why
does it fail when trying to run a new DTS package named the same and with
the whole process recreated from scratch? When I put a owner and user
password on either the original package or the new package (with recreated
code) it works, why? Does that mean I have to change all packages to use a
worthless owner and user password, and change all calling code to include a
password when loading the DTS? If so, this is a going to be a pretty major
headache.

--
Dan

Yeah, you got it Darren. I just realized that myself.

Thanks,
Dan

"Darren Green" <darren.green (AT) reply-to-newsgroup-only (DOT) uk.com> wrote in
message news:X96BGoFf9mQ$EwED (AT) sqldts (DOT) com...