Hi All, I am loading the databy using manually as Task-->Importdata. But data is not loading and gives the following error. We have used nvarchar() datatype is SQL Server where as source -oracle datatype is varchar() - Validating (Error) Messages Warning 0x80202066: Data Flow Task: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale ID will be used. (SQL Server Import and Export Wizard) Warning 0x80202066: Data Flow Task: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale ID will be used. (SQL Server Import and Export Wizard) Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Data Conversion 1" (245). (SQL Server Import and Export Wizard) I have changed the nvarchar() to varchar datatype in destination,it has worked fine. Kindly let me know how to use CAST function to change datatype.Then I will use it in SQL itself instead of changing the table data structure. Thanks in advance.

hi, i am assuming you moving data using ssms. are you planning to use the CAST function once the data has been loaded into staging or in SSIS? in SSIS you can use the data conversion transformation component to change between types. if you are doing an insert via tsql, you dont need to conver between varchar and nvarchar - you can do a straight insert. let me know if you need screenshots of my explanationBI Technical Consultant| Karabina, South Africa

Hi, This error is there because SSIS package does not convert these datatypes implicitly. Now, there are couple of alternative you can take 1) Save the package at last step of wizard, open the package and data conversion transformation in data flow task and run that package. 2) In wizard, instead of specifying the table directly, select a option to write a query against oracle and use CAST for all the string type data.- Chintak (My Blog)