Scheduling an SSIS Package

• sindhigrl

  Default port

  Points: 1448

  More actions

  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!

• SQLdevotee

  SSCarpal Tunnel

  Points: 4820

  More actions

  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]