![]() Inside the Data Flow Task add a Flat File Source, Script Component and OLEDB Destination.Change the datatype of the remianing Column to DT_WSTR and length = 4000.Go to the Advanced Tab, Delete all Columns except one Column.Add a Flat file connection manager, Select the text file.In the Input0_ProcessInputRow method split Column0 by delimiter, Then check if the length of array is = 17 then assign values to output columns, Else ignore the row. ![]() In mark Column0 as Input Column and Add 17 Output Columns.In the Dataflow task add a Script Component after the Flat File Source.You can do this by adding one Flat File Connection Manager add only one column with Data type DT_WSTR and a length of 4000 (assuming it's name is Column0) - So all column are considered as one big column
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |