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?
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..