SQL Server Performance Forum – Threads Archive
How to Maintain dataTypes in IntegrationHow to maintain datatypes when you are getting data from flat files sources and dumping the data into a table in sql server. satish.e
Probably you would like to cast it to appropriate type before inserting to table which is conventional way of mainitaining datatypes. Cheers
You could take help of BCP too in this case and make use of FORMATFILE option, other follow as suggested above or input the rows to a temp.table and perform the relevant computations – provided the source file is not changed. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.