Execute script in a txt file.

• kangarolf

  Hall of Fame

  Points: 3432

  More actions

  June 29, 2003 at 10:08 am

  #106098

  Hi all,

  I have an SQL script stored in a text file that is grabbed from an external web page each day. The script creates and then populates a table.

  How can I execute this SQL script from within a DTS task...?

  The text file is in standard ansi format with comments held within #...#. It actually contains an INSERT INTO command for each row of the table. This text file method is our only option currently of copying the data.

  You can view the contents of the text returned by the URL here.

  http://www.bikerauctions.co.uk/data.txt

  thanks for any ideas.

  Rolf

  Edited by - kangarolf on 06/29/2003 10:22:23 AM

• 5409045121009-7368

  SSCoach

  Points: 15740

  More actions

  June 29, 2003 at 3:51 pm

  #463587

  Have a look at http://www.sqldts.com/