SQL Server Performance

How to create SQL job to exec SSIS package?

Discussion in 'SQL Server 2005 Integration Services' started by georgej, May 29, 2007.

  1. georgej New Member

    Are there any articles to direct me to create a SQL job which can execute SSIS package on SQL server 2005?
    By the way, on SQL server 2000 I use DTSRUN.exe in SQL job to run DTS. I tried to find the similar way to do this.

    Thanks for recommendation,


    George
  2. satya Moderator

    DTS is left for legacy application packages only and you wouldn't be able to do same in SQL 2005. Refer tohttp://mssqltips.com/tip.asp?tip=1180 to schedule SSIS package.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Share This Page