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 ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE 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]
GO
SET 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 - 05/07/2012 : 10:09:06
