Our First SSIS Full Training is Liveon Udemy! More information here:
🚀https://expert-only.com/en/ssis-online-training/
This video tutorial shows step by step how to create an SSIS package with a basic data flow to load data from a source table to another one, within the same SQL Server database.
The SSIS example package and data flow simply load the customers table content into the target table. And the derived column populates a new table with the initials of the customers, i.e., the first letters of the Firstname and the first letter of the Lastname columns, concatenated.
The formula also cast the data type to the DT_WSTR with a length of 8 characters. To load and populate an additional column in the target table, follow these steps:
0:20 : With Visual Studio, open an SSIS project and create an SSIS package and add a data flow
2:02 : Create the source and target table with SSMS, queries
5:07 : Configure the data flow with the OLE DB Source, Derived Column and the OLE DB Destination components.
10:46 : Execute the package and check the results in the database.
The full article with all the screens shots and explanations is available on our IT blog, in the SSIS section:
https://expert-only.com/en/ssis/create-a-simple-ssis-data-flow/
If you like the content, like the video and subscribe to the chanell to get the latest videos updates.
🌍 Our blog is available in:
✅ English: https://expert-only.com/en/
✅ French: https://expert-only.com/fr/
✅ Spanish: https://expert-only.com/es/
✅ and Portuguese: https://expert-only.com/pt-pt/
