OLE DB command transformation is a common transformation and It runs the SQL statements like Insert, Delete, Update statements in data flow.
This transformation has one Input and one Output.
For OLE DB command transformation, We are explaining here by the examples How to Insert data in database by using OLE-DB Transformation.
In previous articles, We have explained to open BIDS and create a package.
Now we are going to explain how to use OLE DB command Transformation step by step.
Step 1) Drag and drop OLE DB Source and command Transformation from SSIS toolbox in data flow tab.
Step 2) Now Double click on OLE-DB source , OLE-DB source editor window will open and need to select table.
Step 3) Click on the columns tab to check the columns.
Step 4) Double click on the OLE DB Command Transformation , the Advanced Editor for OLE DB Command will open.
Step 5) In Connection Manager Tab,We require to configure connection manager.
Step 6) In Component properties Tab,We require to select SQLCommand property and click on “…” button.
Step 7) Once you click on the browse button, a String Value Editor window will open to write SQL statement.
Step 8) In Column Mappings Tab,We require to choose columns for parameters.
Step 9) Click on “Ok” button to complete the configuration and execute the package to check the result in database.
If you want to sell your readymade software to the genuine clients or businessman, list your software with details and demo links.
Clients will find it using our advanced search filter and will contact you directly.
No any charge for the product lsiting.