Tag: PowerShell

Extract Load Transform SQL Server

Could not create DTS.Application because of error 0x80040154

By Peter De Lange | by Peter De Lange

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

Uncategorized

Basic PowerShell commands explained

By Peter De Lange | by Peter De Lange

I have created two heavily commented PowerShell scripts that explain the usage of basic PowerShell commands. This may come in handy when you are handed over an existing PowerShell script but you yourself have no experience with the PowerShell language. This is meant as a fast explainer of existing code. Copy the two powershell scripts from the GitHub link below, place them together in any directory. In both files the code is explained through comments.…

Continue reading