12 Jun 2015
By Allen
0 Comments

SSIS Error

Microsoft SQL Server, SSIS
Recently at a client, the SSIS Server was giving an error message which I had never seen before every time I tried to run a package. Changing protection level: Success Message: An error occurred in the Microsoft .NET Framework while trying to load assembly id 65537. The server may be running out of resources, or the assembly may not be trusted with PERMISSION_SET = EXTERNAL_ACCESS or UNSAFE. Run the query again, or check documentation to see how to solve the assembly trust issues. Googling this error led me to some old SQL 2005 and 2008 articles relating to proxy accounts,…
Read More
11 Mar 2014
By Allen
0 Comments
How to set OLE DB Source data in SSIS

How to set OLE DB Source data in SSIS

SSIS, , ,
Sometimes I have to learn things repeatedly before it sticks.  I re-learned this tip from Tim Costello at last night's Oklahoma City SQL User Group presentation.  We will get his presentation up soon. First, a big thank you to Tim Costello for coming to Oklahoma City to speak at our user group.  Check out his site for more tips.  This tip was just one tidbit from his presentation "Pro Tips: Tuning the data flow in SSIS".   Watch for him at a SQL Saturday near you.   Why you need to set IsSorted property on the OLE DB Source When preparing…
Read More
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
05 Jun 2012
By Allen
0 Comments
SQL Rally 2012 BI Track Highlights

SQL Rally 2012 BI Track Highlights

SQL Server, SSAS, SSIS, SSRS, , , , , , , ,
When I got back from SQL Rally 2012 a few weeks ago in Dallas, I shoved the notes into my laptop bag and took off for vacation.   I still want to share a few of the highlights of my trip.  These were some excellent speakers and I hope to see them again at future events. Sessions: Tuning Analysis Services Performance by John Welch Presentation John did an excellent job of explaining the basics of the processing options in SSAS. What was interesting was his experience splitting up jobs to increase performance.  Process Full will process all the dimensions and facts…
Read More
18 Mar 2011
By Allen
0 Comments

Learning the Microsoft BI Stack: SSRS

Microsoft SQL Server, SQL Server, SSIS, SSRS
I've been learning and working with IBM Cognos since it arrived on my desk in 1999.  It was an ugly brown box labeled Cognos 5.5.  Since then I've studied and learned 6.x then 7.x and finally made the painful transition to 8.x. Now I'm studying both the Microsoft Business Intelligence stack (SSAS, SSIS and SSRS) along with learning the new Cognos 10. I just want to list two WROX titles which are the best I've found for getting up to speed quickly. For learning SQL Server Reporting Services (SSRS) go get the Professional series book 'Microsoft SQL Server 2008 Reporting…
Read More