Powershell to run SSIS package using dtexec set parameters

Question

I am facing issue in set parameters as my parameter has space. hoe to resolve this.

dtexec '/FILE D:\abc.dtsx /SET "\Package.Variables[User::OracleSource].Properties[Value]";"Data Source=123"

getting error Option "Source=123" is not valid.

it is not condering "Data Source=123" as value of parameter. How to resolve this?

Thanks,

Siva.

Answer 1

Hi @Sivasankar Rebba ,

I'm not familiar with PowerShell, here is a same thread you may take a reference to.

Someone also give a sample like shown below.

"C:\Program Files\Microsoft SQL Server\130\DTS\Binn\DTExec.exe" 
 /project "E:\...\bin\Development\Packages.ispac" 
 /package "Package1.dtsx" 
 /SET \Package.Variables[$Project::Target_ConnectionString];\""Data Source=MyServer\InstanceName;Initial Catalog=My_New_DB_Name;Provider=SQLNCLI11.1;Integrated Security=SSPI;Auto Translate=False;"\"

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

I don't think your syntax is correct. You have a single quote before the argument list but none to finish it. Also inside your SET you are wrapping the variable name in quotes and the value in quotes. You should either wrap the entire string in quotes or use none at all.

dtexec '/FILE D:\abc.dtsx /SET \Package.Variables[User:OracleSource].Properties[Value];"Data SOurce=123" '

I'm not sure about your Properties["Value"] piece though.

Answer 3

Sorry I missed part of my code.

here is my sample code.

$databaseConnection="Data Source=123"

$dtsxPath="D:\abc.dtsx"

$cmd="/FILE $dtsxPath /SET \Package.Variables[User:OracleSource].Properties[Value];$databaseConnection "

dtexec $cmd

getting error Option "Source=123" is not valid.

it is not condering "Data Source=123" as value of parameter. How to resolve this?