Hello, To start debugging, use Logging in the package and execute the package by using SQL Server Agent, Then go to logging file and see what is happening, What processes is taking more time? http://msdn.microsoft.com/en-us/library/ms167456.aspx Thanks

hello everyone i ve got a 3 steps of ssis jobs in sql server 2005... when i execute the packages through bids or dtexecui, each task takes about 15 seconds to run.... however when i run the packages through sql server agent each one takes about 15 minutes... is there any idea why this is happenning? thanks