Home Blog Page 3

How to load multiple Excel sheets data into one Excel workbook

Aim :-  What you are going to Learn is - How to load multiple excel sheets data? The core reason of putting this scenario in Question Laboratory (Q Lab) is that we will show you how to load multiple excel sheets data into a single excel work book without using Foreach loop container in SSIS. Description :-  I have seen many...

How to create a dynamic folder using SSIS?

dynamic folder
Aim :-  Agenda of this article will be to create a dynamic folder followed with current day name. In simple words, the situation demands to create a dynamic folder on daily basis with the desired name say RX followed by current day name. Description :-  I am sure your white cells must be stimulated and searching for the answer. Have you ever...

Send Mail Task in SSIS

Send Mail Task
Aim :-  This post  is written for those geeks who want to know the purpose of send mail task in SSIS. Description :-  As the name suggests, Send Mail Task is used to send an automatic e-mail message from the SSIS package control flow. We can also configure ssis send mail task task at various event handlers. For example -...

How to avoid SSIS Code page Warning Message?

Aim :-  The main aim of this article is to encounter the SSIS code page warning message at the time of extracting data from Oracle to SQL Server. Description :-  Below is the code page warning message, I faced recently at the time of pulling data from “Oracle to SQL Server”. Here, I will show you how to solve this warning (Code...

Latest SQL scenario based Interview Questions and Answers

SQL scenario based Interview questions
Hello visitor, Are you preparing for an Interview and wants to hit scenario based SQL Interview questions? You are at the right ground. " In your IT life, Interviews are like doing Toothbrush each day "  by Chander Sharma. Agree? Like you choose best toothbrush for your teeth, similarly you need best material to prepare for your Interviews. With this post, I...

Write Hello World program in JAVA

Hello World Program
Whatever scripting language you learn, the first program you will execute is Hello world program using that technology. It is a kind of tradition in your programming world, Am I correct? I still remember my college days where the first program I learned was Hello world in Java. Let me add one more point, it took me around 1...

Attribute centric and Element centric XML

attribute centric
This post is composed of 2 main keywords. One is XML and other is your favorite SQL Server. In this article, you will learn how to read XML form of data in SQL server and then convert SQL Server data into XML form.  Before starting with my technical explanation on this topic, I would like to make you aware...

Introduction to Neural network in AI?

Neural Network
Aim :-  This article is written for those who are/wants to learn Artificial Intelligence (AI). Below are the learning's, you will get from this post - Small example explaining How AI is making world Intelligent. 5 attributes which will transform Machine into Artificial Intelligent machine. Learn Neural network. Pattern Matching. Comparison between Human brain and Machine brain Description :-  Artificial Intelligence (AI) freaks. In my...

Connect with us