Every day we need to import a standard format text file into a table. we happend to pass the name of the input text file as a part of input to the one table column. Is there is any way ?
Like "DTSinput.txt" is input file then
value for destination table column value as
DTSdestination("Sourcefile&#34 = "DTSinput.txt"
I am using transformation to modify the input data

I really appreciate any suggestion and advise.

Thanks......
Abraham Moses