>>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.

On the Ole DB source and Ole DB Destination - Right Click, and select Edit, with the Menu you will see OLe DB Connection Manager, select your source - it will be the same for destination also.

Carl