how to configure ssis package and sql server agent not to stop sql server service if an error occurssz

A package stopping the sql service is not a normal thing. As I already noted in your other thread - stop doing a direct insert into a table using open rowset. "SELECT * into "+@TempTable+" FROM OPENROWSET("+"'"+"Microsoft.ACE.OLEDB.12.0"+"'"+", "+"'"+"Excel 12.0;Database="+ @[User::FolderName]+ @[User::SourceFileName] +"'"+", [Grades$])" Use a dataflow to move your excel data to a table - the way ssis was intended to be used. Chuck Pedretti | Magenic North Region | magenic.com

I can not do that because my column names are not always the same and I am trying to get column names and use pivoting and unpivoting. My column names are assessment names which differ from one section to another and I need to pull the column names to compare them with assessment already existing. Thankssz

If that is the case then I think you would be better off programatically opening the excel sheet with an SSIS task and creating/writing to your table there. Basically creating the whole process in c#. Then you would have full error handling available to you.Chuck Pedretti | Magenic North Region | magenic.com

I would use a Script task with some Excel interop code to probe the Excel file for the presence of the needed column names. See how you find needed columns usign C#: http://social.msdn.microsoft.com/Forums/sr/exceldev/thread/c6c5b4d9-7013-43ac-a756-8a1592592c26 The fact sqlserver dies as a result of your package is quite very odd.Arthur My Blog

Thank you allsz