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 2012
I will load these files records using SSIS package.
And the Flatfiles wil, be named after the Dealer Numbers
For Ex :
(ACTEST00001_20141110_0406_SL.TXT
ACTEST00003_20141110_0406_SV.TXT
ACTEST00007_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 date
records 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