I feel for you. I encounter this issue many more times than I would like too.

I once read a comment suggesting that if you are not doing a join to...

And even better, you can use PowerShell to create the scheduled task. This would also serve as documentation for the changes that you have just made. And better still, you...

The SQLPS PowerShell module referenced in this article is no longer being updated by Microsoft. It has been superseded by the newer SqlServer module. See https://docs.microsoft.com/en-gb/sql/powershell/download-sql-server-ps-module?view=sql-server-2017 for details.

The PowerShell script in the article uses the SQLPS PowerShell module which may not exist on the computer on...

And... even better, the error message is clear and helpful. This is a lot better than the only vaguely useful "cannot convert varchar to int" message issued when you try...

The Invoke-Sqlcmd cmdlet is part of SQLPS which is part of a SQL Server installation (or possibly just the SQL Server tools). Where are you running your script?

If this in...

You could use the Open Source DLL EPPlus to write the output from a SQL query directly to an Excel spreadsheet, e.g.,

$cmdText = "select object_name(i.object_id) as [Table Name], i.name as...

Assuming that your target audience is SQL Server capable and PowerShell newbie, I think you have omitted some key details.

The Invoke-SqlCmd PowerShell cmdlet is not an integral part of PowerShell....