<![CDATA[Article Comments for David Pruden]]>http://www.sqlmag.com/authors/author/author/5535997/rsscomment/5535997en-USFri, 25 May 2012 11:13:51 GMTFri, 25 May 2012 11:13:51 GMTUsing SSAS and SSIS to Build an IIS Web Log Cubehttp://www.sqlmag.com/article/sql-server-analysis-services/using-ssas-and-ssis-to-build-an-iis-web-log-cube#commentsAnchorMon, 31 Jan 2011 18:45:05 GMT
I have recently updated this process to analyze SharePoint logs. I now use Microsoft’s Log Parser (http://www.microsoft.com/downloads/en/details.aspx?FamilyID=890cd06b-abf8-4c25-91b2-f8d975cf8c07&displaylang=en) to parse the web log files to a csv which I load then load into the SQL database. It is much cleaner than the previous process for loading the log files.]]>
PrudenMon, 31 Jan 2011 18:45:05 GMThttp://www.sqlmag.com/article/sql-server-analysis-services/using-ssas-and-ssis-to-build-an-iis-web-log-cube#commentsAnchor
Self-Service Subscriptionshttp://www.sqlmag.com/article/reporting2/self-service-subscriptions#commentsAnchorThu, 19 Apr 2007 12:33:53 GMT
This is great for creating subscriptions, however, when a user tries to modify an existing subscription, the following error is encountered: A subscription delivery error has occurred. (rsDeliveryError) Get Online Help One of the extension parameters is not valid for the following reason: The account you are using does not have administrator privileges. A subscription cannot be created for . (rsInvalidExtensionParameter) Get Online Help If I manually change the TO field in the XML to the NTUsername, the subscription can easily be updated.]]>
ChrisThu, 19 Apr 2007 12:33:53 GMThttp://www.sqlmag.com/article/reporting2/self-service-subscriptions#commentsAnchor