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 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
http://www.SQL-Server-Performance.Com
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.

---

]]>