Post reply

Extracting CSV files, specify datatypes for columns in source or set as STR?

  • December 14, 2010 at 12:32 pm

    #148015

    I'm working on extracting and loading numerous CSV files from excel. I'm wondering if its better to set the data types for all columns to STR (in flat file source task) and run the Data Conversion Task prior to SQL Server Destination Task.

    OR

    In Flat File Source task, Advanced Editor, Output columns, set the data types there? Or maybe it doesn't matter?

  • December 14, 2010 at 2:05 pm

    #1262497

    Running all the columns through a DCNV and defining their data types is generally a good idea in this case. It most likely will save you problems later on in the data flow.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply