CODEWITHSUNDEEP
sql-serverssisdtexec
Aserian
Aserian

Reputation: 1127

How can I remote run an SSIS package using DTEXEC?

I'm very new to using dtexec and to deploying SSIS packages (mostly just run them in VS). I would like to remote run a package that I have deployed to a server using DTEXEC...

The package name is SQL2012 Update Run. When I open up SSMS, the package is found under

Integration Services Catalogs -> SSISDB -> ServerUpdate -> Projects -> UpdateRun -> Packages -> SQL2012 Update Run

The server name is 1555\C1592.

I have tried all sorts of variations on using the /sql command, the /ser command, /dts, /file, I just can't seem to get it to run.

How would I use the dtexec utility to run the package at the specified location using integrated security?

Edit: Oh and there are 4 parameters, 3 are strings and one is an int16, how would I pass these in?

Thank you

Upvotes: 0

Views: 1415

Answers (1)

Mike Zalansky
Mike Zalansky

Reputation: 796

Below is an example of how write dtexec with the dtsx file location and variable input.

example:

dtexec /F "C:\Temp\Test.dtsx" /SET \Package.Variables[User::Guess_A_Number].Properties[Value];3

Shell (Edit):

dtexec /F "<your_directory/<your_file>.dtsx" /SET \Package.Variables[<Your Variable>].Properties[Your Value];<Your Value>

Explanation: /F is the location of your dtsx (SSIS) package /SET to set your variables.

More info on dtexec: TechNet Link

Hope this helps!

Upvotes: 0

Related Questions