- 9
- 3 231
Certi Tracks
United States
Приєднався 24 жов 2011
This channel is for teaching and learning database technologies using Microsoft SQL Server platform and its services such as Integration Services, Reporting Services.
I try my best to present the most accurate information and demonstrate the techniques that I have used in my professional life as a database designer, ETL developer and many other hats that I have worn over the years.
Your constructive comments, suggestions, tips and advice is always appreciated.
Please feel free to drop me a line if you wish.
Thanks
Humayoon Khan
I try my best to present the most accurate information and demonstrate the techniques that I have used in my professional life as a database designer, ETL developer and many other hats that I have worn over the years.
Your constructive comments, suggestions, tips and advice is always appreciated.
Please feel free to drop me a line if you wish.
Thanks
Humayoon Khan
Using AI tools – Microsoft Copilot to help us be more productive
This video is a quick tip to use AI tools to help us write better and perform some basic computing tasks
Переглядів: 27
Відео
SSIS Logging
Переглядів 1505 років тому
This video explores all 5 types of log providers that SSIS can be configured for - SQL Server table, Profiler trace file, Text log, XML log, Windows Application Log. Logging the information about the events that occur while your SSIS package executes is useful in troubleshooting, determining the cause of error and exact error message. Auditing is also a reason for activating the logging in our ...
SQL Server Integration Services (SSIS) Row Count Transformation
Переглядів 2005 років тому
Row Count transformation captures the number of rows passing through a data flow. It stores the value in a variable and can be used in next tasks to make use of it. It is a simple to implement transform but can be useful in capturing the row counts of a data load and log into, for example a table for reconciliation purposes This video Execute SQL Task is also used to log the row count captured.
SSIS Lookkup Transform
Переглядів 245 років тому
Lookup transformation of SSIS is useful to validate a data set being loaded into a table or add a looked up data element from a referenced data set. This video demonstrate the use of this transformation with an example of uploading a flat data file into a SQL Server database table
SSIS Derived Columns
Переглядів 2,1 тис.5 років тому
This video explores the Derived Column transform of SQL Server Integration Services. It shows how to create Derived Columns based on computations with existing data source columns, using system variable or literal value. Derived Column transforms are useful to add metadata and other types of columns that are not readily available in source data
SSIS Execute SQL Task
Переглядів 545 років тому
This video demonstrates the use of Execute SQL Task of SQL Server Integration Services. It shows examples of all four types of Result Set property settings including Full Resultset, XML etc. and multiple ways how to supply the SQL Query to the task. It uses Script Task to test the values fetched by executing the query statements.
SSIS Using ForEach Loop to Load Files
Переглядів 6407 років тому
This video shows how to create a complete end-to-end package that uses ForEach Loop Container to upload multiple files stored in a folder on the file system. It also uses other components to log an entry in a table for file row counts, ssis log on sql server
Microsoft SQL Server Creating Database
Переглядів 167 років тому
Creating a database in Microsoft SQL Server using SQL Server Management Studio (SSMS) and T-SQL script
SQL Server Database Mail
Переглядів 267 років тому
Configuring the database mail feature in a SQL Server instance
Great work
Thank you! Cheers!
Wonderful 👍
Thanks
Very cool! thanks for sharing!
Thanks for this great tutorial. Question, I have multiple files and each one of them has different columns and I want to load each file to a different table in the same database, Can I still be able to use ForEach Loop or how you would approach that? Thanks.