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[…]
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[…]
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?[…]
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?[…]
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[…]
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[…]
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[…]
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[…]
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)[…]
Hi folks, the event schedule of SQL Saturday 136 of ANZ 2012 defined already, This event will be in Wellington at 14 April, Agenda of 14 sessions listed here. You can register for this free tutorial day of SQL Server and enjoy it. there are a range of good SQL Server speakers there which I Read more about My Session at SQL Saturday 136 Wellington[…]