Error while I was using Microsoft’s SQL Server Integration Services.

Asked By Barbara Rothermal 0 points N/A Posted on - 06/20/2012

Hi,

Today, I have encountered the following error message while I was using Microsoft's SQL Server Integration Services to connect with CONNX. I attached the image below.

The component reported the following warnings: Warning at {7C9775C6-3465-48F4-A487-072915ACI6SC} (OLE DB Source (ID: 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.

Choose OK if you want to continue with the operation. Choose Cancel if you want to stop the operation. 

What should I do?

Please help me with my problem.

Thanks.

• Status: Open
• Question Views: 875
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By Parsh Auguston 0 points N/A #145111

Error while I was using Microsoft’s SQL Server Integration Services.

The error indicates few things that are wrong.

1. First you need to see if the drive for the database integration is properly set and that it is getting the right parameters of admin username and the password with the specific IP and port if required.
2. After confirming that, make sure that the data that you are trying to convert is not only compatible with the SQL server.
3. Make sure this and convert the data to any other format if possible.
4. Also make sure that there is only 1 connection at a time since having more than once connection at a time can be causing real problems like that does not have a logical solution to it.

 

About Parsh Auguston

Questions
2

Answers
152

Best Answers
12

• Vote Up 0 Vote Down

• Posted on - 08/05/2012
• Question Category: MS SQL Server