How to schedulize a SSIS solution

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

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

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources