I had a similar problem. The way I got it to work was to create a batch file using the dtsrun utility and schedule it in "scheduled tasks" to go off...
Learn how to write stored procedures, working wit triggers, etc. The developers at the company I work for do most of their own when creating applications. But there have been times when they have...