insert one column data from a "source text file" and "source file name" into a table

• bmr270

  Default port

  Points: 1477

  More actions

  August 28, 2008 at 11:33 am

  #197595

  Hi,

  I have to insert one column data from a "source text file" and "source file name" into a table.

  Example:

  File Names in a directory(c:\SourceFilesDirectody\):

  SourceFile1.txt

  SourceFile2.txt

  SourceFile3.txt

  File Structure for SourceFile1.txt:::::

  Snum,Sname

  111,xyz

  File Structure for SourceFile2.txt:::::

  Snum,Sname

  222,abc

  File Structure for SourceFile3.txt:::::

  Snum,Sname

  333,cdf

  Table structure in Database (Table name TblFileName)

  snum int not null

  FileName char(100) not null

  AFTER EXECUTION OF THE PACKAGE

  Output of the table is:::::

  selet * from TblFileName

  111 SourceFile1

  222 SourceFile2

  333 SourceFile3

  Thanks,

  BMR

  🙂