Can not execute a bulk insert on a remote computer

• drathman06

  Grasshopper

  Points: 22

  More actions

  December 7, 2010 at 3:25 pm

  #229491

  I am trying to use SSIS to create a package which will allow me to transfer a local Excel file to a sql server database on a remote server.

  I am doing this because I have a dozen files to eventually transfer. The old DTS (Import/Export) works great, I just want to modify several variables and keep running a single SSIS Package.

• ssisdiva

  SSC Enthusiast

  Points: 137

  More actions

  December 15, 2010 at 7:00 am

  #1262817

  Hi

  You can use a for each loop container to loop through the files in a folder.

  Everytime one single file is taken based on the enumerator configuration of the for each loop and the data is written to the sql server.

  Could you please elaborate on the part where you want to change variables. What exactly are you talking about here.