Hi , i need export data from text file to database( sql server 2008).But i need some transformation in the data . The lines in the text field is separated by a semicolon(“;”), some data in each line, i need query( whith data from text file) and get data from the database and transform some data in the text file. I need input transformed data in the database.
HOW IS THE BEST WAY TO DO THIS?
Hello,
for reading data from a text file use UniversalDataReader, for reading data from database use DBInputTable, to input data to MSSQL database use MSSQLDataWriter or DBOutputTable.