Greetings,
I have a DTS package that runs on ServerA (SQL 2000 Server - Windows
2000 Server) that deletes tables, re-creates the tables, and placed data on
ServerB (SQL 2000 Server - Windows 2003 Server). This package also
performs the above outlined steps on two other servers that are SQL 2000
Server and Windows 2000 Server)
This package is called from an ASP page that performs this "update"
process.
Here lies the problem. It works perfectly from the Windows Server
2000 to Windows Server 2000 machines. But when called in the ASP page, I
get an error stating the login is invalid when it is run and it hits the
Windows 2003 server based machine.
Now, if I run the DTS package from the Enterprise Manager, it works
in all cases. The only time this issue is coming up is when it is executed
via an ASP page.
As mentioned it works not matter what on MS Server 2000 to MS Server
2000 machines, NOT MS Server 2000 to MS Server 2003, YET it will always
work if run from Enterprise manager on a MS Server 2000 to MS Server 2000
or MS Server 2003.
Has anyone experienced this issue and have come up with a solution?
Your assistance is appreciated.