Hi friends i have some of the doubts while picking the data fro the excel sheet. some time the excel sheet provides by some user to import data is very much colored and designed by him to distinguish rows by him or her but when we try to put data from that excel sheet we get the errors or warnings at the destination like given below: Error 1 Validation error. Data Flow Task OLE DB Destination [22]: Columns "Copy of AGENCYID" and "AGENCYID" cannot convert between unicode and non-unicode string data types. Package.dtsx 0 0 So would you guys tell me how to make changes in the excel sheet to make that more basic one. Thanks In advance Fighttillend_DBA/DEV

use a Data Conversion Transformation before destination to convert to appropriate type.http://www.rad.pasfu.com

reza i used it but now i am gettin a package validation error i mean the package does not run and an error pop up called the 'package validation error' which says the following: Error at data Flow Task[ SSIS. Pipeline]: " Component : "Excel Source"(39) failed VAlidation and returned validation status "VS_NEEDSNEWMETADATA" What do you think is the reason??????Fighttillend_DBA/DEV

You can set DelayValidation=TRUE on the object that is failing validation http://uk.linkedin.com/in/ramjaddu

after putting the data conversion transformation you should double click on destination to auto input new columnshttp://www.rad.pasfu.com