Hi guys I have solution in which I have two projects which have two packages. Can I execte the solution such a way that both of the projects get executed on after the other?

one method is like You can use execute package task (by creating third package) and map it to two other packages

You could also create a SQL Agent Job that executes your packages as sequential job steps. If you don't want the job to be a traditional "scheduled" job, don't define a schedule for it, and all you will need to do to run the job on demand will be to execute the sp_start_job procedure and pass in your job name as the parameter

I agree that you can execute two SSIS (child) packages in sequence from a third SSIS (parent) package using Execute Package Task; - http://msdn.microsoft.com/en-us/library/ms137609.aspx You can also execute two SSIS packages in sequence within a SQL Agent job; - http://msdn.microsoft.com/en-us/library/ms189237.aspx I'd say SQL Agent is the easiest option and Execute Package Task is the most versitile option. For example Extending Transactions, Propagating Logging Details and Passing Values to Child Packages. It's quite likely you would end up executing the parent package from an SQL agent job anyway at a later date.If you have found any of my posts helpful then please vote them as helpful. Kieran Patrick Wood MCTS BI, PGD SoftDev (Open), MBCS, MCC http://uk.linkedin.com/in/kieranpatrickwood

Hi guys I have solution in which I have two projects which have two packages. Can I execte the solution such a way that both of the projects get executed on after the other? There is no concept of "executing a project" in SSIS. Can you elaborate on exactly what you want to do?http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me

Ok my requireemnt is like this, I have two packages of which one imports some tables from production to staging and does solme transaction. The other package loads it back to development. I know that we can make this posssible in one package. But the packages are already built and I just have to use them. So I created a solution comprising of two projects which holds these packages. I am wondering if there is a way if we can directly call the solution and execute it?

create another package, and add two execute package task there, in each execute package address one of the packages which you want to run, now when you run the parent package, child packages will run.http://www.rad.pasfu.com My Submitted sessions at sqlbits.com