Transfer Data

• Jr.DBA

  Old Hand

  Points: 339

  More actions

  July 16, 2008 at 11:22 am

  #381728

  Hi Everybody,

  Can anybody give me idea of how we can do the following-

  Integrate data from various sources to centralized location i.e., Mart Database (FTP, EXCEL, Access, SQL server 2000, ORACLE etc --> SQL server 2005)

  Thankss

• Possinator

  Hall of Fame

  Points: 3422

  More actions

  July 16, 2008 at 12:25 pm

  #843996

  SSIS!

  See article listed on SSC Home page - "5 free hours of training"

  http://www.sqlservercentral.com/articles/Training/63567/

  [font="Courier New"]Looking for a Deadlock Victim Support Group..[/font]