February 13, 2009 at 6:39 am
Hi,
Has anyone ever came accross this error? See below message. I'm using MS SQL Server 2005 and trying to import data from a Visual Fox-Pro table to a SQL table. Manually and via SSIS.
TITLE: Microsoft Visual Studio
------------------------------
The component reported the following warnings:
Warning at {AE44B2B1-E8EC-46B4-A56A-98CCB11816D8} [Source - dirlnk [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.
Choose OK if you want to continue with the operation.
Choose Cancel if you want to stop the operation.
------------------------------
BUTTONS:
OK
Cancel
------------------------------
February 13, 2009 at 7:42 am
Yes, I also get this error, but it is simple to fix. Right-Click on your VFP source and select Show Advanced Properties. Then got to the COmponent Properties tab and down near the bottom in the Custom Properties section change the AlwaysUseDefaultCodePage property to True. This will eliminate the warning. I have not experienced any problems and I am exporting data from many VFP tables to SQL Server.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 16, 2009 at 7:09 am
Hi,
It works! Thank you! 🙂
May 22, 2012 at 4:14 am
Where do I right click? is the VFP Source the actual DBF file?
May 22, 2012 at 7:06 am
Usually you use the folder the DBF resides in as the source.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
May 22, 2012 at 7:28 am
Hi,
When I right click on the folder containing the vfp files it does not contain an option to show advanced Options.
regards
Joseph
May 22, 2012 at 7:30 am
I am using Windows 7
May 22, 2012 at 7:34 am
You need to right-click on the OLE DB Source in SSIS (BIDS) NOT the folder on the OS.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
May 22, 2012 at 8:23 am
Sorry Jack,
But I have just no idea how to do this could you please let me know how?
Joseph
May 22, 2012 at 8:28 am
Have you created an SSIS package in BIDS?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
May 22, 2012 at 8:41 am
No. But I am trying to set up one now. This is the first time I am using BIDS.
May 22, 2012 at 8:45 am
I am trying to make one now. This is the first time I have used BIDS.
May 22, 2012 at 8:54 am
In that case I recommend you begin by going through the Stairway to Integration Services series[/url] on this site.
Also SQLShare has some SSIS videos you may find helpful to get started.
Once you understand the basics of working with SSIS, then you can come back and ask specific questions. Most of the people who answer questions on this forum are volunteers who can't walk you through each step of creating an SSIS package.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
May 22, 2012 at 9:24 am
I have not created a SSIS Package
May 22, 2012 at 9:41 am
I have now created a SSIS Package
Viewing 15 posts - 1 through 15 (of 15 total)
You must be logged in to reply to this topic. Login to reply