My Session at Pass DW and BI Chapter – SSIS Catalog; Big step for ETL Framework

Hi folks, I will speak at 10th of August at Pass Data Warehousing and Business Intelligence Virtual Chapter. Session Title: SSIS Catalog; Big Step for ETL Framework Time: Fri August 10th 2:00 PM at NZDT , 12:00 PM at Brisbane = 9th August 10:00 PM EST Fri  August 10th 12pm – 1pm Brisbane, AU Timezone (GMT+10) (= Read more about My Session at Pass DW and BI Chapter – SSIS Catalog; Big step for ETL Framework[…]

SSIS Catalog: Part 4 – Execution

In previous blog post of SSIS Catalog series, I described folder hierarchy. In this post I will explain tables which deals with execution of packages and projects. At the time of package’s execution, you can map environment variables to package’s parameters, set values to the connection string’s properties, set package’s property values, and set 32bit run Read more about SSIS Catalog: Part 4 – Execution[…]

SSIS Catalog: Part 3 – Folder Hierarchy; Folder, Projects and Packages

In previous post of SSIS Catalog series, I’ve explained how to create SSIS catalog and configure properties. In this post I talk about Folder hierarchy in SSIS catalog, and different parts of folder hierarchy: Folder, Projects, packages and Environment Variables. SSIS Catalog contains folders, in each folder there can be one or more projects. each Read more about SSIS Catalog: Part 3 – Folder Hierarchy; Folder, Projects and Packages[…]

SSIS Catalog: Part 2 – How to Create Catalog?

In previous post of SSIS Catalog Series, I explained what is the SSIS Catalog. In this post I will explain how to create SSIS Catalog. To Create SSIS Catalog you first need to install SQL Server 2012. after installation open SSMS and right click on "Integration Services Catalogs" node and select "Create Catalog" In the Read more about SSIS Catalog: Part 2 – How to Create Catalog?[…]

SSIS Catalog: Part 1 – What is the Catalog?

In this new series of posts I will explain SSIS Catalog of Integration Services 2012. Part 1 – What is the Catalog? SSIS Catalog is a new repository model for Integration Services, which introduced from SQL Server 2012. This new repository model brings a lot of abilities for developers, testers and administrators.  SQL Server Integration Read more about SSIS Catalog: Part 1 – What is the Catalog?[…]

Interview with Packt Publishing

Script of my interview with Packt Publishing about my latest book Microsoft SQL Server 2012 Integration Services: An Expert Cookbook. published on PacktPub website here. If you want to read more details about the book read this post. here you can read full story: Interview with Reza Rad , Author of ‘Microsoft SQL Server 2012 Read more about Interview with Packt Publishing[…]

SSIS 2012: Execute Package from Another Project

Execute Package Task in SSIS 2012 has ability to use Project Deployment Model. With selecting Project Reference type as ReferenceType we can select any of packages But just from current project. This post shows a way to run package from another project in SSIS 2012. There are some ways to run a package in SSIS Read more about SSIS 2012: Execute Package from Another Project[…]

Book Published: Microsoft SQL Server 2012 Integration Services: An Expert Cookbook

Hi folks, As I mentioned previously,َ Today I am happy to inform you that my book on SSIS 2012 published already, Me (Reza Rad) with my friend (Pedro Perfeito) who is another SQL Server MVP from Portugal wrote a book on SSIS 2012,we had Phil Brammer as technical reviewer. and book published already, If you Read more about Book Published: Microsoft SQL Server 2012 Integration Services: An Expert Cookbook[…]

My Presentation on New Features of SSIS 2012 – Auckland SQL User Group

Hi folks, I had a presentation on New Features of SSIS 2012 on Auckland SQL User Group at Microsoft NZ venue at 16 May 2012. in following you will find more details about my presentation Session Topic: New Features of SSIS 2012 Description: SQL Server Integration Services (SSIS) is a leading tool in the data Read more about My Presentation on New Features of SSIS 2012 – Auckland SQL User Group[…]

My Session at SQL Saturday 136 – New Features of SSIS 2012 (Presentation and Demo)

Hi folks, April was busy month for me, I was finishing the book from one side, preparing presentation for SQL Saturday 136 and attending at Microsoft exam from other side! SQL Saturday 136 ran at 14 April at Wellington – New Zealand with 14 session, and that was good opportunity for me to meet Rob Read more about My Session at SQL Saturday 136 – New Features of SSIS 2012 (Presentation and Demo)[…]