locked
Is SSIS supports varchar data ?? RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote
    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
  • Question
    Sign in to vote
    0
    Sign in to vote
    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote
    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