May 26, 2009 at 10:28 pm
Hey Guys,
I need suggestion on something that I am working on. Any sample Proc with something similar will be of big help as well..
Datadictionary with column info and data file will be dropped in a location.... at onetime there can be multiple datadictionary and corresponding data files in that location... what I need to do is take the datadictionary, create tables based on that and load the data files in the corresponding tables which will be further used to create reports...
What I am thinking is...
1. Create a logging table and have a flag that says loaded or not
2. Log the datadictionary and data file in that table, one record for each set of file
3. Create table to load datadictionary file
4. Create table using the records in data dictionary table
5. Create format file using the datadictionary table for bulk inserting the data file
6. Load the datafile in the table and update the flag in logging table
Datadictionary is a comma separated text file with column name, data type and field length.... each files can have different number of fields
Please let me know if I am in the rite path and if anyone... any suggestion is appreciated.
Thanks
May 26, 2009 at 11:33 pm
bumping this up.. thnks guys.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply