DTS package on Yukon accessing SQL Server 2000 box?

• Robert Lomax

  Ten Centuries

  Points: 1334

  More actions

  August 30, 2005 at 4:01 pm

  #165866

  Quick Yukon question:  If we build a Integration Services (DTS) package on Yukon will it push data to a SQL Server 2000 box?

  Thanks,

  Jeff Lomax

• Jamie Thomson

  SSChampion

  Points: 11805

  More actions

  August 31, 2005 at 2:33 am

  #586379

  Yes. SSIS can push to any data sink that is supported by OLE DB (of which SQL2000 is one of course).

  -Jamie

   

  Jamie Thomson
  http://sqlblog.com/blogs/jamie_thomson