[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Sharing SSIS packages between multi developers

Posted on 2009-12-30
6
Medium Priority
?
767 Views
Last Modified: 2013-11-18
we have SQL Server 2005 Enterprise.
I create a package, and send it to the server.

My co-worker can not go into my project with my packages to make changes without the following error:  There were errors while the package was being loaded. The package might be corrupted.
 
Nor can we just include the other persons packages in through the add existing package (either pulling off the file in the others area, or pulling off the server if deployed)
1) the File connections that are built as Data Sources to be shared with all the packages become unshared connections
2) the connection managers id ("{E2664320-ABF8-4BE0-8EEE-3ED20A4E81AA}") not working.

Is there some way that we can share these packages !.. With all I read about large Data Warehouses employing mega people, there has to be a way you allow different people to maintain packages. This should not be a problem for our tiny group of 2 developers.

Will we have this same issue once we start developing reporting cubs with SSAS?
0
Comment
Question by:moosetracker
  • 3
  • 3
6 Comments
 
LVL 30

Accepted Solution

by:
Reza Rad earned 1500 total points
ID: 26147753
0
 
LVL 1

Author Comment

by:moosetracker
ID: 26148364
Ick, not what I wanted to hear. Looks like this TFS is over $2,000 + $300 per license..
So Enterprise SQL Sever.. Enterprise meaning you are suppose to be able to have multi-users, is not multi-user friendly when it comes to SSIS packages.

Again the question. Will we have the same headaches working on SSAS projects? (Being, that we will not get a nickle out of our company for anything, so will not be getting TFS).

Thanks
0
 
LVL 1

Author Closing Comment

by:moosetracker
ID: 31671307
I had a second part to the question that was never answered.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 30

Expert Comment

by:Reza Rad
ID: 26207342
Hi,
I missed your question for a while, I found it now!
of course there is a late respose,but you can do the same with TFS on SSAS.
But if this is expensive solution for you, use SVN instead. SVN is full free but with powerful functionality.
http://subversion.tigris.org/

by the way,Thanks for points.
Regards,


0
 
LVL 1

Author Comment

by:moosetracker
ID: 26291772
Thanks so much.. This will work..
0
 
LVL 30

Expert Comment

by:Reza Rad
ID: 26291831
Glad to help,
Regards,
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preface This is the third article about the EE Collaborative Login Project. A Better Website Login System (http://www.experts-exchange.com/A_2902.html) introduces the Login System and shows how to implement a login page. The EE Collaborative Logi…
Without even knowing it, most of us are using web applications on a daily basis.  In fact, Gmail and Yahoo email, Twitter, Facebook, and eBay are used by most of us daily—and they are web applications. We generally confuse these web applications to…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)
Suggested Courses

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question