November 2012 Entries
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 ......
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 ......
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". ......
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 ......
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.
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... ......
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 ......
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... ......
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 ......
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. ......