SQL Server Performance

How to Maintain dataTypes in Integration

Discussion in 'SQL Server DTS-Related Questions' started by edarasatish, May 9, 2007.

  1. edarasatish New Member

    How to maintain datatypes when you are getting data from flat files sources and dumping the data into a table in sql server.

  2. techbabu303 New Member

    Hi Satish,

    Probably you would like to cast it to appropriate type before inserting to table which is conventional way of mainitaining datatypes.

  3. satya Moderator

    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.

Share This Page