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

Asked By 0 points N/A Posted on -
qa-featured

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.

SHARE
Answered By 0 points N/A #145111

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

qa-featured

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

Problem that I encounter while using SAS.

Previous

Program to calculate summation of a series in salary sheet

Next

Related Questions