>>Sorry for the confusion - You can open SSIS under SQL Server Business Intelligence Development Studio - or you can open VS2005 - New Project - Business Intelligence Project / Integration Services Project (This is SSIS/DTS)
>
>Thanks, I now have a project created for that. However, this interface is huge. I see a lot of things under Control Flow Items. I am not sure which one to take. The only thing I need is to define a migration from VFP data, which is having all of its tables in the same directory, into SQL Server, in way that I would be able to reexecute that task by simply doing a few clicks as the package would be saved.
Create the OLE_DB connection (Foxpro),
Create the OLE_DB Connection (SQL)
Pick the Data flow
On the Data flow tab
Pick OLE DB Source
Pick OLE DB Destination
Link them, then Map your Foxpro table to your SQL table. It will even allow data conversion if you want.
Save Package. Reuse when needed.
Carl
¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø¤º°¤º°`°º¤ø¤º°¤º°
Carl Evans
CEO & President
System Answers Consulting, Inc.
MCSD .NET, ASP.NET, C#.NET, VB.NET,