run ssis package from an other user account of same domain

Question

run ssis package from an other user account of same domain

mbaig_88

SSC Rookie

Points: 30
More actions
August 30, 2012 at 8:11 am

#280906

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.

Viewing 10 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

kl25 Hall of Fame Points: 3752 More actions · Answer 1

To start, check the package protection level. It's probably set to 'EncryptSensitiveWithUserKey'. You'll need a different level for others to be able to execute it.

mbaig_88 SSC Rookie Points: 30 More actions · Answer 2

thanks for your prompt response.

can you please tell me where can i find the security setting???

kl25 Hall of Fame Points: 3752 More actions · Answer 3

Open the package. Right click anywhere on the background (not on a task). Select 'Properties'. You'll find the protection level in the Security section.

For further information on protection levels see:

http://technet.microsoft.com/en-us/library/ms141747(v=sql.105).aspx

mbaig_88 SSC Rookie Points: 30 More actions · Answer 4

thx. got it.

what do you suggest which option i have to select to allow other user to execute my packages from there own user accounts?

kl25 Hall of Fame Points: 3752 More actions · Answer 5

Check the technet article I referred to. You'll have to decide what level works best for your needs.

mbaig_88 SSC Rookie Points: 30 More actions · Answer 6

i a have checked it all but none is full filing my requirements. i just want that any user can access and execute my package from his/her own user account with out any security. in short it should be available to all.

please help me i need it urgent.....!

thank you so much kl25 for your cooperation. 🙂

kl25 Hall of Fame Points: 3752 More actions · Answer 7

You're going to have to deal with the protection level if you want others to use the package.

Phil Parkin SSC Guru Points: 247180 More actions · Answer 8

One possible way around this is to create a SQL Agent job which runs the package and then to allow the user to kick off that job, rather than the package itself.

kl25 Hall of Fame Points: 3752 More actions · Answer 9

Good suggestion. I was limiting my thinking to file system storage with users opening the package to run it.