Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
redfive
Starting Member
4 Posts |
 Posted - 2009-02-04 : 10:36:06
|
| Please cna you help I import a csv file in to a sql table everyday , the ssis job is setup to drop and create the sql table - This is working fine I have now been asked to keep certian data from the sql table for 30 days , Do can i set this up , Maybe have a second table to copt the values i need for 30 days but how ? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-04 : 12:14:36
|
| nope. just include logic in step where you delete from table to exclude those records and remove current create and drop step. |
 |
|
|
|
|
|
Import and keep data is sql table