Home Forums Data Warehousing Integration Services Automatically Mapping Flat File Sources Data types to Destination RE: Automatically Mapping Flat File Sources Data types to Destination

  • Ryan1 (7/31/2013)


    Is there anyway to automatically map a flat file sources data types to the ole DB destinations data types? I'd rather not have to go through a data conversion for every source/destination match

    -choosing the 'suggest data types' in the flat file sources options isn't changing them correctly.

    Thanks

    No one mentioned the Import Wizard as a possible solution because of the way you phrased this question. If you had said something like this:

    Is there any way to automatically map a flat file source's columns to the OLEDB destination table's columns?

    Someone would have suggested the Import Wizard fairly promptly. 'Data types' refers to the definitions of the columns involved (string, int, date etc.) and so your request completely puzzled me!

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.