SSIS: Excel Connection Manager Error “Class not registered”

Recently, we were working on SSIS to get data from AX to the staging tables. As part of the requirement, we were also using Excel Connection Manager to read the data from one of the excel file and load it to a table. After completing the development, we executed the package and it was successfully … Continue reading SSIS: Excel Connection Manager Error “Class not registered”

Advertisements

SSIS: Login failed for user “NT AUTHORITY\ANONYMOUS LOGON”

Recently, we were working on SSIS for ETL(Extract,¬† Transform and Load) to get the data from AX and push to the staging tables. We were using linked server for AX and we were using¬†Windows Authentication for connecting to it. While running the package from SSDT, it got executed successfully. So, we deployed the packages to … Continue reading SSIS: Login failed for user “NT AUTHORITY\ANONYMOUS LOGON”

SSIS: “The version number in the package is not valid. The version number can’t be greater that current version number”

Recently, while working on SSIS to get data from AX and putting in our staging tables, we faced a weird compatibility issue between SQL Server and SSDT version we were using. We were using database as SQL Server 2012 and SSDT for VS 2013. After completing our development, while executing the package from SSDT, it … Continue reading SSIS: “The version number in the package is not valid. The version number can’t be greater that current version number”