17 Aug 2013
By Allen
0 Comments
SSIS 2012 Parameters vs. 2008R2 Configurations

SSIS 2012 Parameters vs. 2008R2 Configurations

Microsoft SQL Server, SSIS, , , ,
Update 8/17/2013: The SSIS Project downloads have been updated below. Abstract: In this session, Allen Smith, Business Intelligence consultant, compares SSIS Parameters in SQL 2012 to SSIS configurations in SQL 2008R2. The 2008R2 options allowed dynamic configuration across environments.  In SSIS 2012 we review the new dynamic options, including Parameters and Catalogs. This upgrade takes SSIS from simply confusing to downright confounding. We will simplify these options so anyone with basic SSIS experience can follow along. Special thanks to our friends at GDH Consulting for hosting the December meeting of Oklahoma City SQL User Group. SQL Integration Server developers need…
Read More
10 Apr 2013
By Allen
0 Comments
Getting SQL data into SharePoint

Getting SQL data into SharePoint

BI/DW Projects, Microsoft SQL Server, , , , ,
In March, I was invited to speak at the OKC SQL Users Group and I never got the slide deck posted. So here it is to help get you started. Sharing SQL data in SharePoint from Allen Smith Session Level:  Beginner SQL and Beginner SharePoint Session Abstract:  Microsoft SharePoint is a collaboration software that provides a web based portal for business intelligence, content management and document sharing. In this session we will start with the basics of sharing a SQL table as a 'List' in Sharepoint. Next we move on to fun stuff of integrating SQL Server Reporting Services integration.…
Read More