Scheduling SSIS packages

• wannabe dba

  SSCommitted

  Points: 1524

  More actions

  October 22, 2009 at 8:42 am

  #385627

  I need to create an SSIS package on a SQL SERVER Express instance.Is it possible to run the package using TSQL or schedule it to run using OSQL or cmd?

• psvirin

  Mr or Mrs. 500

  Points: 542

  More actions

  October 23, 2009 at 5:29 am

  #1069916

  http://social.msdn.microsoft.com/Forums/en-US/sqlexpress/thread/a978a46c-1f51-44e3-991b-853a237a6dea

  And execute the package using DTSRUN: http://msdn.microsoft.com/en-us/library/aa224467(SQL.80).aspx

  -------------------

  StarWind Software developer ( http://www.starwindsoftware.com )