SQLTeam.com | Weblogs | Forums

Daily Files Data Loading To Target


I am getting files daily into a folder.Some files contain column names, some wont.Whatever the file would be it should be mapped to required columns and load the data to target.How to do this.

Is it the same identical files that come sometimes with column and other times not? Or are these different files. If same files why donthey sometimes come with no column ??

All are same files. Dont know why some are getting with columns and some not.

Can we write script for that or we need to request them to send all files in same format

yes either ask them do send all with columns or all without columns. Who is providing these files? you cant write scripts for every possible scenario. you have to have agreed upon setup.

We are getting files from some third party