SQLTeam.com | Weblogs | Forums

Refresh excel



i have a script in ssis that refresh excel file (i have a pivot table in excel)
the problem is that some of file faild, not the same all the time. i do not get the detail of the error .it\s said "it's failed"

any suggestion?



Can you explain how you're doing the refresh? Are you using data flow task in SSIS? If yes, Add a OnError handler in it to capture the error records. FOr capturing errocode etc you can use OnError event handler for the task


If you're using Sql Server 2012 or 2014, there were a bunch of problems with SSIS including some accidental "retro code" problems. Make sure that you've updated to the very latest SP and CU.