Viewing 3 posts - 1 through 3 (of 3 total)
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...
July 6, 2012 at 6:36 am
#1509651
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...
July 6, 2012 at 4:06 am
#1509561
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...
July 6, 2012 at 3:37 am
#1509547