Setup SSIS for a group of developers.

5 pts.
Tags:
SQL 2008
SQL Server
SQL Server 2008
SSIS
I newbie and I need help here.

We are doing a new MS SQL and BI setup for our developers here.

We have a team of 12 developers here doing different projects. We have one server with MS SQL being installed. This single MS SQL will be setup with each individual database for the projects that the 12 person will be doing.

We plan have all the 12 developers connect to their database in this server and develop their ssis packages in their local PCs. We want to restrict them to be able to access the packages that belongs to their projects only. 

Also after deployment where the packages are scheduled to run under job agent, we want to restrict each 12 developers to be able to rerun only their on jobs when their job fails. We want to prohibit them from running the jobs that belongs to others.

I think this is a pretty common organization structure with a team of developers. However I have no experience how we should structure and control our MS SQL and the BID.

I would appreciate if you can advice. Our team has been thinking of the best solution but I guess we are confuse now.

Please help. 

Now our problem is to know how



Software/Hardware used:
MS SQL 2008 Standard Edition

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following