Hitting ODBC-system DSN from Stored Procedure

• edstalke

  SSC Enthusiast

  Points: 142

  More actions

  May 13, 2008 at 8:52 am

  #93308

  I have an transactional application that was built long before SQL server, the only way I know to retrieve data from this app is ODBC - System DNS. Currently, I can retrieve using SSIS and msQuery. I would like to skip SSIS and have everything inside Stored procedure. Can I retrieve data using ODBC-System DSN inside of Stored procedure?

• GSquared

  SSC Guru

  Points: 260824

  More actions

  May 13, 2008 at 3:11 pm

  #814826

  Yes. You can either set up a linked server, or use openrowset.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon