SQL Server Performance Forum – Threads Archive
datatype problemif 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 bloghttp://blogs.msdn.com/sqlprogrammability/archive/2006/07/07/659375.aspx 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.