FWD: Data Preparation for Azure Machine Learning using SSIS

Please bookmark the new SSIS blog page –http://blogs.msdn.com/b/ssis/ – I am still sharing a few interesting blog post from the new SSIS blog page to get your attention Here is a recent blog to show you how you can leverage SSIS in your data preparation process for Azure Machine Learning: Data Preparation for Azure Machine Learning using…

1

FWD: Doing more with SQL Server Integration Services Feature Pack for Azure

Please bookmark the new SSIS blog page –http://blogs.msdn.com/b/ssis/ – I am still sharing a few interesting blog post from the new SSIS blog page to get your attention Here is a recent blog to show you how you can leverage the new Azure blob connector and HD Insight task from SSIS to build a hybrid data pipeline from…

0

Introducing the new SSIS blog page – http://blogs.msdn.com/b/ssis/

Hi all, this is Jimmy Wong, and I am the PM for SSIS team. With some recent discussion with Matt Masson and other folks, we decided to create a new blog page http://blogs.msdn.com/b/ssis/ and replace the old one http://blogs.msdn.com/b/mattm/ to better serve our blog reader. The old page http://blogs.msdn.com/b/mattm/ will be kept alive but no new…

4

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…