Hello All, I am using SQL Server 2008 and I developed a package in BIDS that'll loop through a set a excel files and import that into the database and the package is working fine. Now, I want to schedule that package so that the package will work by itself, but it's not working as I want it to.I know how to do scheduling and all that but somehow its not working. If I schedule a simple package like which performs a simple delete operation from the table then also it's not working..however if I execute the same package alone (i.e. .dtsx file) am able to run the package and get the expected results...and yes a simple Transact-SQL task (if scheduled) is also working fine..:) So far I tried everything I can..and now the condition is like you suggest anything and probably I would say..'Tried' ;) :) Please suggest me something that can really help me out on this. ty in Advance.. :)

Are you getting any error ?? check in Job History.Shailesh, Please mark the post as answered if it answers your question.

Shridhar, I am guessing it might be some security issues. Can you please confirm if the service account under which the SSIS service is running has sufficient permissions? The next issue can be the 64bit vs 32 bit. Try to schedule the package to execute in 32bit mode and see if it helps. Regards, Sri Meda1

@Shailesh : I don't have access to Error logs..can you please tell me how and what priviledges do I need for seeing the error logs? @Shridhar : Can you please tell me what permissions are needed to run an SSIS package...also let me know how to grant those permissions.

What version of SQL Server and SSIS are you using? If you have enabled logging the logs can be seen in a table called sysdtslog90. If not I would suggest you to enable logging and the rerun the package. Also can you share the details as how you have scheduled your package? Regards, Sri Meda

Hello Sri, Am using SQL Server 2008 and BIDS 2008. Details of scheduling : I saved a .dtsx package in SSIS store from the BIDS and then scheduled the package with the normal procedure ... I also tried to save the package on the file system and then schedule it from the SSIS interface.

You must grant delete permissions on table to SQL Agent Service accounthttp://uk.linkedin.com/in/ramjaddu