CODEWITHSUNDEEP
powershell
Moderat
Moderat

Reputation: 1562

invoke-sqlcmd not recognized even though SqlPs loaded

I am trying to create a shell script to run a query and store the output, and I've got my script looking like this so far:

push-location;
import-module SqlPs;
Pop-Location;
$myData = invoke-sqlcmd -InputFile "C:\<path>\blah.sql" -serverinstance dbatest -database testdb;
$mydata | out-file C:\Users\<path>\shelloutput.csv;
remove-module sqlps;

It loads SqlPs fine which I can check with with Get-Module -ListAvailable producing thisenter image description here

but when I do invoke-sqlcmd it is not recognized:enter image description here

Any ideas as to what else I can do?

Edit 1

When I add the option -Verbose I see this error enter image description here saying that some files are already present. Is this error preventing me from loading the module? When I do Get-Module it doesn't list the SQLPS module.

EDIT 2

Loading the 32 bit version gives me fewer errors but still errors loading files...now only 2 files are missing as opposed to 5 earlierenter image description here

Upvotes: 2

Views: 739

Answers (1)

gjutras
gjutras

Reputation: 65

I found on my system that I had in the path several sql bin references to 32 bit (Program Files (x86)) paths ahead of the 64 bit paths. I moved all the 32 bit paths below the 64 bit paths and it cleared up the issues.

Upvotes: 1

Related Questions