Does anybody know of any bug with DTS Pkg Scheduling? I'm
updated on all the latest service packs and am running SQL
Server 2000. I created a DTS Pkg to import data from
FoxPro databases. It works fine by running it manually
thru EM, using a shell command thru Access, and by loading
it thru C#, BUT, when I try to schedule (logged on as the
same System Administrator logon that's running BOTH MSSQL
and SQL Server Agent), it always fails giving me some
funky error about 'Index Not Found'. I've seen alot of
others with similar postings. Please tell me there's a
solution because I don't want to have to create, schedule,
and then run shell commands on the server when all I need
to do is schedule the package inside SQL where I created
it and when I created it.
TIA,
John