export a table

I tried to write a package for transferring SQL 2005 table to a flat file in
Visual Studio. However I got the unicode error message at the destination
even though I only use English. Does anyone has idea? Thanks.
The message is as following :
Error: Column "Status" cannot convert between unicode and non-unicode
string data types.
Error: ... ( The same message with all the column in the source table)
Please help. Thanks." 00ScarlettJohnson" <EE@.yahoo.com> wrote in message
news:ekXwbLCcHHA.2552@.TK2MSFTNGP06.phx.gbl...
>I tried to write a package for transferring SQL 2005 table to a flat file
>in
> Visual Studio. However I got the unicode error message at the destination
> even though I only use English. Does anyone has idea? Thanks.
>
Sounds like source database may be using nvarchar for its columns?
Probably need to cast them (and possibly lose unicode data, but sounds like
you have none) before you export them.

> The message is as following :
> Error: Column "Status" cannot convert between unicode and non-unicode
> string data types.
> Error: ... ( The same message with all the column in the source table)
> Please help. Thanks.
>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||I solved the problem by adding data conversion task between source and
destination. But this does only for append. How can I do it for overwrite?
Thanks.
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:OVMWf4OcHHA.4260@.TK2MSFTNGP02.phx.gbl...
>" 00ScarlettJohnson" <EE@.yahoo.com> wrote in message
>news:ekXwbLCcHHA.2552@.TK2MSFTNGP06.phx.gbl...
> Sounds like source database may be using nvarchar for its columns?
> Probably need to cast them (and possibly lose unicode data, but sounds
> like you have none) before you export them.
>
>
> --
> Greg Moore
> SQL Server DBA Consulting Remote and Onsite available!
> Email: sql (at) greenms.com
> http://www.greenms.com/sqlserver.html
>|||Can anyone please help? Is this the correct group I post this kind of
question? Thanks.
" 00ScarlettJohnson" <EE@.yahoo.com> wrote in message
news:OgwAMpQcHHA.588@.TK2MSFTNGP06.phx.gbl...
>I solved the problem by adding data conversion task between source and
>destination. But this does only for append. How can I do it for overwrite?
>Thanks.
>
> "Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in
> message news:OVMWf4OcHHA.4260@.TK2MSFTNGP02.phx.gbl...
>|||Hello 00ScarlettJohnson,

> Can anyone please help? Is this the correct group I post this kind of
> question? Thanks.
I'll try; No, please use "microsoft.public.sqlserver.integrationsvcs" and
I'm wondering if you mean by "overwrite" that you want it to have the data-c
onverted
columns have the same names, yes you can do that but note you will still
be generating a new lineage for the converted column and all of the overhead
associated with that.
Thanks!
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/