Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mbaig_88
Starting Member
1 Post |
 Posted - 2012-08-30 : 10:21:26
|
| 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.majid baig |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-08-30 : 10:32:56
|
| you just need to select protection level as save sensitive with password and give a password for package. then store it in file system as a .dtsx file. Ask you friend to include the package in a integration services project in Bids it will ask for password. give password and they'll be able to execute/work on it------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
run ssis package from an other user account of sa