June 23, 2006 at 8:57 am
Hi
I am loading a text file into my DB tables. This part is easy for me through a SP but the problem is how can i pick up the right file to load coz every time the file name will be changing.
Here the load is done by the user its not automated. when the user clicks on load file the SP which fires the load process.
Is there a way like...If the user know the file name to load, he will be sending the file name to the SP(load process), then the SP picks up the given file name. How can i do this?
June 26, 2006 at 8:00 am
This was removed by the editor as SPAM
June 27, 2006 at 2:32 am
dear,
u can read the file name and date from the disk by using xp_cmdshell.
After u get the last file name of the day upload the data into using BCP or what ever methord u want to use.
from
killer
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply