hai what exactly is a unicode DB.if u need to load data files which are in english and chinese can it be loaded to a unicode DB.what additional changes needs to be made to load these Thanks

If you want to store unicode text in a SQL Server database then you will need to use datatype nvarchar http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me

SQL Server supports both Unicode and non-Unicode data types. Obviously you must use Unicode types to store Unicode data in a table, e.g, nchar, nvarchar, ntext If your file is of a suitable format and the destination table is using Unicode types, SSIS will quite happily load Unicode data.http://www.sqlis.com | http://www.konesans.com