Hi, When i tried to transfer the data betweeen two tables using transfersqlserverobjects task, where table has one column varchar data type..i got one error .. [Transfer SQL Server Objects Task] Error: Execution failed with the following error: "ERROR : errorCode=-1071636471 description=SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Invalid character value for cast specification". helpFile=dtsmsg100.rll helpContext=0 idofInterfaceWithError={C81DFC5A-3B22-4DA3-BD3B-10BF861A7F9C}". Why i am getting this error ...Is SSIS supports varchar??SUNIL PARISI

nope i dont think so ..... You have use data conversion transformation to do this.. Convert it to Text -> String and now it supports. Mark as answer if the post help you... Regards, Indraneel A

Hi SUNIL PARISI, SSIS data type DT_STR is mapping Varchar data type in SQL Server, for more information about SSIS Data Types, please see: http://msdn.microsoft.com/en-us/library/ms141036.aspx And here is a similar thread, please refer to: http://www.sqlservercentral.com/Forums/Topic961098-148-1.aspx#bm962279 Thanks, Eileen

Hi SUNIL PARISI, SSIS data type DT_STR is mapping Varchar data type in SQL Server, for more information about SSIS Data Types, please see: http://msdn.microsoft.com/en-us/library/ms141036.aspx And here is a similar thread, please refer to: http://www.sqlservercentral.com/Forums/Topic961098-148-1.aspx#bm962279 Thanks, Eileen