March 2, 2009 at 11:56 am
One thing that I am curious about: What is the value of using a Solution to contain an SSIS project? What advantages and disadvantages does having the solution around the package bring?
March 3, 2009 at 3:39 pm
As far as I know you cannot open just a project in BIDS (aka Visual Studio). Even if you don't have a solution around the project to start off with, it creates one for you and will prompt you to save it when you are exiting BIDS. This allows you to debug the package.
That's the normal Visual Studio model. All projects go into a solution.
March 3, 2009 at 4:27 pm
using a solution gives you a container for all the projects. Now in your case is sounds like you have 1 project within the solution.
I have ETL's with 15 separate DTSX projects all in subversion it makes it easy to manage in a single solution.
Also you can use just DTSX files, you don't need a solution.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply