Hello, I'm trying to automate an export of a flat file in SQL 2008. I saved the package file and am trying to schedule to schedule it following these instructions: http://www.sql-server-performance.com/2008/scheduling-a-ssis-package-in-sql-server-agent/2/ My window does not look like the one shown. I can see down to username/password but I do not have the Package: option to browse to my dtsx file. I read something about needing to modify the file in BIDS first but I'm not sure what to modify. Can you help?
If you are looking for scheduling a SSIS package through DB service , you could continue the same steps shown per that blog above and switch to schedules part to set your defined frequency basis … If this doesn't match with your needs, please elaborate more