>>>What techniques do you use to put SP's into version control?
>>
>>I am interested in peoples' creative responses to this. I would assume an ideal solution would be what Mr. Kuhn mentioned, but that would mean you would need your DBA to always use VSS and/or communicate wite the developers, and that is not practical in my environment.
>
>DBAs are a bunch of sissys!
>
>I'm a developer and I design and maintain the database.
It's weird how it's set up here. We have a development "team" (basically me with a micro-managing project manager trying to tell me every detail to do). We try to set up formal processes of code check-in and check-out procedures from Source Control, coding standards, etc. Now, we have the DBA that plays by her own set of rules. It was fine with DTS because that is more of a "database" thing IMO, but I think SSIS is more of a "developer" thing and it's really counterproductive. It's almost like we are two separate teams who are never on the same page.
If only they would put me in charge of everything...