Sunday, 3 January 2016

XML : XML to SQL with SSIS or ADO.NET

I have to import loads of little XML files to a databse. Now I'm currently doing it with an SSIS script, but it takes a lot of time (aprox 4.000 files in 30 mins).

Would it be faster if I were to make a custom program for this using ADO.NET? Because in total I'd have to transfer aprox. 500.000 files.

Thanks in advance

No comments:

Post a Comment