SQL Server Data Tools – Business Intelligence for Visual Studio 2012 released online

Today we are releasing SQL Server Data Tools – Business Intelligence for Visual Studio 2012 (SSDT BI) templates. With SSDT BI for Visual Studio 2012 you can develop and deploy SQL Server Business intelligence projects. Projects created in Visual Studio 2010 can be opened in Visual Studio 2012 and the other way around without upgrading…

22

SSIS 2012: Creating a Simple ETL Package Tutorial

There is now a SSIS 2012 version of the “Creating a Simple ETL Package Tutorial”. The tutorial and lesson packages work with the AdventureWorksDW2012 database. And, the tutorial includes a new Lesson 6 that shows you how to convert a project to the project deployment model and replace configuration values with parameters. The tutorial documentation is…

9

Deploy SSIS 2012 projects using catalog.deploy_project Stored Procedure

In SQL Server 2012, you can use the catalog.deploy_project stored procedure to deploy an SSIS project to the SSIS server. You need to provide the binary contents of the project deployment file (.ispac extension), for the @project_stream parameter, along with the project name and the folder the project will be deployed to. The @project_stream parameter is…

3

Scheduling SSIS Packages and SSIS Catalog Reports -- Doc Updates

I’ve recently updated the SSIS documentation in Books Online (BOL), to add some details around setting SQL Agent job options for packages stored in the SSIS catalog, as well as in MSDB and the file system.  I’ve also added some more information about the troubleshooting reports available for projects that are deployed to the new…

1

Important Note about Upgrading to SSIS 2012

When you upgrade to SQL Server 2012 Integration Services (SSIS) on a machine that has SSIS 2005 or 2008 installed, SSIS 2012 is installed side-by-side with the earlier version. Unlike upgrades to previous versions, the upgrade process does NOT remove the SSIS 2005 or 2008 files, service, and tools. In addition, with this side-by-side install,…

2

SSIS Sessions at the 2012 PASS Summit

There are a whole bunch of SSIS sessions at the PASS Summit this year – I’m glad to see our product continues to be one of the most popular SQL topics around! Pre-Conference SSIS Design Patterns (BIA-299-P) – Andy Leonard, Jessica Moss, Matt Masson, Michelle Ufford, Tim Mitchell  Full day of SSIS training from the…


Video about CDC for Oracle Databases in SSIS 2012

This video presentation Rakesh Parida (MSFT) demonstrates how to perform CDC for Oracle databases using SSIS 2012. You’ll learn how the CDC features work, how to create and administer the CDC service, as well as how to use logs and traces to troubleshoot the service. The video is availble online at http://technet.microsoft.com/en-us/sqlserver/jj218898.aspx . For more information…

2

Migrating SQL Server 2000 Data Transformation Services (DTS) Packages to SQL Server 2012

SQL Server Integration Services (SSIS) 2012 doesn’t support migrating or running DTS packages.  You do have the following options for migrating your DTS packages to SSIS 2012. Migrate the packages to SSIS 2005 or SSIS 2008, and then upgrade the packages to SSIS 2012. For information about migrating packages to 2005 or 2008, see Migrating Data Transformation Services Packages (2005)…

8

SSIS Case Study – Innovapost

An interesting case study about how SSIS is used by Canada Post has recently been published. The article mentions how they built an SSIS scale-out solution which processes 10-15 GB of data per day (with four worker nodes). Definitely an interesting read! If you’d like to know more about building your own scale-out solutions with…


Bulk Loading Data to Oracle

In SQL Server 2005, and the non-Enterprise editions of SQL 2008/SQL 2008 R2, SSIS doesn’t provide an out-of-the-box option for bulk loading Oracle data. Instead, SSIS components implement single row inserts to load data to Oracle.  This can result in issues such as long load times and timeout during the ETL process. This article on MSDN provides…

1