Hi, i need to create and use a new mapping file to use it in the Sql Server 2008 import/export wizard. Does anybody know how to do it? Besides i need to know what to do in Sql Server 2008 import/export wizard, because the software doesn`t find new data source when I add a new Mapping File. I copied an old one but it did not work.

what do you mean by "Mapping file" ? what you want to do exactly?http://www.rad.pasfu.com

The SQL Server Import and Export Wizard uses the mapping files that Integration Services provides to map data types from one database version or system to another. You can find imformation in this link http://msdn.microsoft.com/en-us/library/ms141209.aspx The problem is: I am trying to import a Basis (Visual Pro 5) data into Sql Server 2008 but it doesn`t have that data source as one of the defaults, so i want to add a new data source. Thanks

ok . i got your problem now. you don't need Mapping file you just need a connection provider. you can download OLEDB provider for Foxpro from here: http://www.microsoft.com/downloads/en/details.aspx?familyid=E1A87D8F-2D58-491F-A0FA-95A3289C5FD4&displaylang=en and after install, you will find an oledb connection type for this in import/export wizard.http://www.rad.pasfu.com

No, I need to import Basis Visual Pro5 Data and it is not a microsoft product such as visual fox. I am not importing a visual fox dataBase thanks

No, I need to import Basis Visual Pro5 Data and it is not a microsoft product such as visual fox. I am not importing a visual fox dataBase thanks Oh, my misReading. sorry for that. what is your connection type to this Visual Pro5? do you have ODBC connections for this? if yes, you can set an odbc connection there and then set "Data Source" as ".NET framework data provider for odbc" in import/export wizard.http://www.rad.pasfu.com

yes, that was my first option .I type a dsn (copied form control panel) and the driver, but it show me a message : " cannot get supported data Types from the data base connection "dsn=disco1;driver =bbj ODBC driver"

did you ever tried with BIDS ? maybe you could use ado.net sources and connect to the odbc with it.http://www.rad.pasfu.com