November 8, 2013 at 7:24 am
Setup:
VS2010 (Team Explorer Add-In)
TFS 2010
SQL 2012 (using SSIS Catalog for package storage/deployment)
Back story:
DW team is growing from 2-man group, to a full team. Trying to implement some source control, deployment, and development standards before we're too far "in the woods".
Question/Issue:
Are there any standards and/or best practices for keeping my SSIS objects synchronized between TFS and the SSIS Catalog? Maybe I'm over looking something completely obvious here, but my concern is once we deploy from TFS to the SSIS Catalog, there's nothing to ensure the objects in the SSIS catalog aren't rolled back, updated, removed directly through SSMS (instead of through TFS).
November 8, 2013 at 6:06 pm
Let me know what you decide as im in a similar spot ... though with likely git, not tfs.
there's nothing to ensure the objects in the SSIS catalog aren't rolled back, updated, removed directly through SSMS (instead of through TFS).
My guess is that if this is a concern, the best practice would be limiting access to the catalog, either on a by project basis, or overall.
In theory, assuming ETL developers worked with local copies of SSDT to develop, and the SSIS server wasn't also the source/destination, you could actually lock most developers completely out of that DB/server, and have a couple roles in charge of deployment and scheduling. That may not be ideal though, depending on the team dynamic, and the workflow for development and QA.
Here is a blog post I found on the subject of permissions for the catalog:
http://blogs.msdn.com/b/mattm/archive/2012/03/20/ssis-catalog-access-control-tips.aspx
The more fun stuff I'm still wrestling with is securing passwords in connection strings while being able to collaborate, and organizing packages into projects in such a way as to keep people off each other's toes. I think package to package we would not have a lot of branching/merging needed, but if project level settings get changed, it is more likely to create a merging scenario, and I dont know how smoothly that will go.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply