I got requirement to convert all my excel report file in SSIS from .xls to .xlsx including migration from 2008 to 2015 DATA Tools(Targer version : SQL Server 2016) - For all the reports we use Data Flow Task to extract reports i have added "WITH Result Sets" along with EXEC SQL command which is working fine. But Execute SQL Task in the project which has OUTPUT variable in Result set from Teamp table is throwing below error.
I understand this is due to its running in 64bits but if we switch it to 32bits its working fine but Excel connection manager is throwing error since .xlsx format works only in 64bits. How to tackle both the issues. ? Appreciate any help to resolve the issue.
User contributions licensed under CC BY-SA 3.0