dts error -- sql server dts

sql server dts : dts error

zino
1/27/2006 3:32:27 PM

I'm using sql server 2005.
I'm trying to create a package that import data from Oracle 10g to SQL
server 2005.
in the Data Flow Designer the OLEDB Source is displaying a warining icon
saying:

The component reported the following warnings:

Warning at {1C010C8E-2695-4214-BC94-067A57B1823E} [OLE DB Source [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.

and if I run the package I get the same error.
I know that I'm missing something but I don't what.

thanks for help

Darren Green
1/28/2006 12:00:00 AM

[quoted text, click to view]

I think the key point here is "Warning", it is not an error. In an ideal
world you would not get this message, but all is not ideal, and that is
what it is telling you.

I don't know enough about your scenario, or the Oracle drivers, to
comment much more but the message is readable.

If you load works, then ignore it.

--
Darren
http://www.sqldts.com

zino
1/30/2006 5:21:27 AM

the warning icon is showing in the Data Flow designer, on the OLEDB Source
control that I inserted from the toolbox.
the problem is that this warning become an error during execution and the
package fail because of it.

the oracle driver used is : Oracle provider for OLEDB, where I have
orcale10g insatlled on the server where the dts is running.

v-mingqc NO[at]SPAM online.microsoft.com
2/3/2006 12:00:00 AM

Hi Zino,

Are you doing any bulk load facilities wiht this Oracle driver?

Based on my knowledge, oracle provider treats oracle just like any other
data source and does not use bulk load facilities to transfer records
faster. I dont know if oracle has any bulk load facilities either.

Sincerely yours,

Michael Cheng
Microsoft Online Partner Support
======================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

zino
2/7/2006 5:16:31 AM

Thanks for the help.
I fixed the problem by changing "AlwaysUseDefaultCodePage" propertie to
"True"
which was set by SQL by default to "False".

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server dts

View Other Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007

home · blog · groups

Questions? Comments? Contact the dn