Some doubts about picking data from excel sheet with SSIS RRS feed

  • Question

  • 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

    Monday, May 9, 2011 7:21 PM


All replies

  • use a Data Conversion Transformation before destination to convert to appropriate type.
    Monday, May 9, 2011 7:28 PM
  • 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??????

    Monday, May 9, 2011 7:48 PM
  • You can set DelayValidation=TRUE on the object that is failing validation
    Monday, May 9, 2011 7:51 PM
  • after putting the data conversion transformation you should double click on destination to auto input new columns
    • Marked as answer by Jerry Nee Sunday, May 15, 2011 4:38 AM
    Monday, May 9, 2011 7:56 PM