SQL Server Performance Forum – Threads Archive
delete records in the destination file in SSIS
How do I delete records in the destination file in SSIS using BI DevelopmentStudio? Thanks.
Do you mean after importing data from flat file into table, you want to clear the file records, then you could delete the file instead.
what is your destination. DB/Excel/Texr? —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/
I mean before I export to the DB file and this job is running daily.
U can do this by using a sql task. execute delete statment in the sql task —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/
Instead of using the delete statement, possibly use Truncate due to logging… just my 2 cents
In fact, it is DBase file.
]]>