Please bear with me and tell me where am i going wrong, initiallY i was getting the following eror when i executed the task, The source is a view from Oracle db and destination is a table in SQL Server: TITLE: Package Validation Error ------------------------------ Package Validation Error ------------------------------ ADDITIONAL INFORMATION: Error at Data Flow Task [OLE DB Destination [1082]]: Column "EMPLID" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [1082]]: Column "LAST_NAME" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [1082]]: Column "FIRST_NAME" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [1082]]: Column "COI_HRS_CONCAT1" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [1082]]: Column "COI_HRS_CONCAT2" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [1082]]: Column "POSITION_NBR" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [1082]]: Column "COI_POSN_DESCR" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [1082]]: Column "TRC" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [1082]]: Column "COI_TRC_DESCR" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [1082]]: Column "PAYABLE_STATUS" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [1082]]: Column "XLATLONGNAME" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [1082]]: Column "USER_FIELD_1" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [1082]]: Column "DEPTID" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [1082]]: Column "USER_FIELD_2" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [1082]]: Column "USER_FIELD_3" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [1082]]: Column "WORKGROUP" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [1082]]: Column "COI_WRKGRP_DESCR" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [1082]]: Column "TASKGROUP" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [1082]]: Column "COI_TSKGRP_DESCR" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [1082]]: Column "TASK_PROFILE_ID" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [1082]]: Column "COI_TSKPROF_DESCR" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [1082]]: Column "PAYGROUP" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [1082]]: Column "COI_PAYGRP_DESCR" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [DTS.Pipeline]: "component "OLE DB Destination" (1082)" failed validation and returned validation status "VS_ISBROKEN". Error at Data Flow Task [DTS.Pipeline]: One or more component failed validation. Error at Data Flow Task: There were errors during task validation. (Microsoft.DataTransformationServices.VsIntegration) ------------------------------ BUTTONS: OK ------------------------------ The destination table has the following CREATE code SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[PEOPLESOFT_HOURS_REPORT_DPR]( [EMPLID] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [EMPL_RCD] [numeric](38, 0) NOT NULL, [LAST_NAME] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [FIRST_NAME] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [COI_HRS_CONCAT1] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [COI_HRS_CONCAT2] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [POSITION_NBR] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [COI_POSN_DESCR] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [DUR] [datetime] NULL, [TRC] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [COI_TRC_DESCR] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [PAYABLE_STATUS] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [XLATLONGNAME] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [TL_QUANTITY] [numeric](18, 6) NOT NULL, [USER_FIELD_1] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [DEPTID] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [USER_FIELD_2] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [USER_FIELD_3] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [WORKGROUP] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [COI_WRKGRP_DESCR] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [TASKGROUP] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [COI_TSKGRP_DESCR] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [TASK_PROFILE_ID] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [COI_TSKPROF_DESCR] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [PAYGROUP] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [COI_PAYGRP_DESCR] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL) ON [PRIMARY]GOSET ANSI_PADDING OFF
Now i added the data conversion transformation and changed the datatyppe to ' STRING(DT_STR) and i'm still getting the same errors, any idea where i'm going wrong? Thanks
cannot vconvert between unicode and non uni code
Posted - 2012-05-07 : 10:09:06
