Runing Package on a distant server using DTexec.exe

 

hi !

 

i puzzled following:

 

on server x, have packages running fine, sql & ssis installed.

on server y, have sql server/90 file installed (i don't know does). no sql server, neither ssis (services).

 

ok, now, want do is able run package on server x server y. in fact, need application on y able start package when data validated.

 

when pass following command (master name of package) on server x; runs fine:

"dtexec /server x /sql  master /rep v"

when pass on server, fails, seems login time out problem.

 

i contacted admin in charge of active directory. account using ad service account, runing admin on both server. have created right level of rights on databases used package. doesn't seem that source of the problem. or @ least, can't think of other possibilities.

 

after, reading thread way dtexec.exe works. found out several saying detexec running locally. understood when u pass name of package on distant server (/server x /sql master), load package , why needs ssis needs running on local server executing dtexec.

for testing purposes, created 2 simple packages. 1 reading datas, , 2nd 1 doing reading , writning.

both works fine on server x. 1st works fine server y!!!! 2nd fail server y.

 

now, few questions:

- in command prompt, how can see account running with?

- can explain me how dtexec.exe works? if running locally, , in case, how able run 

 

 

- in command prompt, how can see account running with?

 

the account used account opened / running command prompt session, same user logged on computer, you.

 

- can explain me how dtexec.exe works? if running locally, , in case, how able run

 

dtexec other simple windows process. runs on same machine started on. there nothing clever in there. if open notepad on machine have no impact on server. same dtexec.

 

the confusion arises because people see “server” command line switch , think there magic behind it. point of location options (/server, /file, /dts) tell dtexec package. server issues sql query return data store in sql server table. data happens xml representation of package. no different other program running on machine asks remote sql server query result. sql server supports remote queries.

 

ssis not support remote execution.

 

btw must have ssis installed on machine dtexec work, requires support of local ssis service.

SQL Server  >  SQL Server Integration Services