How to read multiple text files into MS SQL Server using C++?
I am using MS SQL Server 2008 Express and Visual C++ 2008 Express.
I have googled around the net and found that MS SQL Server 2008 Express does not have SSIS for me to do this. I have also found out that I could use ODBC C++ wrappers (like http://www.alhem.net/project/odbcwrapped/index.html , which I am not sure if this is workable for MS SQL Server, as the website has sections for mySQL and SQLite only). If it can't, is there any other ODBC C++ wrappers I could use for MS SQL Server 2008 Express.
Or, would there be another easier way for me to read multiple text files into MS SQL Server using C++, apart from using ODBC C++ wrappers? It would be desirable to use C++ although I am aware that this could be done using T-SQL.
Pardon me if I have anything incorrect above as I am not from a computing background. Any help would be much appreciated!
I have googled around the net and found that MS SQL Server 2008 Express does not have SSIS for me to do this. I have also found out that I could use ODBC C++ wrappers (like http://www.alhem.net/project/odbcwrapped/index.html , which I am not sure if this is workable for MS SQL Server, as the website has sections for mySQL and SQLite only). If it can't, is there any other ODBC C++ wrappers I could use for MS SQL Server 2008 Express.
Or, would there be another easier way for me to read multiple text files into MS SQL Server using C++, apart from using ODBC C++ wrappers? It would be desirable to use C++ although I am aware that this could be done using T-SQL.
Pardon me if I have anything incorrect above as I am not from a computing background. Any help would be much appreciated!
Topic archived. No new replies allowed.