SQL Server Performance

Scheduling ssis package

Discussion in 'ALL SQL SERVER QUESTIONS' started by Suzyn, Apr 11, 2012.

  1. Suzyn New Member

    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?
  2. Shehap Moderator

    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

Share This Page