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 MVP, MCTS, MCITP SQL Server

    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