Flatfile output truncating after 255 characters

Hi,

iam bringing an output in flatfile which is truncating after 255 characters,some of the data is vanishing because of this.can anyone pls help.

pls advice.

Regards,

sg

Check the field definitions in the flat file connection.|||

Hi phil,

Iam running the combined query in Management studio and finding that the result is truncated.

some rows are exceeding 255 characters and the data after these 255 characters are getting truncated.

What should be done for this?

Regards,

sg.

|||

swan_sgp wrote:

Hi phil,

Iam running the combined query in Management studio and finding that the result is truncated.

some rows are exceeding 255 characters and the data after these 255 characters are getting truncated.

What should be done for this?

Regards,

sg.

I don't think the results are getting truncated. If you are expecting more characters, try exporting the results to a file and look there. It may be Management Studio's behavior to only show 255 characters in the result list.|||Also, look in Management Studio... Tools, Options, Query Results, SQL Server, Results to Grid and Results to Text. There are settings in each of those that specify how many characters are returned.|||

Hi phil,

I tried all the ways you have mentioned,you were correct that management studio is showing 255 characters and truncating all characters after that,

i ran the package,and some of the table-column's that were not shown in management studio are shown when a flatfile is generated but one table is not generating though,unable to solve even after recoding repeatedly.

only one table is not coming in flatfile fully.

pls advice.

Regards,

sg.

|||Redirect errors and inspect them. Or ensure that your flat file has been defined correctly. Embedded NULLs inside strings will terminate them, so for example:

If you have the string, "THIS STRING CONTAINS A [NULL] VALUE", the only thing that SSIS will see will be "THIS STRING CONTAINS A ".

Just a thought.