Can not put data from file to DB

Question

You can see the picture, COMM_TTL size still shows 50 when I modify it to 500. This may cause the fail result when data lengh in this column bigger than 50.

Answer 1

Hi 16625862,
Welcome to Microsoft Q&A.
What the data source are you using?
If you are using Flat File Source, please try to go to Choose a Data Source tab-> select Advanced in the left pane. Then select the column COMM_TTL and set OutputColumnWidth to larger value.
For example:

Best Regards,
Amelia

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

OK， I will try it, thank you for your reply!

Answer 3

Thanks! It finally works! Besides, it need Administrator Permission to execute.

Answer 4

However, I think this GUI still has some problems in that Column mapping page. If you only modify type & size in that page, it doesn't work.