When I deploy my SSIS package to our SQL2012 Integration Services Catalogs\SSISDB and execute the Visual Cron task, I get the error that the datafile cannot be open. But when I create that package as Package Deployment Model and point the Visual Cron Task to the actual folder location, that SSIS package is successful and the txt file is created.
Is there special proxy setup needed for a project deployment model?
This is also our companies first SSIS Project Deployment. We have three SSIS packages total and all are Package Deployment Model. We are a very small IT shop, myself, manager, and report writer.
Thanks,
Robert