CODEWITHSUNDEEP
ssisssis-2012
B.Muthamizhselvi
B.Muthamizhselvi

Reputation: 642

Getting error while passing input parameter in package using cmd

Below is my command. I have used 5 parameters.

dtexec.exe /FILE "D:\Share\CRM#96012 - SSIS Package Live to Tr-28_08_2019\Move_live_to_training_Object\Move_live_to_training_Object\Live_To_Training_Db_Objects.dtsx"
/SET \Package.Variables[User::DesDBName].Properties[Value];"FireTrMJ" 
/SET \Package.Variables[User::Password].Properties[Value];"Pnx@2017" 
/SET \Package.Variables[User::ServerName].Properties[Value];"192.168.10.157"
/SET \Package.Variables[User::SourceDBName].Properties[Value];"FireLiveMJ" 
/SET \Package.Variables[User::UserName].Properties[Value];"sa"

I'm getting error as

 "/SET \Package.Variables[User::DesDBName].Properties[Value];"FireTrMJ"
 '/SET' is not recognized as an internal or external command,
  operable program or batch file."

Upvotes: 0

Views: 80

Answers (1)

Rob
Rob

Reputation: 9969

I think you need to escape EOL character with ^ in your script

dtexec.exe /FILE "D:\Share\CRM#96012 - SSIS Package Live to Tr-28_08_2019\Move_live_to_training_Object\Move_live_to_training_Object\Live_To_Training_Db_Objects.dtsx" ^
/SET \Package.Variables[User::DesDBName].Properties[Value];"FireTrMJ" ^
/SET \Package.Variables[User::Password].Properties[Value];"Pnx@2017" ^
/SET \Package.Variables[User::ServerName].Properties[Value];"192.168.10.157" ^
/SET \Package.Variables[User::SourceDBName].Properties[Value];"FireLiveMJ" ^
/SET \Package.Variables[User::UserName].Properties[Value];"sa"

Upvotes: 1

Related Questions