May 16, 2022 at 9:43 pm
hi,
I am trying to execute ssis package from command line. I also tried to pass environmnet variables like below. Not sure what is wrong?
Also is there a way that we can execute package using sql? if so how?
example:
Command line :
dtexec/ISServer "\SSISDB\Folder\Foldername\"Packagename" /Server "Servername" /ENVREFERENCE "Environmentname foldername"
This above command is not working . error: execute package failed because of error 0x80131537. Input string is not correct format.
May 17, 2022 at 2:14 pm
dtexec/ISServer "\SSISDB\Folder\Foldername\"Packagename" /Server "Servername" /ENVREFERENCE "Environmentname foldername"
Quotes look wrong, instead of \SSISDB\Folder\Foldername\"Packagename"
I think you'd want "\SSISDB\Folder\Foldername\Packagename"
May 17, 2022 at 2:55 pm
Envreference should be a number, I think. Here is an example from MS:
DTExec /ISSERVER "\SSISDB\folderB\Integration Services Project17\Package.dtsx" /SERVER "." /Envreference 2 /Par "$Project::ProjectParameter(Int32)";1 /Par "Parameter(Int32)";21 /Par "CM.sqlcldb2.SSIS_repro.InitialCatalog";ssisdb /Par "$ServerOption::SYNCHRONIZED(Boolean)";True
May 17, 2022 at 7:32 pm
Thanks working.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy