DTS Scheduled Problem

[01310564]

Hello

In it's basic form I have a DTS Package that opens notepad.exe on NT4 Server running SQL 2000. It doesn't matter if i use an execute proccess task or activeX script to open a bat that opens notepad or just opens notepad, the same problem occurs when the DTS Package is scheduled.

What seems to be happening is that the DTS or BAT file starts the notepad proccess but nothing more happens. I.e. When i hit ctrl+alt+del and click on proccesses i can see that notepad has been started but it doesn't appear on the screen. As a result the package just keeps executing until i force notepad to close through the task manager.

All the articles i can find on the internet refer to the login used when a package is scheduled, I'm pretty sure that this isn't the problem because A) Notepad has been started B) I have tried running the SQLserveragent under all of the diffrent user names with no effect at all.

Any help would be apprecated because i've totaly run out of idea's

Thanks

Hugh

P.s. I could be wrong about the security issue, I'm not that confident about the in's and out's of SQL Security.