DTS Help

• rs

  SSCrazy

  Points: 2819

  More actions

  April 30, 2004 at 3:25 pm

  #161315

  Hi,

  We download 20 flat files from FTP to 20 different tables, for tis i have to create 20 different DTS packges to do that,

  Is there any way to do this in one DTS.

  Thanks for your help.

• May 3, 2004 at 8:00 am

  This was removed by the editor as SPAM

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  May 3, 2004 at 9:38 am

  #505017

  Yes.  Just put the steps for each file into a single package using DTS Designer.

  Provide more details for more detailed advice.

   

  Greg

   

  Greg

• jfb

  SSCrazy

  Points: 2469

  More actions

  May 5, 2004 at 8:01 am

  #505311

  You probably can create a loop using Bulk insert task. To have an idea in how to perform a loop, check this link:

  http://www.sqldts.com/?246

  JFB