Using Bulk Insert with for each loop

• Debra True

  SSC Veteran

  Points: 282

  More actions

  March 1, 2012 at 8:40 am

  #253982

  I'm trying to set up a Bulk insert with a for each loop in an SSIS routine and am having trouble with this. I want to pick up a number of .csv files from a folder, however, the file names will always be unique. How do I set up the Connection for the Source Connection for the Bulk Insert task? If I specify a filename, it won't be correct the next time that the package runs.

• rgtft

  Hall of Fame

  Points: 3518

  More actions

  March 1, 2012 at 8:50 am

  #1453694

  Take a look at this:

  http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/67871/

  That should give you a pretty good idea of what you want.

  HTH,

  Rob

• Yadava Shettigar

  SSC-Addicted

  Points: 400

  More actions

  March 7, 2012 at 4:23 am

  #1455870

  Use DataFlow task instead of Bulkinsert as posted by rgtft