Scheduled DTS Package

Actually the package will run, however dts via the scheduler will not interact with the desktop.
which on the server will probably not be logged in anyway.

Jay

Thanks for the reply. So what should I do? Do i miss to add or configure something on my package? I juss wanna see this exe working cuz im planning to execute my own exe to do a job usingthis scheduled dts package. Im doing a test on a Win 2000 Server and SQL 2000.

Thanks
- Fred

Simply put:  You cannot execute any application that requires user intervention. Period.

How bout my own application that ends automatically? I compiled an exe that on load it does a process and then afterit ends automatically.

-Fred

jltoops,

Thanks for the reply. Actually the real scenario is i've created a .Net win app which is creating an xml file after some transaction from my DTS. My DTS transfer data from Server A and Server B. Server B serves as my staging area (clean data). After this process, my win app will get data from Server B and convert to xml. Is it ok to insert a Execute Prcess task after my Execute SQL task in my package? When i tries running this package manually, it gives me my expected outcome but when i tried scheduling my package i see no result. Also FYI im running this process in my local just to test.

"or inserting records into a databse, also remember WHERE the appication is running from
and when it is executing from the agent it will be run under the agent's user information. "

- i'm getting confuse here...


- Fred

Things run from the scheduler are executed by the SQL Server Agent Process from the database machine..
start ->settings -> control panel -> admin tools -> services -> SQL Agent
check the Userid this services runs with AND make sure its running.

If you are using a local system account, you will not have access to network shares
so the executable must be placed on the local hard drive.

Jay  

Jay

Thanks again sir. I've already check the SQL Agent and it's running. I thought i missed something when u've said something bout the sql agent before. All the settings u told here are in place but my exe realy doesn't respond to the jobs setting. Hmmm. weird.

But thanks again for the effort coz it push me to search for another solution. I saw the Execute Process task is able to run a batch file. I tried creating one and thank god it works well. I dunno why my scheduled DTS package with execute process task inside doesn't work when u directly point the path of the exe. Anyways batch file solves my problem.

- Fred

jltoops,

My condolences on the "C" grade, it is a shame the questioner has not bothered to follow the EE grading standards clearly stated here:
http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/help.jsp#hi73