SSIS migration issue from 2008 to 2016


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.

  • [Execute SQL Task] Error: Executing the query "EXEC master..merge_file ? ,..." failed with the following error: "Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG))". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

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.

asked on Stack Overflow Mar 26, 2021 by Varun J

0 Answers

Nobody has answered this question yet.

User contributions licensed under CC BY-SA 3.0