I have a Dts package,which does the following.
first i query table 1 and insert records into table 2.(SQL Server 7 (A)
second, the records in table two are exported to another SQL Server 7
Third, I run another query to update table 2 on SQL Server 7 (A)
here is the problem
when i execute the pacakage manually, it runs fine.
now when i use the SQL Server agent to run it, the job fails.
could anyone please tell me why this happening and what i am doin wrong
and what can be done to fix it.
thanks in advance.