Creating a job using existing package

• elchuru

  Default port

  Points: 1435

  More actions

  December 14, 2009 at 12:26 am

  #137637

  Hi all,

  I am new to SSIS environment.I want to transfer data from excel to sql server for every 5mins using sql server job. please tell me a job which executes a package for every 5mins.

  Thanks in advance

• Henrico Bekker

  One Orange Chip

  Points: 27652

  More actions

  December 14, 2009 at 12:59 am

  #1091779

  http://www.sqlservercentral.com/tags/Excel/Extract,+Transform,+Load+(ETL)/Integration+Services+(SSIS)/

  http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1282913,00.html

  http://msdn.microsoft.com/en-us/library/ms141026.aspx

  Your question cannot be answered in one sentence..except one long sentence.

  Read up on some of the above links..

  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle