I Created an SSIS Package. Amended the SQL Text on the source control data flow to below

SELECT ACCESS_2003_MYTABLE.*

FROM ACCESS_2003_MYTABLE

WHERE CREATED_DATE=DATE()

Destination on Data flow was TMP_MYTABLE.

The above places all data...

The package has already created the table. You can use BIDS (business intelligence development studio) to edit the package. On the package there will be a SQL command that...

Another option is to save your import package as a SSIS Package. This can then be edited to pick up only new data. The packaged then can be...