Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 How to schedulize a SSIS solution

Author  Topic 

jack10063
Starting Member

5 Posts

Posted - 2013-08-20 : 07:18:33
Hi,

Sorry for a newbie question. I have created a SSIS package that has 4 Execute Package Task within it. What would be the best way to run this on a daily basis? I tried to import the parent package to SQL Server Agent but I couldn't get it work.. Any ideas?

br,
Jack

rohit.kumar.barik
Starting Member

4 Posts

Posted - 2013-08-20 : 14:01:22
You can see the post below.
http://sqlserverinside.blogspot.in/2013/08/deploy-ssis-package.html
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-08-21 : 00:14:11
create a sql server agent job to execute this package and schedule it. you may choose the individual packages as well as above package in the Integation services server or as a file in file system.

http://blog.sqlauthority.com/2011/05/23/sql-server-running-ssis-package-in-scheduled-job/

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

jack10063
Starting Member

5 Posts

Posted - 2013-08-21 : 11:06:33
Thanks for the answers! I guess I am missing something obvious. I am getting an error "Source: childPackage" Description: There is no project to reference".. So, I just built a job for the parent package in SQL Server Agent. Should I include childPackages? When starting the parentPackage in SSDT everything runs smoothly..

br,
Jack
Go to Top of Page
   

- Advertisement -