Parameters in query database

jfcastroc

• October 13, 2011 00:00

• Answered

Follow

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?

• 

  avackova

  • October 14, 2011 07:57

  0

  Comment actions Permalink

  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.

Please sign in to leave a comment.