Trying to make an import package generic

• David Finnegan-403714

  SSChasing Mays

  Points: 632

  More actions

  April 27, 2007 at 3:52 am

  #118434

  Hi,

   

  I was wondering if anyone might be able to point me in the right direction with an issue I have please. I've done a fair amount of work with DTS packages in the past, but this is my first SSIS package.

  I have a simple package that imports from a file to a table. I actually need import from around 200 different files into the one table but I'd rather not have to have 200 packages. The files all have the same structure so that is not an issue. What I would like to know is whether there is anyway of making this generic, so that I could either call the package with a parameter of the file name I will to import, or loop through a table of file names.

  Anyone with any ideas as to how I should handle this? Or even where I might find resource.

   

  Many thanks

  David

   

• lucky-80472

  SSCertifiable

  Points: 7793

  More actions

  April 27, 2007 at 7:20 am

  #702913

  Hello David,

  You can use For..each look task in SSIS. You can go through this link

  http://www.sqlis.com

  This is a good resource.

  Hope this helps.

  Thanks

   

  
  Lucky

• David Finnegan-403714

  SSChasing Mays

  Points: 632

  More actions

  April 30, 2007 at 10:22 am

  #703343

  Thank you so much. That is a very useful website.