datatype problem | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

datatype problem

if the incoming data is a flat file source and destination is to sql server 2005 database.
The column data from flat file is uniccode string and if it has to transfer to a column of datatype int in the database.
How can it be done????
because at my final destination it shows error.

See this blog on unicode conversion gotchas. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.