Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
GhantaBro
Posting Yak Master
215 Posts |
 Posted - 2009-05-27 : 00:30:35
|
| 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 not2. Log the datadictionary and data file in that table, one record for each set of file3. Create table to load datadictionary file4. Create table using the records in data dictionary table5. Create format file using the datadictionary table for bulk inserting the data file6. Load the datafile in the table and update the flag in logging tableDatadictionary is a comma separated text file with column name, data type and field length.... each files can have different number of fieldsPlease let me know if I am in the rite path and if anyone... any suggestion is appreciated.Thanks |
|
|
GhantaBro
Posting Yak Master
215 Posts |
Posted - 2009-05-27 : 01:41:22
|
| bumping this thread. Thanks guys. |
 |
|
|
|
|
|
Create table using datadic dynamically