Can DTS\VBScript access a SQL Database?

• Barkingdog

  SSCoach

  Points: 18670

  More actions

  August 31, 2001 at 3:18 pm

  #157811

  I wrote a well-tested DTS package that uses a VBScript. But the boss wants a change that would force me to, essentially, access a SQL server 7 database table from my VBScript. Can this be done?

  TIA,

  Bill Salkin

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  August 31, 2001 at 6:31 pm

  #417914

  I dont see why not. Pretty common to use VBS to access db's/tables in web pages. Should it be done is another question!

  Andy

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter

• Sean Burke

  SSCommitted

  Points: 1504

  More actions

  August 31, 2001 at 8:00 pm

  #417918

  It can be done, but is there a specific concern you have for the change?