Go to the Source Report Manger and then the folder where your current report exists. Select the report you want to Move/Copy and then go to option, select download and then a File Download screen will appear, save the file to a temporary folder. 3.  Open another Internet Browser tab, and go to the Target Report [...]

This document is as a continuation of the series of Deploying SSIS Packages in SQL Server 2008. In the PART-I, we had discussion on two parts that are required to prepare Integration Services projects for deployment. Here we will discuss on the remaining two parts as a PART II of the series. So, let’s talk [...]

After you complete the development or modification of packages, you need to deploy them to a test environment for further testing or to a production environment. This section includes information about common tasks that you do to prepare Integration Services projects for deployment, create the deployment bundle, and install packages on the target computer. How [...]

ODI Metadata Navigator (MN) provides a browser interface to see all of the metadata in our repository. Remember that this is looking directly at the repository–there’s no separate step involved like generating a report, so there’s no danger of seeing old information. We are basically looking at real-time reports on our metadata. We log in [...]

This document is as a continuation of the series of best practices suggested for SSIS. In the PART-III, we had discussion on “OPTIMIZE THE SQL DATA SOURCE, LOOKUP TRANSFORMATIONS, AND DESTINATION”. Here we will discuss on “CHANGE THE DESIGN OF ETL” as a PART IV of the series. So, let’s talk about our topic of [...]

This document is as a continuation of the series of best practices suggested for SSIS. In the PART-II, we had discussion on “IMPROVING THE PERFORMANCE OF THE DATA FLOW”. Here we will discuss on “OPTIMIZE THE SQL DATA SOURCE, LOOKUP TRANSFORMATIONS, AND DESTINATION” as a PART III of the series. So, let’s talk about our [...]

I was trying to load “Sales.Customer” table from “AdventureWorks” database to excel sheet. While doing it, I selected “AccountNumber” column to load. Then at the time of configuring “Excel Destination”, I selected “NEW…” to select name of the Excel Sheet. There a small message popped-up with default SQL code for creating an Excel sheet. It [...]

This document is as a continuation of the series of best practices suggested for SSIS. In the PART-I, we had discussion on “SSIS IS AN IN-MEMORY PIPELINE, SO ENSURE THAT ALL TRANSFORMATIONS OCCUR IN MEMORY”. Here we will discuss on “IMPROVING THE PERFORMANCE OF THE DATA FLOW” as a PART II of the series. So, let’s talk [...]

SQL SERVER INTEGRATION SERVICES BEST PRACTICES (Part – I) It is a myth that Microsoft SQL Server Integration Services (SSIS) does not scale.  In response, I would like to answer this question with another question. Q: Does your system need to scale beyond 4.5 million sales transaction rows per second? This question itself is an [...]