Flat files data types

• patla4u

  SSCrazy

  Points: 2103

  More actions

  May 19, 2011 at 8:32 pm

  #238538

  Hello

  can i know which one is right one??

  Rightnow In Flat file source... I did my all column fields data types as string.

  I have to change the data types respective my column data or not??

  I have 200 columns.(some of the fields are numeric) So Need to change data types in flat filesconnection manager or keep all columns data types as string in flat file connection manager????

  Thanks

  L

• Mahesh Bote

  SSCrazy Eights

  Points: 9107

  More actions

  May 20, 2011 at 8:03 am

  #1327697

  [font="Verdana"]Use the Advanced Editor to explore each column type so that you know where such conversions occur.

  -- Mahesh[/font]

  MH-09-AM-8694