Hi everybody, I was pointed today to this very helpful blog post Quick Reference: SSIS in 32- and 64-bits I've created the User DSN pointing to VFP free table using odbcad32 from SysWOW64 folder. Now I opened BIDS, started a new SSIS project, added Data Flow task, created Connection Manager using this DSN and now I'm stuck, as I don't know what do to next. Can someone please explain step by step what should I do - for dummy? OOPs, I think I created this thread in the wrong forum - can moderator please move to SSIS forum? Thanks a lot in advance. Premature optimization is the root of all evil in programming. (c) by Donald Knuth Naomi Nosonovsky, Sr. Programmer-Analyst My blog

The easiest way to start is the SSIS Import/Export Wizard. Object Explorer, right click database, tasks, import data. You can save the generated SSIS package and enhance it later.Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM

Kalman, In the SSIS Import/Export Wizard I don't see an ability to select User DSN as the data source. I tried before selecting VFP Ole DB and I was getting all sorts of errors, so I'm not even going to try it today - I know it will not work.Premature optimization is the root of all evil in programming. (c) by Donald Knuth Naomi Nosonovsky, Sr. Programmer-Analyst My blog

Can you try: ".Net Framework Data Provider for Odbc" Related link: http://www.sqldev.org/sql-server-integration-services/ssis-import-export-wizard-data-sources-1338.shtmlKalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM

I've tried it. When I select a table - the corresponding table seems to create automatically, I'm getting this error on the Mapping step =================================== TITLE: SQL Server Import and Export Wizard ------------------------------ Column information for the source and destination data could not be retrieved. "projbuild" -> [dbo].[projbuild]: - Cannot find column -1. ------------------------------ ADDITIONAL INFORMATION: Cannot find column -1. (System.Data) ------------------------------ BUTTONS: OK ------------------------------ And the technical details are: Column information for the source and destination data could not be retrieved. "projbuild" -> [dbo].[projbuild]: - Cannot find column -1. (SQL Server Import and Export Wizard) =================================== Cannot find column -1. (System.Data) ------------------------------ Program Location: at System.Data.DataColumnCollection.get_Item(Int32 index) at Microsoft.DataTransformationServices.Controls.ProviderInfos.MetadataLoader.LoadColumnsFromTable(IDbConnection myConnection, String[] strRestrictions) at Microsoft.SqlServer.Dts.DtsWizard.OLEDBHelpers.LoadColumnsFromTable(MetadataLoader metadataLoader, IDbConnection myConnection, String[] strRestrictions, DataSourceInfo dsi) at Microsoft.SqlServer.Dts.DtsWizard.TransformInfo.PopulateDbSourceColumnInfoFromDB(IDbConnection mySourceConnection) at Microsoft.SqlServer.Dts.DtsWizard.TransformInfo.PopulateDbSourceColumnInfo(IDbConnection mySourceConnection, ColumnInfoCollection& sourceColInfos) ----------------------- So, not sure what to do - this is when trying using Import Wizard. Premature optimization is the root of all evil in programming. (c) by Donald Knuth Naomi Nosonovsky, Sr. Programmer-Analyst My blog

There are TWO places you can change column behaviour/mapping: 1. Advanced Tab on Data Source page: o Rename Column 0 --> (something) o Change column data type /size 2. Select Source Tables and Views o Edit mappings o Edit SQL Use the View options to see the source data looks OK prior to releasing/saving the package. Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM