Invoke-Sqlcmd -InputFile variable

Question

How can I pass the input and out file variable in Invoke-Sqlcmd

$SQLServer = "MyServer"
$db = "MyDB"
$inputfile = "e:\mypath\myinputfile.sql"
$outputfile = "e:\mypath\myoutputfile.txt"

Invoke-Sqlcmd -ServerInstance $SQLServer -Database $db -InputFile $inputfile | Out-File -FilePath $outputfile

Error message:
Invoke-Sqlcmd : Cannot validate argument on parameter 'InputFile'. The argument is null or empty. Provide an argument that is not null or empty, and then try the command again.

Answer 1

It works when adding "Import-Module SQLPS"

Import-Module SQLPS

$SQLServer = "MyServer"
$db = "MyDB"
$inputfile = "e:\mypath\myinputfile.sql"
$outputfile = "e:\mypath\myoutputfile.txt"

Invoke-Sqlcmd -ServerInstance $SQLServer -Database $db -InputFile $inputfile | Out-File -FilePath $outputfile