Reading filesystem and populating the table

• shashi_1409

  SSCommitted

  Points: 1599

  More actions

  October 13, 2010 at 6:47 pm

  #241717

  Hi I am trying to create a SSIS package that read the filesystem and populates a table with the filenames and file location path, can anyone please suggest me some ideas or any articles accomplishing this task.

  Thanks

  Shashi

• Shanalise

  Hall of Fame

  Points: 3188

  More actions

  October 13, 2010 at 11:14 pm

  #1236629

  Try this

  http://www.mssqltips.com/tip.asp?tip=1641

  http://www.kimballgroup.com

• shashi_1409

  SSCommitted

  Points: 1599

  More actions

  October 14, 2010 at 10:19 am

  #1237013

  Thanks for the reply Mushana!!

  Actaully I was given wrong requirement yesterday...today they came to me and told that they have images stored on the filrsystem and they want me to design a SSIS package that reads the filesystem and populate a table with filename( image name) and the actual image.

  So could you please guide me in this task.

  Thanks

  Shashi