Thanks a lot Luis.

I have tried this query and added several new description ( just to see if the header will be dynamic 🙂 )

and it works!

😀 yes, I have realized that it is really ridiculous, and a customer will not give a lot of time to read everything at the column 😉 ...

Hi,

Is there a way to adjust the value for that?

Let's say I need to increase it up to 100,000?

Thanks a lot.

Yes, the string is inserted at the column correctly, therefore the value is not truncated the moment

I insert it to column. However, when I select the column (select...

yes that's right 🙂

Hi Koen,

Good day!

I have seen why it doesn't show the columns at the OLE DB.

It is because the stored procedure being called/executed by OLE DB source

object...

I have the same error for my SSIS package using the File System Task.

It returns this error :

[File System Task] Error: An error occurred with the following error...

Many Thanks, Ron.

This will be a great help for me to understand each objects.