nvarchar and output to flat file.

Hello,
Im outputting a sql table to a text file. One of the columns in this table
is an nvarchar(1200) but the result in the flat file is truncated to 254
chars....how do ensure that it outputs all chars up to 1200?
thxJohn,
which approach / utility are you using to outputting the sql table to a text
file?
AMB
"John Smith" wrote:

> Hello,
> Im outputting a sql table to a text file. One of the columns in this table
> is an nvarchar(1200) but the result in the flat file is truncated to 254
> chars....how do ensure that it outputs all chars up to 1200?
> thx
>
>|||I think I gave him a suitable answer on a separate post.
Barrysql

numeric data types

Hi,

I have a lot of decimals in the flat files. So far the largest numbers map to a numeric(18,6).

My question is, is DT_NUMERIC the correct datatype for this data? In which case, what size do I need to set it? Right now it's 18. Couldn't find much info on this.

Thanks

DT_NUMERIC is correct. For the example you've given, set precision to 18 and scale to 6.|||SSIS data types: http://msdn2.microsoft.com/en-us/library/ms141036.aspx|||Is there a trick to doing this? I tried 18,6 and it said it was invalid.|||

More precisely, the error is:

18,6 is not a valid value for Int32.

I have DT_NUMERIC selected as data type.

|||

Have you set 18 in the precision box and 6 in the scale box or "18,6" in a single box? 18 and 6 are separate attributes.

Thanks.

sql