Profile cover photo
Profile photo
Ghanesh Gautam
97 followers
97 followers
About
Posts

Post has attachment
How to read data from multiple Excel files with SQL Server Integration Services
I have data in multiple Excel files and all my Excel files are placed in the same folder. I want to create a SQL Server Integration Services (SSIS) Package which can read data from multiple Excel files and load the data into a SQL Server destination table. ...

Post has attachment
How to read data from multiple Excel worksheets with SQL Server Integration Services
My Excel source file has data in multiple worksheets and I need to read data from all of these sheets and load it into SQL Server destination table, how can I do this using SSIS? This tip explains how we can load data from multiple Excel sheets and load it ...

Post has attachment
Table Variable in SQL Server
Alternative of Temporary table is the Table variable which can do all kinds of operations that we can perform in Temp table. In SQL Server we have a Data Type Table. We can make use of this data type to create temporary tables in database.   Table variables...

Post has attachment

Post has attachment
How to read data from an Excel file starting from the nth row using SSIS
I have Excel files I need to read using SQL Server Integration Services (SSIS), but the first few rows in the file are just information about the data and these rows should be ignored. How can I read data from an Excel file starting from the nth row in SQL ...

Post has attachment
MSSQLTips.com Rookie of 2015 Award
Thank you world for your vote. I won  MSSQLTips.com Rookie of 2015 Award  just because of you! 2015 was a great year for the MSSQLTips.com community and dedicated team of authors who provide value to the SQL Server Community every second of the day. Please ...

Post has attachment

Post has attachment
SSAS Interview Questions
1.       What is
Data Source? 2.       Can we
create more than one Data Source? 3.       What is
Impersonation information? 4.       What are
options available in Impersonation information tab? 5.       What is
Isolation in Data Source? 6.       What is
def...

Post has attachment

Post has attachment
Wait while more posts are being loaded