swan_sgp


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




Re: Flatfile output truncating after 255 characters

Phil Brammer


Check the field definitions in the flat file connection.






Re: Flatfile output truncating after 255 characters

swan_sgp

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.






Re: Flatfile output truncating after 255 characters

Phil Brammer

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.





Re: Flatfile output truncating after 255 characters

Phil Brammer

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.





Re: Flatfile output truncating after 255 characters

swan_sgp

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.





Re: Flatfile output truncating after 255 characters

Phil Brammer

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.