All geek questions in one place

How to remotely run a DTSX package from a bat file?

I am trying to remotely run a DTSX package from a bat file with this command:

DTEXEC /DTS "\File System\MY_PACKAGE_NAME" /SERVER MY_SERVER_NAME /MAXCONCURRENT " -1 " /CHECKPOINTING OFF  /REPORTING V

This works fine locally, but cannot be deleted remotely (I have administrator privileges on the machine I point to, and I also have SQL permissions). I get a timeout error (login timed out).

+3
source share
3 answers

After a little research, it seems that it is not possible to run DTEXEC remotely (it needs to be run locally - remote execution is not supported).

To overcome this limitation, the following method is generally implemented:

  • configure SQL job to run DTSX package
  • configure the stored procedure to run the job
  • isql BAT ( ) SQL ( SQL, ).
+3

, . , SQL- - .NET-. , Microsoft :

  • SQL Server DTSX. , , .
  • :

schtasks/run/tn MyTask [/s MySQLServer [/u [domain] user/p password]]/?

: , "PSEXEC" "schtasks" ( http://technet.microsoft.com/en-us/sysinternals/bb897553.aspx

+5

SSIS - . , , / .

, - , "DETEXEC".

+1

Source: https://habr.com/ru/post/1697850/

More articles:


All Articles