Wednesday, February 15, 2012

Error while copying the data to sql server...

Hi all,
i m trying to copy the data from a view in pl/sql developer.(using ORACLE Provider for OLE DB)...using import/export wizard....the first view was copied without any problem...but in the second one i m getting the following error....

Operation stopped...

- Initializing Data Flow Task (Success)

- Initializing Connections (Success)

- Setting SQL Command (Success)

- Setting Source Connection (Warning)

Messages

Warning 0x80202066: Source - SERVICE [1]: 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)

- Setting Destination Connection (Success)

- 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)

Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Data Conversion 1" (117).
(SQL Server Import and Export Wizard)

- Prepare for Execute (Stopped)

- Pre-execute (Stopped)

- Executing (Success)

- Copying to [Telbill].[COLL_DB_TESTING].[SERVICE] (Stopped)

- Post-execute (Stopped)

- Cleanup (Stopped)

I cant understand wat exactly is wrong....how can i deal with this problem....the data type i m copyin the same thats there in oracle...
y is it not working...can someone please tell me...
thanks in advance,
regards.

Try setting AlwaysUseDefaultCodePage=TRUE on the OLE DB Source component...

No comments:

Post a Comment