This needs to be done in an application (i am using VB.net) where in the user can upload the file which gets put in the database. Since I am new to VB.net, I wasn't sure that we could call SSIS package from VB. If possible, could you tell me how to do this or point me to any resources which would help?
Other than that, there is not really simple way to do this in pure .Net. I would probably start out by using a text driver to create a connection to your text files, reading the data into a DataSet. Next, loop through the DataSet and DataTables and execute SqlCommands against your DataRows while validating your data.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.