Post reply

Scheduling an SSIS Package

  • February 14, 2008 at 10:22 am

    #186761

    This is probably a silly question, but I used to use

    DTSRun /S "Server" /N "packagename" /W "0" /E

    to schedule dts packages in SQL 2000 within a job. How do you schedule an SSIS package in a job? Thanks for any help!

    Thanks!

  • February 18, 2008 at 10:56 pm

    #779569

    I hope it is as easy as this. I am quite not clear with your question whether you are trying to do something else or not but this is where I would start. Once you have save the package in SSIS, you will have to go to SSMS(Management Studio) and open SQL server agent there and right click on job and create new job. Then go from there. See if I have lead you to the right path here.

    [font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]

Viewing 2 posts - 1 through 1 (of 1 total)

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