Unanswered: Executing App with DTS, trouble with scheduling package
I've created a test application in windows ( vb.net ). When executing this app with the DTS package it seems to work fine ( by right clicking on the package and selecting “Execute Package” ). It finishes successfully and does what it supposed to. But when I try to schedule the package with the SQL Server Enterprise Manager in Management > SQL Server Agent > Jobs it Fails every time. I schedule it by right clicking on the package and selecting the “Schedule Package” option. Does any one have an idea why the schedule keeps on failing? Thanks in advance.