SQLTeam.com | Weblogs | Forums

Data Conversion task error to Flat File


I am pulling data from external source to staging table in our Data Warehouse, it was working perfectly before suddenly broken due to data issue. The error is happening in a simple data flow task

ADO NET data source -> Data Conversion task -> OLE DB destination.

Getting error in Data Conversion task for a particular column, when Redirect Row is configured for all the columns and mapped to Flat File. Task is getting completed now and shows one row to the Excel file. But when opened there is NO DATA in the excel file.

Not sure what I am missing. Any help or suggestion will be great.

thanks in advance.