SSIS Projects vs Packages

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » SSIS Projects vs Packages

SSIS Projects vs Packages

Rate Topic

Display Mode

Topic Options

Author

Message

Bonz99

Posted Thursday, February 05, 2009 3:20 PM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, October 06, 2012 9:30 AM
Points: 9, Visits: 33

In SSIS, a solution can hold multiple projects and a project can hold multiple packages. Am looking for a clear discussion of when & why you would create multiple projects w/in a solution, versus creating multiple packages w/in a single project.

I am an experienced DTS/SSIS developer, but am still unclear on this.

Can't find any discussion of this in MSDN or other online sources.

Post #651321

Michael Earl-395764

Posted Friday, February 06, 2009 6:10 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, August 10, 2010 5:07 AM
Points: 2,732, Visits: 23,078

We have a rather large data warehouse implementation here.

For the SSIS portion of the implementation, we have a few solutions - I will describe one of them (changing some names for various reasons)

Solution: DW ETL
Project: Source 1 ETL
Package: Base Dimension Load
Package: Complex Dimension Load
Package: Fact Load
Package: Loader Loop
Project: Source 2 ETL
Package: Base Dimension Load
Package: Complex Dimension Load
Package: Fact Load
Package: Loader Loop
Project: Cube Process
Package: Cube Loop
Package: Full Process
Package: Incremental Process
Package: Synchronize Cubes
Project: Security
Package: Cube Roles

So, we can stay pretty organized. It helps split the work up by developer. It also allows our custom deployment builder (we built it) to create an SSIS folder structure based on the solution and project structure so everything does not end up in the root folder.

Post #651545

Bonz99

Posted Friday, February 06, 2009 8:42 AM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, October 06, 2012 9:30 AM
Points: 9, Visits: 33

SSCrazy -- Thanks, helpful. I find myself wishing you could define things like data sources at the solution level, rather than always at the project level, but it appears you group your packages, at least in part, by data source.

Post #651747

Michael Earl-395764

Posted Friday, February 06, 2009 9:49 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, August 10, 2010 5:07 AM
Points: 2,732, Visits: 23,078

I find the data sources in the projects rather useless. They just muck up the connection information you get from local configuration files when you open a project in BIDS.

As long as you use the same connection manager name, configuration files can be the same for all packages you create.

Post #651815

« Prev Topic | Next Topic »

Permissions