Post reply

Flat file destination - Columns length to match with database

  • October 14, 2016 at 5:52 am

    #330926

    Dear All,

    I have a bunch of SSIS packages to be developed in 2012 where the output need to be exported to a Flat file. All extracts are having 60 to 150 columns. Creating Flat files exactly matching with data type of database is painfull since we have more number of columns. Is there a easy way to do it. Thanks in Advance!

    Chelladurai

  • October 14, 2016 at 6:11 am

    #1906544

    Creating Flat files exactly matching with data type of database

    Data in flat files has no data type, so this requirement is not possible. Perhaps you can clarify.

    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.

  • October 14, 2016 at 6:17 am

    #1906548

    In "Show Advanced Editor" of a OLE DB Source i see Input/Output Columns tab where each column's data type was listing as per the database type and length. And the Same source has been mapped to a Flat file. Don't we have an option to generate a report to find the mismatch in columns datatype/ length?

  • October 14, 2016 at 6:40 am

    #1906554

    haichells (10/14/2016)

    In "Show Advanced Editor" of a OLE DB Source i see Input/Output Columns tab where each column's data type was listing as per the database type and length. And the Same source has been mapped to a Flat file. Don't we have an option to generate a report to find the mismatch in columns datatype/ length?

    There is no 'report' option.

    Are you worried about the data types in 'External Columns' (database) being different from those in Output Columns (SSIS pipeline to output file)? If you create a new flat file connection manager and connect it to your source, the output columns will automatically be generated with the same data types.

    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.

Viewing 4 posts - 1 through 3 (of 3 total)

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