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 12:47 am

    #1468023

    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