Hey Guys,
Need your suggestion on this. Format file and file will be ftped to a certain location on random times. I need to create a SP to pick the format files and create tables based on that format files and data send with format files. I guess file names and format files should be same with different extension and I can use the file name as the table name. I need suggestion on couple of things...
1. How can I use the format file and create tables based on that and do a bulk insert? 2. How can I run this Proc every 10 minutes and run it multiple times so that multiple files are loaded at once?
I will be using separate SP to get files in the directory and insert the list in a table with couple of flags so that the files already in process is not touched again for load part... Any suggestion is appreciated.
Thanks... I may not be that clear about what I am asking... I will add more. Thanks!