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
SQL Server Integration Services
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
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.
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.