Wow, this video is hilarious. This was made by Microsoft UK and shows a number of developers getting zapped anytime a bug is tracked back to them. It's a bit of a geek must-watch.
Video link here.
-- Brian Knight
I've been slowly writing over the past few weeks because I'm writing an upcoming class on Feb 20-23rd on SSIS and SSAS in Jacksonville. The class will be an ongoing class that will be given but its normal price will be more than two times what we’re offering it for on these 4 days. For this class, you can attend all four days for $984. I’m writing the material and giving the class myself and have attached the outline below to give you an idea of what we’ll be covering. There are a total of 16 seats in the class so it should be a great environment for you to get your fill.
Attendees will receive two books (one that I’m quite partial to):
Applied Microsoft Analysis Services 2005 : And Microsoft Business Intelligence Platform
http://www.amazon.com/exec/obidos/tg/detail/-/0976635305/ref=ord_cart_shr/104-7547408-2281516?%5Fencoding=UTF8&m=ATVPDKIKX0DER&v=glance
Professional SQL Server 2005 Integration Services
http://www.amazon.com/exec/obidos/tg/detail/-/0764584359/ref=ord_cart_shr/104-7547408-2281516?%5Fencoding=UTF8&m=ATVPDKIKX0DER&v=glance
If you’re interested, please register fairly quickly since it’s about 1/4 full already. To register or for more information, please call or email Amanda Napolitano (see contact info in the below flyer):
-- Brian Knight
Of course this may seem simple to a lot of you but I keep seeing this question so I thought I'd post it for the Google monster to help others. When you open the Bulk Insert Task for example, the DestinationTable is a drop-down box. This is fine except in the scenario where you must point to a table that was created in an earlier step of the control flow. To do this, just leave the DestinationTable property blank after configuring the rest of the task. Click OK and you'll notice a red icon on the task where it looks like it has an error due to lack of configuration. Select the task and go to the Properties pane. Now, you can set the DestinationTable property through the pane by typing in the table that will be created in the future. After you set that property in the pane, the red icon disappears and you're ready to roll.
This works for almost any property with almost any task or connection.
-- Brian Knight