question

sys7899ler avatar image
sys7899ler asked

SSIS conversion of Excel version

How do I convert an Excel file type from xlsx to xls by using SSIS/SSRS?
ssisexcelssrs-2008error-message
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
ThomasRushton avatar image
ThomasRushton answered
I'm guessing that you might want to look at a dataflow task with the source as the xlsx and the destination as the xls file? Use the [Excel Connection Manager][1] a couple of times, once for the source, once for the destination. [1]: https://msdn.microsoft.com/en-us/library/ms139836.aspx
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

thanks thomas is it possible if i have excel file with Xlsx extension converting into xls extension i don't have xls version excel in my pc ,Thanks for your answer Thomas is it possible if hi have updated version of excel(xlsx) into xls i donn't have xls version in my PC.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.