run ssis package from an other user account of same domain

[majidbaig1988]

hello all,
i need some urgent help of you people....
i have created an ssis package which is simply extracting data from database and after applying some data formation tasks it send the data to excel sheet.

i want to know that how can my colleague execute the task when i am not available to execute it by using his own user account on the same machine.

i am not talking about the sql server job agent.

waiting for your urgent reply.
thanks in advance.

 

[SQLScholar]

Just create a batch file that runs it using DTSEXEC. He will obviously need all the permissions required to run the job.

----------------------------------------

http://www.fountain.me.uk

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Bernard Baruch

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------