dts - Execute SQL Task

• ubaert

  SSC Veteran

  Points: 286

  More actions

  November 18, 2003 at 1:07 pm

  #160220

  hi

  how can i import with dts a .sql file which contains sql statements like this:

  delete from tab_cdtrack where cd_nummer=102018 and trackszucd=1

  insert into tab_cdtrack (cd_nummer,trackszucd,tracknummer,tracktitel,dauer) values (102018,1,1,'kindgott',4.19)

  i tried to do a dts with a "Execute SQL Task", but the problem i have, is that everyday i have a .sql file to import. but the "Execute SQL Task" did not refresh the source file to import.

  could anyone help me and shows how to import such a file with dts.

  thanx

  urs

• David Burrows

  SSC Guru

  Points: 65142

  More actions

  November 19, 2003 at 7:05 am

  #482624

  Duplicate post.

  Edited by - davidburrows on 11/19/2003 07:07:07 AM

  Far away is close at hand in the images of elsewhere.
  Anon.

• ubaert

  SSC Veteran

  Points: 286

  More actions

  November 19, 2003 at 7:10 am

  #482626

  hi david

  yes why not. do you have an example script to execute this statements in this file.

  thanks

  urs

• David Burrows

  SSC Guru

  Points: 65142

  More actions

  November 19, 2003 at 7:25 am

  #482631

  Posted answer in other thread

  http://www.sqlservercentral.com/forum/post.asp?method=Reply&TOPIC_ID=18337&FORUM_ID=19&CAT_ID=3&Forum_Title=Data+Transformation+Services+%28DTS%29&Topic_Title=How+to+import+a+%2Esql+file+with+DTS

  Far away is close at hand in the images of elsewhere.
  Anon.