I have 500 files and the Column headers are in a separate file I need to transfer the data in all those files into a single table..how can i do it.. how can i reference the column headers of files while transferring data.
If all the tables data format is same, you can write an batch file using bcp to import all the files or you can write an SSIS package and execute the same in a loop using some frot end
Hi Thanks a lot for your reply...If the format is not the same that is if the order of the columns is different then how can we reference the file with column headers for each file. I want to automate this i dont want to do it manually.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply