Home Forums SQL Server 2005 Administering ssis package not working with sql server agent but run fine manually RE: ssis package not working with sql server agent but run fine manually
Joy Smith San
SSC-Insane
Points: 24877
More actions
September 28, 2012 at 1:18 am
#1543212
Any other process runs at that time ?
How many records are fetched from oracle approx. ?
What about linked server settings ? Check the security tab in linked server properties and see the credentials used to connect to oracle.