none
SSIS flat file loading - data type conversion RRS feed

  • Question

  • It seems I can do the type conversion in two place:
    
    1. The advanced editor for flat file source => Input and output roperties. And I can set the output columns data type properties there.
    
    2. Using a Data conversion box in Data flow transformation.
    
    Any difference between these two? Which one should be used?
    Tuesday, April 24, 2007 6:37 PM

Answers

  •  Nick Wang wrote:
    It seems I can do the type conversion in two place:
    
    1. The advanced editor for flat file source => Input and output roperties. And I can set the output columns data type properties there.
    
    2. Using a Data conversion box in Data flow transformation.
    
    Any difference between these two? Which one should be used?


    Easy!  The flat file source is designed to illustrate what the data types are in the flat file source.  Generally they are character strings, but could be numbers (if you know the data is valid 100%), etc...  Data CONVERSION should happen outside of the source components in a derived column or a data conversion component.  My preference has always been to use a derived column to cast my fields.
    Tuesday, April 24, 2007 6:46 PM
    Moderator