SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 Migrating onto a new deployment model
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sql_er
Constraint Violating Yak Guru

267 Posts

Posted - 07/15/2013 :  17:52:29  Show Profile  Reply with Quote
Hi guys,

At my current work place we use SQL Server 2008R2 and have implemented something we call an "SSIS Library".

It is essentially a set of SSIS packages that are utilized across multiple projects/solutions.

The idea is to have shared code across multiple solutions - just like you have libraries in other programming languages that you just import and use.

We've created a set of SSIS packages (Library) and a set of Wrapper packages. The wrapper packages would get imported into a specific client project, get parameters and feed them to centrally located Library packages.

It has been working nicely, until we started thinking about migration to SQL Server 2012.

In SQL Server 2012 the new project level deployment model only allows one to use/execute packages from other packages within the same project - not across projects. This introduces a problem as we will not be able to call a Library solution from a Wrapper solution from the main Client solution (which is the current hierarchy of package execution).

Has anyone stumbled on the same problem and found a resolution (other than using the legacy model that might not exist in 2014)?

Please advise.

Thanks in advance!

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 07/16/2013 :  02:10:32  Show Profile  Reply with Quote
In project deployment model, you need to have packages included as external reference as far as I'm aware. But passing parameters, calling library packages etc would be a pain to implement in this.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

sql_er
Constraint Violating Yak Guru

267 Posts

Posted - 07/17/2013 :  14:26:22  Show Profile  Reply with Quote
Thanks visakh16.

Do you know if "external referencing" has something to do with using the old package level deployment model or are two concepts independent?
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 07/18/2013 :  00:57:00  Show Profile  Reply with Quote
quote:
Originally posted by sql_er

Thanks visakh16.

Do you know if "external referencing" has something to do with using the old package level deployment model or are two concepts independent?


Nope external reference comes in Package deployment model. You will reference packages outside of current project through external references. But there are few restrictions on that. I've just heard of it but havent had a chance to use it so far

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000