HomeНаука и техникаRelated VideosMore From: TechBrothersIT

SSIS Tutorial Part 44- Delete Rows from a Table by using OLE DB Command Transformation

12 ratings | 9083 views
In this video we will learn How to perform Delete Operation in OLE DB Command Transformation in SSIS Package. We will learn the disadvantages of using OLE DB Command Transformation for Delete Operation and what other options we have to perform Delete in SSIS Package. In this OLE DB Command Transformation Demo , we will learn How to Read data from Flat File Source in SSIS Package How to Create Table in SQL Server Database How to write Delete statement with Input Parameter for OLE DB Command Transformation How to map input Columns to OLE DB Command Transformation Parameters for Delete Operation OLE DB Command Transformation- Delete Records from a Table in SSIS Package - SSIS Tutorial Blog post link for the video with scripts http://sqlage.blogspot.com/2015/04/delete-rows-from-table-by-using-ole-db.html Check out our Full Step by Step SQL Server Integration Services(SSIS) Tutorial http://www.techbrothersit.com/2014/12/ssis-videos.html
Html code for embedding videos on your blog
Text Comments (2)
oceantrolls73 (3 years ago)
Excellent video. Thank you. What do you suggest is the best solution for updating information from SOURCE to DESTINATION? I have created a project to inserts data between two SQL tables. However, now i wish to do only updated details in SOURCE into DESTINATION. Thanks in advance,
TechBrothersIT (3 years ago)
+oceantrolls73 Hi, I will suggest to insert records in some staging table and write Merge Statement/ for simple Update statement ( Set base Update) instead of using OLE DB Command Transformation that perform row by row operation. Thanks for watching the video and leaving comments!

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.