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 |
|
Arunraj
Starting Member
18 Posts |
 Posted - 2014-11-21 : 07:57:52
|
| Hi Friends,I have to load the records from Flatfile to Database on daily basis.I am Using SQL server 2012I will load these files records using SSIS package.And the Flatfiles wil, be named after the Dealer NumbersFor Ex :(ACTEST00001_20141110_0406_SL.TXTACTEST00003_20141110_0406_SV.TXTACTEST00007_20141110_0407_INV.TXT) like this my files will be there.Suppose if i uploaded some bad records into the database and i need to delete that particular daterecords alone and particular file records by giving the dealer number .How can i do this through the SSIS package.And also if i ggive the date alone it need to delete all the loaded records on that particular date.How to do this please help me friends.i am waiting for all youe helps...... |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-11-21 : 09:27:22
|
| Add a SQL SCRIPT task that issues the DELETE command. |
 |
|
|
|
|
|
To Delete specific records of specificdate in SSIS