November 2012 Entries

Missing feature in Hyper-V from Virtual PC

One thing I really miss is the ability to create shared folder between host and guest. Virtual PC does this well, you can create Shared Folder to be used every time, or just this one. I have read some posts on how to do this. Some people suggest using ISO Creator to package up the files and mount the image to DVD drive, but what I need is truly a "shared" environment, so I'm currently looking into creating Virtual switch and creating an internal network between the host and guest. Let's see how that ......

Posted On Wednesday, November 28, 2012 1:46 PM | Comments (0)

To Virtual or Not to Virtual

I recently made a comment "I hate everything virtual" while responding to a SQL server performance question. I then promptly fired up my Hyper-V development environment to do my proof of concept stuff, and realized that I made the cardinal sin of making a generalized comment about something, instead of saying "It depends". The bottom line is if the virtual environment gives the throughput that the server needs, then it is not that big of a deal. I just have seen so many environment set up with SQL ......

Posted On Wednesday, November 28, 2012 12:23 PM | Comments (0)

SSIS Catalog: How to use environment in every type of package execution

Here is a good blog on how to create a SSIS Catalog and setting up environments. http://sqlblog.com/blogs/ja... Here I will summarize 3 ways I know so far to execute a package while using variables set up in SSIS Catalog environment. First way, we have SSIS project having reference to environment, and having one of the project parameter using a value set up in the environment called "Development". ......

Posted On Thursday, November 22, 2012 6:59 AM | Comments (2)

SSIS 2012 formating quirks

There are so many funny quirks in SSIS 2012 that I have to list them, to save other people from the misery. If you want to move items to one direction, make sure you "grab" the opposite side. For example, you want a whole bunch of data flows to move up, select them all and grab the lowest item. When you drag the arrow to connect Precendence Constraint, make sure you drop it on the area of target that has no text, otherwise, it thinks you want to edit the text and change the target item layout ......

Posted On Wednesday, November 21, 2012 12:21 PM | Comments (0)

SSIS 2012 project.param Add Parameters to Configurations

Always was able to do it in a .NET application and a reporting project.  This took me a while to realize.  In SSIS 2012 project, once you create project.params, you can add them to your configuration settings by clicking this button

A dialogue pops up where you can add your project params and specify their values in different configuration set.

Posted On Wednesday, November 21, 2012 11:24 AM | Comments (0)

Using stored procedure to call multiple packages at the same time from SSIS Catalog (SSISDB.catalog.start_execution) resulted in deadlock

Refer to my previous post (http://geekswithblogs.net/... about dynamic package calling and multiple packages execution in these posts: I only saw this twice, other times the stored procedure was able to call the packages successfully. After the service pack, I haven't seen it...yet. http://support.microsoft.co... ......

Posted On Wednesday, November 21, 2012 10:45 AM | Comments (0)

Time to stop using “Execute Package Task”– a way to execute package in SSIS catalog taking advantage of the new project deployment model ,and the logging and reporting feature

I set out to find a way to dynamically call package in SSIS 2012. The following are 2 excellent blogs I found; I used them heavily. The code below has some addition to parameter types and message types, but was made essentially derived entirely from the blogs. http://sqlblog.com/blogs/ja... http://www.ssistalk.com/201... The code: Every package will be called by a ......

Posted On Wednesday, November 14, 2012 2:20 PM | Comments (2)

Deploying SSIS to Integration Services Catalog (SSISDB) via SQL Server Data Tools

There are quite a few good articles/blogs on this. For a straight forward deployment, read this (http://www.bibits.co/post/... For a more dynamic and comprehensive understanding about all the different settings, read part 1 (http://www.mssqltips.com/s... and part 2 (http://www.mssqltips.com/s... ......

Posted On Thursday, November 8, 2012 10:05 AM | Comments (0)

Windows 8 and "Formerly known as Metro" apps, an experience with PDF app

I'm slowing and surely getting used to Windows 8. It is no doubt a slow process since I still run daily on an XP machine, a Vista machine, and 3 windows 7 box. A new quirk I found regarding Windows 8. I never thought it was important to learn how to close a "formerly known as Metro" app (what do we call those these days?). Then I attached a portable drive to my laptop and opened up a PDF file, and I couldn't safely remove the hard drive afterwards because I did not know how to close the PDF reader ......

Posted On Wednesday, November 7, 2012 10:26 PM | Comments (4)

Subversion BI experience - not a very good one, but working now

Suffice to say there is now a document in place and I'm the drill sergeant, harassing people to do proper check in, and throw out those who don't.Some people suggest that in a SSIS project, it doesn't really matter if developers don't have the latest version of the project since package check in put the package in the repository, which we can pull out later. I beg to differ because:When people don't see the package, they might start creating one because their user story require the use of the table. ......

Posted On Saturday, November 3, 2012 8:42 AM | Comments (0)

Copyright © Kevin Shyr

Design by Bartosz Brzezinski

Design by Phil Haack Based On A Design By Bartosz Brzezinski