>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.
Thanks, I am now able to work with a package. So far, I have added a Data Flow Task in the Control Flow pane. Then, in the Data Flow pane, I have the Ole DB source and the Ole DB Destination. Down below, in the Connection Managers window, I have the two connections. However, I just can't figure how to assign each of those connections to their own respective OLE DB container appearing in the Data Flow pane.