refresh File content as SQL-Source type - SQL Task (SSIS) - problem

• Amann Ottmar

  Old Hand

  Points: 339

  More actions

  May 1, 2006 at 11:47 pm

  #112878

  Hello,

  I'm using SQL-Code in source files like file.sql to manage my ETL-processes. Setting up SQLSourceType and SQLStatement to this file.

  The problem is, that SSIS just accesses the code only by creating that connection. If I modify the sql-file by using an external editor, SSIS doesen't take the changes!

  Is there a possibility to say SSIS to refresh the file content before running the script?

  Thanx,

  Ottmar

• May 4, 2006 at 8:00 am

  This was removed by the editor as SPAM

• Peter Schott

  SSCrazy Eights

  Points: 9675

  More actions

  May 4, 2006 at 2:43 pm

  #636102

  Is DelayValidation set for that component? If not, that may be worth trying.