I cant seem to get a PS variable called $sqlParameters to be used in an SQL script, any clues to what I am doing wrong?

PS & SQL used are below:

PowerShell:

$sqlParameters = "powerShellVar = 'CONTOSO\cmpsvc'" invoke-sqlcmdInvoke SQL script using Powershell variables -inputfile "c:\temp\test.sql" -serverinstance SRVSCCM\MSSQLSERVER -variable $sqlParameters

SQL:

CREATE LOGIN [$sqlParameters] FROM WINDOWS; USE test EXEC sp_addrolemember N'db_owner', N'$sqlParameters' GO

Regards James

I cant seem to get a PS variable called $sqlParameters to be used in an SQL script, any clues to what I am doing wrong?

PowerShell:

$sqlParameters = "powerShellVar = 'CONTOSO\cmpsvc'"
invoke-sqlcmdInvoke SQL script using Powershell variables -inputfile "c:\temp\test.sql" -serverinstance SRVSCCM\MSSQLSERVER -variable $sqlParameters 

SQL:

CREATE LOGIN [$sqlParameters] FROM WINDOWS; 
USE test
EXEC sp_addrolemember N'db_owner', N'$sqlParameters'
GO

James