create a SSIS package that loads XML files

Hello There, I have gone through your requirement. I understood that you wan a SSIS package which will load all available XML files from a folder and load to SQL server. I have already developed the SSIS package which reads data from XML files and load into SQl server tables. Please see attached file (In your google drive). I need below clarification: 1. What to do after processing files? Do you want to archive it.? 2. If duplicate xml comes, do you want to reject? 3. If any bad XML comes, do you wan to reject? 4. Any alert email do you want for above rejection and do you wan to continue process even if wrong file schema? 5. The table structure mentioned in xlsx file has ID column. Is it auto identity field? 6. Final tables have fields which come from different base table. Do you have ready mapping document? I mean which field is coming from which base table. Please ping me to discuss about this in more details. Please note, I have uploaded few xml and zip file to your google drive. About me, I am DWH, ETL and data analyst guy having 13 years of experience in these fields for several MNC (Siemens, CTS, Wipro and TATA). Waiting for your response. Regards, Purna.

I am a database / Microsoft Business Intelligence architect and have more than 14 years of experience in IT industry. FYI...SSIS is my primary skill and currently playing trainer role in this technology in my current organization. Let me know if you want to discuss further. My Technical background • A goal-oriented professional with more than 14 years of experience in IT Database Management and Project Management specifically Airlines, Telecommunications and Health care domain • Having good amount of practical exposure on AngularJS, MVC, Javascript, ASP.Net with C#, VB.Net language and executed multiple projects independently. • Possess expertise in Data Warehouse/Data mart concepts, data modeling for OLAP & OLTP systems from design and analysis to implementation including the conceptual, logical and physical data models • Experience in relational and dimensional data modeling using ERWIN, understanding of Ralph Kimball and bill Inmon methodology for dimensional modeling, star and snowflake schemas • Having depth knowledge of large database design techniques; experience in data analysis, data cleansing, and data transformation and migration using ETL tools;

Hi i am expertise in ssis with any data source you can check my reviews on ssis i will finish ur requirment if u are interested ping me .

Hi there, I am interested in the project. Can you please provide some sample xml files for review? The google drive location you have provided is empty. Thank you.

My technical solution for this Project would be to: - Create database structure with requested datatype into SQL server - Produce Create table scripts for deployment. - Create SSIS package that would map to one file and generate the required .xsd file. - SSIS package will be created with sufficient Variables and project parameters to enable easy deployment. - Using .Xsd files map the xml files to data base tables. - execute and test the SSIS package for single file, one success move to further project steps. - Enhance the SSIS package to load the xml file using for each loop container. - Add file watcher to watch for any files being added in the folder to enable the routine execution of the package. - If need create agent job script to schedule the package. Deployment of this project would be simple as I will produce database scripts, ssis project deployment file and SQL agent job script file (If needed). My key assumption in this project is all the xml input files that are uploaded on the web page follows the same template. This Project can further be enhanced to use REST API to automatically download all the xml files from any website and load into database.

I have 13 years experience in this field. I had worked many ETL projects that involved the transformation including XML files. So i think, i can complete this task on time.

I have been working with SSIS before it was called SSIS. I have built production level SSIS packages in Finance Firms. I am good in communication and also delivering high quality work. I currently work with SSIS in my daily job and comfortable with delivering within the due date.

I gurantee that i would be able to deliver the package in no more than 3 days. I am currently dealing with similar kind of project in my organisation. it will be an optimized solution. Ping me any time.

I am MS SQL expert and primarily into database designing, development and Business intelligence. As mentioned in project details i sure i can comfortably design a ssis package which takes folder path as input and loaded data from those files into SQL Server tables.