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 9 (of 9 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: 246962 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.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

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.