May 2009 - Posts

• Thursday, May 14th, 2009, 6:30 PM - 8:00 PM

  When: Thursday, May 14th, 2009, 6:30 PM - 8:00 PM Social Time starts at 6:00 PM!   Who:  Steve Fibich What: SSIS Scripting and SSRS WebServices So we have all moved a little data from point A to point B in SSIS or DTS but what else can we do? What about web services?  Have you ever pointed the control flow web services component at a WSDL only to be told “This version of the Web Service Description Language is not supported”?  I’ll show you how you can handle it (or at least the web services related to Reporting Services) using script tasks in SSIS.   This presentation focuses on getting web service into a data flow using a scripting task and calling web services from a control flow script task.  This presentation is from the DBA perspective not an experienced .Net programmer’s perspective.     About Steve:   Steve Fibich currently works in Richmond VA at PFGC as the Systems Architect on a Master Data Management project utilizing SQL Server 2005 and SSIS 2005 pulling data from iSeries, Unix, VAX, and SAP for a massive system integration effort. He has been working with SQL Server since 6.5 building Data Warehouses, building integration systems for third party product integration, creating Master Data Management systems , and doing general DBA work for the past 10 years. Where:  Location: Markel Plaza 4600 Cox Road Glen Allen, VA 23060 [map] Register: Click here to register! This Months Sponsor: Posted May 05 2009, 07:50 AM by fibrock with no comments Filed under: Meeting Info, Steve Fibich

• Thursday, April 23rd, 2009, 6:30 PM - 8:00 PM

  When: Thursday, April 23rd, 2009, 6:30 PM - 8:00 PM Social Time starts at 6:00 PM!   Change In Plans!  Who:  Andy Leonard    What: Database Development Andy Leonard demonstrates obvious and not-so-obvious techniques of SQL Server database development.      About Andy: Andy Leonard is not Donald Farmer. :) Andy is, however, a SQL Server database and business intellgence developer. He owns a car. His favorite color is blue and he prefers cyberpets to the real thing. If this sort of humor appeals to you (along with talks about database development), join Andy at Richmond SQL Server Users Group! Where:  Location: Markel Plaza 4600 Cox Road Glen Allen, VA 23060 [map] Register: Click here to register! This Months Sponsor: Posted May 05 2009, 05:00 AM by fibrock with no comments Filed under: Meeting Info