T-SQL overlap with VBScript

• Gabriel P

  SSCarpal Tunnel

  Points: 4289

  More actions

  April 28, 2008 at 10:58 am

  #184923

  I use VBScript to manage files (such as backups, archives, etc) through SQL Server Jobs using the ActiveX option. I am wondering if anyone knows how I can pass T-SQL variables, or table data into the VBScript to access. I need this for file naming purposes.

  Thanks

• Gabriel P

  SSCarpal Tunnel

  Points: 4289

  More actions

  April 29, 2008 at 8:18 am

  #808382

  I figured it out. I created a ADODB object in VB and created a connection to the database.