Blog Archives

Memory monster SSIS Sort transformation

For a while I had an SSIS package being unable to complete in the production environment but which worked perfectly in development. To make matters more interesting the package will not always fail… oh! “Welcome back!” That was what I

Tagged with: , ,
Posted in Errors, SSIS

Excel Macro to update filter

User: Can we make this month filter to have by default the year to date months selected? Me: … well… I guess I can have a look at it Inside of me: Back to VBA… after 12 years… So I

Tagged with:
Posted in Errors, Excel

SSAS Deployment Wizard Error

This error occurs when you are trying to use the SSAS Deployment Wizard, typically when wishing to deploy a staging/development SSAS database to production. The wizard is unable to complete the deployment with the following error message: “08001: Named Pipes

Posted in Errors, SSAS

Inbound Rules and SSAS

Like SSRS, SSAS also needs to be allowed to be contacted from the outside throught the Windows Firewall. In my case I have one dedicated server (A) for SSAS and a separate server (B) for SSIS and DBS. Is in this

Posted in Errors, SSAS

SSIS SharePoint List Source Authentication Error

If you have the need to extract data from a SharePoint list into a SQL Server table most probably your are using (or tried to) the SharePoint List Source and Destination components available in CodePlex (http://sqlsrvintegrationsrv.codeplex.com/releases/view/17652). And maybe you had

Tagged with: , , , ,
Posted in Errors, SSIS

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 24 other followers

Categories