locked
Is SSIS supports varchar data ?? RRS feed

  • Question

  • 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 ss


    SUNIL PARISI

    Thursday, February 16, 2012 10:38 AM

All replies

  • 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

    • Merged by SSISJoostMVP Wednesday, June 19, 2013 6:22 PM duplicate post in other forum
    Thursday, February 16, 2012 11:37 AM
  • Why are you using transfersqlserverobjects task for this case?

    Is data all you wish to transfer?


    Please vote as helpful or mark as answer, if it helps
    Cheers, Raunak | t: @raunakjhawar | My Blog

    Thursday, February 16, 2012 11:43 AM
  • 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


    • Edited by Achilles33 Thursday, February 16, 2012 12:02 PM
    Thursday, February 16, 2012 11:58 AM
  • Hi Jawhar, I need to transfer some logins as needed..so i am using this task ...it has all the possibilities for transferlogins, users, and some other properties..

    SUNIL PARISI

    Thursday, February 16, 2012 12:05 PM
  • Hi Jawhar, I need to transfer some logins as needed..so i am using this task ...it has all the possibilities for transferlogins, users, and some other properties..

    SUNIL PARISI

    Thursday, February 16, 2012 12:05 PM
  • Sunil,

    Did you get a resolution to the issue?

    Try this thread

    http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/243eef1a-88f8-457c-8130-9364d106ea14/

    Let me know incase.


    Please vote as helpful or mark as answer, if it helps
    Cheers, Raunak | t: @raunakjhawar | My Blog

    Monday, February 20, 2012 5:23 AM
  • 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
    • Marked as answer by Eileen Zhao Monday, February 27, 2012 8:17 AM
    Tuesday, February 21, 2012 8:33 AM