yonbret
asked on
SQL Server Integration Services Limit Data by Date
I need to copy data from Visual FoxPro to SQL Server.
The table in FoxPro has decades of data and thus is very large. All I really care about is the last year's data.
Currently, I am copying all the data to SQL Server and then running a stored proc to delete the older data. This is causing the database size and logs to explode.
How can I make SSIS only copy the last year of data? What control allows you to filter by date?
The table in FoxPro has decades of data and thus is very large. All I really care about is the last year's data.
Currently, I am copying all the data to SQL Server and then running a stored proc to delete the older data. This is causing the database size and logs to explode.
How can I make SSIS only copy the last year of data? What control allows you to filter by date?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER