In a previous article I showed how you can create dynamic security in SSAS. This is a great way to make all security table based using Active Directory accounts associated with the items that the user is allowed to see. If you decide that your security model is pretty basic and it is not necessary to implement the table based security then you should be aware of a side effect of having multiple Analysis Services roles. The side effect I’m referring is having a user that falls under multiple role...
Read More
I have found often when teaching SSIS to others that it can be extremely confusing when you first encounter SSIS data types. At first glance they seem to be nothing like SQL Server data types you love and know. That's why I've provided below a conversion chart of SSIS data types to SQL Server data types. This information is readily available on MSDN but it always seems difficult to find. Hope this helps! SSIS Data Type SSIS Expression SQL Server single-byte signed integer (DT_I1) two-byte signed...
Recently Adam Jorgenson wrote a blog post titled Come be your best at Pragmatic Works , which described the work environment at our company and how we have many positions are available now at varying experience levels. One thing that I’ve noticed when talking to people about applying with us is that they think they are not qualified but right now we’re hiring at all levels. The main thing we are looking for is that there is a passion to learn Business Intelligence and SharePoint. I thought this ...
In several previous posts I have described some of the usability changes that will come with the next release of SSIS. Annotations Data Flow Grouping Resolve Reference Today I’m going to introduce you to the Source and Destination Assistants that has been added to the Data Flow. The idea behind these assistants is to make it easier for new comers to SSIS to get started faster. Instead of the developer having to choose from the list of sources or destinations in the Data Flow they can simply user...