I have a web site that I connect to every day and manually download a zip file from. This file contains a PDF and XML. I download these files to a directory and then import the XML sheet into SQL 2008 R2.
I would like a program that can connect to this web site every day and down load these files and then import into SQL.
The program needs to be able to extract the XML sheet from the ZIP file, open it and view the keys.
If the primary key exists in SQL as a table, import the other keys into columns. If it does not exist it should create the table and then import. As it finds keys though out the XML sheet, other than the primary key, that do not already have columns created, it will create the column. If the column does exist it will simply import the data.
This program also needs to be able to not import the XML if it already exists in the data base.