0

I have a ssis package which gets data from sql and dumps to CSV file. There are half a million of rows and almost 100 columns and when i dump the data to Flat file destination, some of the column values gets concatenated to the next column value as it has same text deliminator as flat file connection.

For eg if the source data is like

ID    NAME    HEIGHT    ADDRESS  AGE
01    DEB      5.6"      xyz"9    29

Destination is coming like

ID    NAME       HEIGHT         ADDRESS  AGE
01    DEB      5.6",xyz"9          29

The age comes to address column in csv file.

How to avoid it as i am not sure with how many records the issue might be?

  • Text del is "
  • Column del is ,
Improve this question
7
Related questions
0
SSIS Expression in a Derived Column Transformation to replace a carriage return with nothing
1
SSIS Derived Column - Parse Text between break returns
1
SSIS Derived Column - Text in Numeric Field is not converting
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.