Hi I need to import Basis Visual Pro 5 data into sql server 2008. In sql server 2000 that was possible but in this version i can not do it. Reading the docs i find there are some xml mapping files but it doesn`t help me because i am new in sql server 2008. If someone has done it i appreciate to tell me how. Thanks

You need to add the drivers for Visual Fox Pro. I found this article helpful. http://www.craigbailey.net/vfp-importing-vfp-data-into-sql-server/ Haven't tried it for 2008, though I assume that the principle is the same.Russel Loski, MCT

No, my source DataBase is Visual Pro 5, not is Visual Fox Pro. Visual Pro 5 is a Basis software, it is not a microsoft one.

No, my source DataBase is Visual Pro 5, not is Visual Fox Pro. Visual Pro 5 is a Basis software, it is not a microsoft one. Do you have ODBC, OLEDB or ADO.NET drivers for it? When you say it is not possible what do you exactly mean? Do you get an error or what ?SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

I have BBj ODBC, it is used succesfully in SQl Server 2000. In SqlServer 2008 there is not an option for import from that data source

I have BBj ODBC, it is used succesfully in SQl Server 2000. In SqlServer 2008 there is not an option for import from that data source It is possible. Setup ODBC connection manager to the database. Then insert ADO.NET Source component and use the ODBC connection in it.SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

thanks, but can you be more specific because i am new in sql server 2008 and ado components.

thanks, but can you be more specific because i am new in sql server 2008 and ado components. 1. Right-click in the bottom pane named 'Connection Managers'. Then select 'New Connection ...' menu option. 2. Scroll-down and find ODBC Connection. Double-click on it and setup connection to your database. Make sure you 'Test Connection' to confirm it works properly. 3. Insert 'Data Flow' task and go to the data flow canvas. 4. Open your toolbox and look for ADO.NET Source component. Insert in the data flow. 5. Setup the ADO.NET Source to use the ODBC connection you setup.SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Is that option in sql manager studio o in import/export wizard?

Is that option in sql manager studio o in import/export wizard? Neither. You have to open Visual Studio or also called Business Intelligence Development Studio (BIDS) and create a new SQL Server Integration Services solution and package. And inside the package you have to follow the instructions I have posted above. I don't want to discourage you, but it seems your SSIS knowledge is very very limited. I would recommend you purchase a book like that one and start from the basics.SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

you are right, i am not expert in sql server, that is the reason to enter this forum, I am a Java/Oracle developer but right now i need to use microsoft tools. In Sql Server 2000, It was very simple, but this sql s 2008 is new for me, in fact i just instaled yesterday. The microsoft tools are very friendly and i hope to learn without manuals i will try to apply the solution you tell me. I´ll notify you about the results, thank you very much

I already made the connection with Visual Pro5 succesfully, however, I have another problem: The ado net connetion has been correctly set up, in fact i can make a preview of the data. But when I try to add a Sql server destination in the data flow, it display "The selected connection manager uses an earlier version of SQL server provider..." If i add an ado.net destination looks like it can not work with big tables. When I run the data flow with few data it works but with more data not . Besides it is very slow, with 1000 the time elpased is uno minute, in SQl Server 2000 the time elapsed for the same table was 15 secs

I already made the connection with Visual Pro5 succesfully, however, I have another problem: The ado net connetion has been correctly set up, in fact i can make a preview of the data. But when I try to add a Sql server destination in the data flow, it display "The selected connection manager uses an earlier version of SQL server provider..." If i add an ado.net destination looks like it can not work with big tables. When I run the data flow with few data it works but with more data not . Besides it is very slow, with 1000 the time elpased is uno minute, in SQl Server 2000 the time elapsed for the same table was 15 secs I would recommend you use OLEDB Destination component with Fast Load option. The SQL Server Destination will only work if you execute your SSIS package on the same machine where you have your SQL Server database.SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

I succesfully used OLEDB Destination component with Fast Load option. It inserts 10000 rows in 5 minutes, is it normal? I installed SSIS on my PC (core 2 duo , 2GB ram, Windows XP) the data source is in the same machine That component has an option "rows per batch ", has it some effect on the bulk insert? How can i see the progress when the data flow is running. It only show the beginning and the end, it does not show me the current row Thanks for your help

I succesfully used OLEDB Destination component with Fast Load option. It inserts 10000 rows in 5 minutes, is it normal? I installed SSIS on my PC (core 2 duo , 2GB ram, Windows XP) the data source is in the same machine That component has an option "rows per batch ", has it some effect on the bulk insert? How can i see the progress when the data flow is running. It only show the beginning and the end, it does not show me the current row Thanks for your help This is very slow performance. Can you do the following test? Pull data from your source database and direct it to "Union all" component. Remove any destination components you may have. The goal is to find out what is the extraction speed from your source.SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

I find a property in the data flow named defaultbuffermaxrows it was set in 10000 by default, so i set it to 1000 and the performance improved. Finally I can import data from Visual Pro5 to sql server 2008. Thank you very much for your help