January 28, 2012 at 8:52 am
Hi,
I have situation where business is constantly sending files with different COLUMN headers, I have seen following COLUMN situation:
Day 1 CSV file has : COLUMN A, COLUMN B, COLUMN C
Day 2 CSV file has : COLUMN A, COLUMN Z (no column B & C)
Day 3 CSV file has : COLUMN Z which is COLUMN A from day 1 and day 2, COLUMN F
My recommendation was to create Standard format which business should follow every time they FTP the file(s).
What do you guys think?
Thanks in advance.
January 28, 2012 at 8:57 am
assuming these files are all to be imported into the same SQL table...then I would agree that a standard format would make your life much easier...:-)
what was the response to your recommendation? 😉
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 28, 2012 at 9:12 am
I sent my recommendations yesterday so lets see. Hopefully they will accept it.
Also I was thinking of writing a C# script which will dynamically create a tmp table based on first row which is column header , but then I thought this would be a mess and lets tackle the problem at its roots
Thanks for quick response
January 28, 2012 at 9:28 am
here's a current thread that you may have an interest in
http://www.sqlservercentral.com/Forums/Topic890290-148-1.aspx
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply