Home Forums Data Warehousing Integration Services How to update a destination table in ssis RE: How to update a destination table in ssis

  • April 3, 2012 at 2:26 am

    #1468049

    abhish_216 (4/3/2012)

    Are both the source and destination SQL Server? -- yes on same sql server

    What datatype is used in SSIS? -- Same data types. int for empno,

    varchar(20) for ename

    What collation do you use in the source and destination? -- SQL_latin1_General_CP1_C1_AS

    No, the datatype in SSIS is either DT_STR or DT_WSTR. Big difference.

    Are there special characters in your data?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP