SQLTeam.com | Weblogs | Forums

Refresh excel


#1

hi

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?

thanks


#2

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


#3

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.