Profile cover photo
Profile photo
Satish Innamuri
129 followers
129 followers
About
Satish's posts

Post has attachment

Post has attachment
Difference between DTS & SSIS
DTS SSIS SQL Server 7.0 introduces available on 2000
onwards SQL Server 2005 onwards its available Designed for ETS (Extract Transform Sources) Designed for ETL (Extract Transform Load) It Consists of Single Window for all operations.
It has data transf...

Post has attachment
Dynamically Create Excel Files depends on Export Data in SSIS
Scenario      In this Article, we will explain dynamically creation of new Excel files in SSIS depends on Export data from SQL Server table. Solution     The solution here was to create new excel file with Department Name at the package ran and export Depar...

Post has attachment
One Statement for Insert, Update, Delete operations in SQL Server (Merge)
Introduction        In this article, we will explain to perform Insert, Update, and Delete operations on Target table by matching the records from Source table by using a Single Statement in SQL Server. Solution       Generally we write separate statements ...

Post has attachment
Simplest Method to delete duplicate records in a Table
Introduction           In this article, I will explain how to delete duplicate records in a table by using SQL Query in a simple way. Solution • Create a table with the following structure create table Emp_Data ( Eid int , Ename varchar ( 50 ), Sal float ) ...

Post has attachment
How to avoid unnecessary sorting in SSIS Package
Introduction      In this article we will explain about what is the reason to remove the unnecessary sort transformations in the pipeline (work flow in Data flow task). Solution      Sort transformation is one of the blocking components in dataflow transfor...

Post has attachment
SQL Server Real Time Query
Problem            Write a stored procedure with parameters to pick the data with that date. If there is not data in insurance project then it has to pick from IT otherwise Banking. Solution First to create three tables in three various projects use insuran...

Post has attachment
Load data from multiple Excel sheets to Database in SSIS
Introduction: In this article, I will explain How to Load data from multiple Excel sheets (5 Sheets) in one Excel file into single table by using SSIS. Let us consider the following MS-Excel spreadsheet with data in 5 different sheets. Each sheet contains 3...

Post has attachment
Load data from multiple tables into single table by using SSIS
Introduction:               In this article, I will explain How to Load data from multiple tables (6 Tables) into single table by using SSIS. Solution: • The solution of the above problem by using Execute SQL Task, Foreach Loop Container, Script Task and Da...

Post has attachment
How to increase cache memory size in SSIS
Introduction:            In this article, I will explain cache modes and in which cases we can increase cache memory size. Description:             The most important setting of the Lookup Transform is the Cache Mode- It can greatly impact your dataflow per...
Wait while more posts are being loaded