Post reply

How to schedule an SSIS package to run on SQL Server 2005

  • April 3, 2006 at 12:32 pm

    #168427

    I am fairly new to SSIS packages and I have created several of the packages, but was wondering if you can please give me some input on how to schedule these packages on SQL Server 2005.  Please let me know.

     

    Thanks,

    Manisha

  • April 3, 2006 at 2:51 pm

    #630530

    Follow these steps:

    1) Create a new SQL Server Agent Job

    2) On the job step tab, add a new job step.

    3) On the General page of the new job step, choose "SQL Server Integration Services Package" as the type.

    4) The page should change to a SSIS specific page, where you fill in how to find the package and lots of other SSIS configuration options.

    Aunt Kathi Data Platform MVP
    Author of Expert T-SQL Window Functions
    Simple-Talk Editor

  • April 3, 2006 at 4:20 pm

    #630537

    Thanks Kathi.  That worked.

     

  • April 4, 2006 at 2:28 am

    #630582

    I'd recommend that you don't use the SSIS job subsystem though. Read here: http://wiki.sqlis.com/default.aspx/SQLISWiki/ScheduledPackages.html

    -Jamie

     

    Jamie Thomson
    http://sqlblog.com/blogs/jamie_thomson

  • April 4, 2006 at 7:09 am

    #630648

    Thanks Jamie. 

    Will look into using OS step type.

    Thanks,

    Manisha

  • May 9, 2006 at 10:26 am

    #636810

    Hi

    I was wondering how to do this for legacy DTS, Under sql server agent > add new job - I dont have a DTS package as a job type.

    How do I do this?

    thanks

    ps - sorry if I am hijacking your thread

  • May 9, 2006 at 12:42 pm

    #636846

    Have u converted the legacy packages to the new SQL Server 2005 format? 

     

  • January 25, 2008 at 5:53 am

    #771684

    [font="Comic Sans MS"]Hi,

    I imported Sql Server 2000 DTS packages to SQL Server 2005, I Executed the imported package in BIDS and Management Studio, in both it is executing fine and giving success message,

    But when i try this packages to execute as job and click ok it is giving me following error

    "Unable to cast object of type "Microsoft.SqlServer.Management.Smo.SimpleObjectKey' to type

    'Microsoft.SqlServer.Management.Smo.Agent.JobObjectKey'. (Microsoft.SqlServer.Smo)"

    Can you please tell me how to solve this error. i am searching solution for this error since from long time, Please guide me[/font]

  • August 11, 2008 at 8:54 am

    #856132

    Scheduling legacy DTS packages on SQL 2005:

    [1] SQL Server Agent > Job > Job Step

    [2] Step type: Operating system (CmdExec)

    [3] Command: DTSRun /S "SERVERNAME" /U "USERNAME" /P "PASSWORD" /N "DTSPackageName"

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply