Extract Load Transform SQL Server

Could not create DTS.Application because of error 0x80040154

If you encounter the following error: Could not create DTS.Application because of error 0x80040154 From calling DTEXEC.exe. For instance like so: It could well be the case that the DTEXEC that is being called is not compatible with the database server you want to run the SSIS package on. Particularly your development environment may be susceptible to this problem. To solve this, search for all the different DTEXEC.exe versions on your machine and find the…

Continue reading