December 7, 2016 at 5:09 am
i am trying to convert xlsx to xls using DTS script task,but because the server hasn't got excel installed its throwing an error..Would it be ok to load MS compatibility pack on the server, or is there a better way to covert the files using DTS.
December 7, 2016 at 5:47 am
clucasi (12/7/2016)
i am trying to convert xlsx to xls using DTS script task,but because the server hasn't got excel installed its throwing an error..Would it be ok to load MS compatibility pack on the server, or is there a better way to covert the files using DTS.
I presume you mean SSIS rather than DTS.
Can't you just change your original process to save in xls format? Or both (one xls and one xlsx)?
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply