Convert SQL Table to XML in SQL Server

Convert SQL Table to XML in SQL Server  --> XML stands for EXtensible Markup Language. --> XML was designed to store and transport data. --> XML was designed to be both human- and machine-readable. SQL Table DECLARE @Employee as table (Sno int identity(1,1),EmpName varchar(50),Company varchar(50), Location varchar(50),Stream varchar(50)) insert into @Employee(EmpName,Company,Location,Stream)...

Read More »

Data Profiling Using SSIS to load data to Database

Data Profiling Using SSIS What is data Profiling ? Data profiling is the process of examining the data available in an existing data source (e.g. a database or a file) and collecting statistics and information about that data. The purpose of these statistics may be to: Find out whether existing data can easily be used for other purposes. Data Profiling...

Read More »