Hello, I am new to the SQL environment and need to use bulk import to insert about 600-700 new xml files a day into SQL Server 2000. My VB .NET code is working fine to handle this, I just need some help with the schema work. If someone could provide an example of how to update multiple unrelated tables in a single database, I would be very appreciative. I can do a single table with no problem, its just when I try to reference a second table that I have problems.
This is just a basic, but I need something to go off of to set up a SQL Table relation from the Elements/Attributes to map them to the right table columns. My actual file is dynamically generated and may have upto 11 or 12 tables, or as few as 2 or 3. Any help or further explination would be most helpful.